54 questions
1
vote
0
answers
22
views
PowerAutomate false URL generation with forms and Sharepoint/Onedrive Picture upload
I have a question.
I have several MS forms. These are connected to a powerautomate cloud flows. When i fill in the form and upload an image (mostly .jpg) the flows start and create and pdf from this ...
0
votes
0
answers
155
views
How do I account for multiple file upload questions in Power Automate?
Hello and thank you for checking out my issue. I created a Microsoft form to handle file review and approvals. In the form, I have 3 questions that allow file uploads. If the user selects "...
0
votes
1
answer
83
views
I am trying to streamline a Userform controls collection to hold only ComboBoxes. How do I delete controls from the controls collection?
Everything looks good in the watch window until the Remove instruction is executed.
No help to reverse the loop to step -1 from the end.
' ---------------------------------------------------------
' ...
0
votes
0
answers
35
views
How do I remove an item from an ms-forms Collection in Excel VBA [duplicate]
' ---------------------------------------------------------
' Remove non-ComboBox controls from the controls collection
' ---------------------------------------------------------
Public ...
0
votes
0
answers
254
views
Update or add and item to a Sharepoint list from MS Form response using power automate
I'm trying to use Power Automate to update/add a line item to a SharePoint list based off the response from an MS Form.
I can see in Power Automate that you can either add and item or update an item ...
0
votes
0
answers
553
views
Disconnect Excel Workbook from an MS Form
Due to recent changes by Microsoft regarding how MS Forms data synchronizes with Excel, we've implemented our own sync solution through Power Automate to ensure it's done automatically. However, this ...
0
votes
1
answer
308
views
Microsoft Form - Weekly trigger and reminder
I want one MS form to be sent every Monday of week to set of people and save response of that form at common place once someone submitted it.
However, if anyone fails to submit it by Wednesday then I ...
1
vote
1
answer
568
views
Encountering 403 Error While Trying to Access Microsoft Forms URLs, despite successfully obtaining the authentication token
I'm currently working on a project where I need to access various URLs related to Microsoft Forms from my Python backend. However, I'm facing a 403 error when attempting to do so. Here's a breakdown ...
0
votes
0
answers
211
views
Populating a MS Form from elements of a Sharepoint List with Power Automate on a scheduled basis
I have a Sharepoint list with dates and information. On specific dates, I would like to populate an existing request form (MS Form) with data from the Sharepoint List.
I think Power Automate can do ...
0
votes
0
answers
86
views
Using a custom controls DLL in a Windows Forms C# application
We are migrating a VBA application to a Windows Forms C# application. The old VBA application used a custom controls DLL provided by vendor. How do we use such controls (I guess MSForms) with Windows ...
0
votes
1
answer
79
views
VBA - How to make a sub tab control form appear in only a specific page of the main tab control form?
So, I have a main tab control form called TabCtl11. The side left bar menu; for example, when Dashboard Menu is clicked it correspond to the page1 of the main tab control and Report Menu when clicked ...
1
vote
1
answer
1k
views
Microsoft 365 Forms prefilled form with unique URL
I thought I had done this in the past, but is there a way utilizing Microsoft Forms that I can have a survey pre-filled out for at least one question and share that unique link to that survey?
Context ...
0
votes
1
answer
343
views
Microsoft Dynamics Embedded Code Not Working After First Attempt in Modal
I’m using embedded code from Microsoft Dynamics in a modal. The first time I open it, it works correctly. However, on subsequent attempts (second, third, etc.), it stops working. Could someone explain ...
0
votes
0
answers
45
views
Troubleshooting SQL Server date insert defaults to 1900-01-01 from Power Automate
I am currently working on automating a process where clinicians' end dates for their clinics are updated in our SQL Server database. The data flows from an MS Form to SQL Server via Power Automate.
...
1
vote
1
answer
307
views
Duplicate questions in microsoft forms answers downloaded in excel
I have a rate colour form where the user has to rate colours based on their liking and their mother's liking.
This is my form
But the problem is when I download the response here in Excel the ...
0
votes
0
answers
45
views
How to make a ms form accessible for Teams meet attendees only
Good day everyone
I am looking for a solution to give a ms form access to a teams meet attendees only.
Currently i am copying the MS Forms link and pasting it in to teams chat.
But since the form is ...
0
votes
1
answer
2k
views
How to Extract URL and add hyperlink from file uploaded in Microsoft form into Excel online by using Power automate
i have a simple form that have 4 question, that 3 questions need upload file (question 2 is Mandatory)
I try to create the flow to save the ms form data to excel online.
How to extract the URL only ...
0
votes
0
answers
92
views
Auto Increase in Excel Formula when a Microsoft Form is filled
I have created a form in MS Excel, which automatically populates a file in my OneDrive Business. So for Example when ever someone will fills out the form it will populate a row in an excel sheet (this ...
0
votes
0
answers
1k
views
Split multiple choice answers (MS Forms) to separate columns in Excel with Power Automate
It seems that this has already been explained but I'm pretty new to Power Automate and couldn't understand the answers...
I created a form with single choice and multiple choices questions and would ...
0
votes
0
answers
2k
views
Power Automate Flow is not showing up to add it to a Solution
I have created a Automated Power Automate Flow to send a Customer Voice Survey when an opportunity is modified.
I added Customer Voice trigger in the Flow.
I'm trying to add it to a solution but it is ...
0
votes
1
answer
186
views
Export option is not available for the Customer Voice project
I have created a Customer Voice project but the Export option is not available.
Providing the image reference got from an article.
Can anyone help me why the option is not available for me and what ...
1
vote
2
answers
326
views
Is there a way to remove the calendar from date questions in Microsoft forms?
I have a Microsoft form that I am sending out to clients. I've gotten feedback that the calendar in the date-based questions is confusing and hard to work with. Is there a way to remove the calendar ...
0
votes
1
answer
2k
views
Power Automate: How to get response from form in key-value (field-name:field-value) format?
I have a simple workflow implemented in Power Automate.
A user fills out a form, and it triggers my flow, where I extract a response and send it in an email.
I use following actions:
trigger: "...
0
votes
1
answer
273
views
How do I turn the result of a Microsoft Form (excel) into a Power Point Slide, one result per page/slide?
I am trying to create a form that will have the following text or image fields.
Rank
Full Name
Image
Birth Location
Service Dates
Branch
Story
Message
This form will go to an excel document.
I am not ...
0
votes
1
answer
43
views
Anomaly with MS Forms Focus Indication Using VBA SetFocus
By default, the MS Forms Control that currently has the Focus is Highlighted with a Dotted Rectangle
Setting the TakeFocusOnClick Property of a Control to FALSE prevents this; the Control's appearance ...
0
votes
1
answer
587
views
MS form is not loading the second time onwards and gives the console error
Issue: MS form is not loading the second time onwards and gives the below error.
Uncaught Error: MsCrmFormLoader is already defined, make sure Dynamics 365 Marketing loader.js script is not included ...
1
vote
1
answer
439
views
Error using "MSForms.Control" type of variable
I have been trying to run this code to get the caption of each control (a combobox in this example) on my form. But it keeps telling me "type mismatch". Please help. Thank you.
Private Sub ...
3
votes
1
answer
789
views
Javascript Check if MS Form in Iframe was submitted
I have a Web based Training where we'd like to embed an MS-Form as an Iframe into a page and via Javascript would like to enable the next page when the user has submitted the form.
Is there any way ...
0
votes
0
answers
886
views
How can I use power automate (flow) to get details from many MS Forms (all based off the same template) and put the responses in to a SharePoint list?
I have a number of forms I send out for a business group to approve / reject.
They are all based on a template (yes/no and why)
How can I use power automate (flow) to get the details from these MS ...
0
votes
0
answers
104
views
Suppress "Not Valid" Error message when adding text to number field
I'm doing the finishing touches of a MS access database, stuff revolving around input validation and error messages. I have restricted PlotSearch.value [textbox] to only accept numbers which works, ...
0
votes
0
answers
822
views
Automatically download MS Forms Data via VBA
I use a MS Form to collect Data and use an xlsm.file where I copy the new data and then further work with the data. In order to update the data, I have to
Open the Forms webpage
Click "Export ...
0
votes
2
answers
966
views
MS Access Form Cascade Combo Box
Let me preface this by acknowledging I'm a database, SQL and VBA newb. I've been tasked with hacking together something for which there is not external budget.
I'm having issues setting up a simple ...
1
vote
2
answers
300
views
How to return 0 if blank
I'm trying to ignore blank values, the below code takes dropdown.value which is a string, then look up that value and pull a number next to it in a different table.
The code works if all dropdowns are ...
1
vote
0
answers
78
views
How to style html input elements (radio buttons and ckeck-boxes) for print out of Microsoft Forms
I use Microsoft Forms for assessing my students online.
I then need to print out (can't be digital) each single result to correct them and send the back.
However, the radio buttons and check boxes ...
2
votes
1
answer
3k
views
Microsoft Power Automate "Switch" - Action not matching Case results
I have a flow with a switch control triggered by a form, where the switch depends on the answer to one of the questions (Single Choice + "Other" with an empty space, hence the "Default&...
-1
votes
1
answer
342
views
Passing a variable from one form to another
I created a login screen for my DB which works.
I would like to pass a variable to a text box that will be on the 'Main Menu' form once you're validated.
Here's my code when you click 'Login'.
'Login ...
0
votes
1
answer
274
views
How do I get different fonts in dynamically-generated text boxes?
When generating my form, I have code which looks something like this:
Set obj = Me.DataSetAuthor.Controls.Add("Forms.Label.1", fld)
With obj
.top = top
.Left = 5000
.Width = 20
...
0
votes
2
answers
3k
views
MS Access: Add attachment to record from Form field using VBA
I have a bounded form with property 'Data Entry = Yes' which has a multiple textboxes, and one field of type Attachment.
I have a "Save" button that prompts confirmation to save the record.
...
0
votes
1
answer
125
views
MS Access: double loop query with multiple conditions to display on Form
Let's try to phrase this properly, here is a summary of my relevant tables:
Table "students" containing student_id, first_name, last_name.
Table "courses" containing course_id, ...
0
votes
0
answers
154
views
Is there a way to select cells in an Excel row to auto-populate into cells in a separate Workbook each time a new row is added?
I need to send RFQs to various vendors using their specific forms which are Excel formatted. I need specific information from my co-workers in order to properly fill out the vendor's forms. I was ...
0
votes
0
answers
743
views
Get user data only works when MS Form is shared inside organisation
My Flow in Power Automate only works when the Microsoft Form is shared inside the organisation because it doesn't get Office 365 user data when shared outside. We work with another company so I need ...
1
vote
1
answer
68
views
How do I stop VBA userforms from extending beyond the window?
I am creating userforms in Excel. Every userform seems to extend 1-2 pixels too far to the right and bottom. Each form covers the 1 pixel black border surrounding each window, and it looks ugly. How ...
0
votes
1
answer
2k
views
Sending adaptive card to multiple users in Teams referencing Forms dynamic content
Based on the value of a question submitted in a Microsoft Form, I want to send an adaptive card to one or more people via Teams. I think I have the end steps figured out. I have the adaptive card ...
1
vote
0
answers
49
views
How to automate process using MS Power Automate
I have a process give below
1.user fills up the form with the attached files.
2.Based on the attached file, analyst will do the analysis and send it for approval
3.Approver will approve and send it ...
0
votes
1
answer
3k
views
Missing "List of response notifications..." in Microsoft Flow automation
I am trying to create a simple automation of survey data into an excel spreadsheet. Based on other how-tos, it should be as simple as adding the form and workbook then mapping the fields from the form ...
0
votes
1
answer
501
views
How to generate and handle internal IDs in Microsoft Forms 365
I am trying to implement an evaluation survey for meetings, using Microsoft Forms over Office 365.
After I create and generate the link, I can get the info in an Excel file, but am missing a field ...
1
vote
2
answers
2k
views
Embedding MS Form iframe scrolling="no" does not work
I am trying to embedthis MS Form into SquareSpace but I get 2 scroll bars in the page (one for browser and one for this form).
<iframe width="460px" height= "1000px" scrolling="no"
src= "...
0
votes
1
answer
420
views
PowerBI dashboard to be emailed as a PDF on trigger from MS Forms submission
I am trying to get a survey response plotted on a Powerbi page. Survey questionnaire is built in MS Forms, response values get stored in an Excel on OneDrive and are piped in as a dataset into a ...
2
votes
1
answer
3k
views
How to create MSForms ListBox in Worksheet using VBA?
I'm trying to create a list box of the type MSForms.ListBox programmatically using VBA.
I can't do it with Set ListBox = New MSForms.ListBox because it throws the compile error: Invalid use of the ...
0
votes
1
answer
3k
views
Textalignment in a Textbox in VBA - strange behaviour
I'm trying to align text in a textbox to the right side. Either through code TextBox.TextAlign = fmTextAlignRight or setting the property "directly".
Unfortunately, it becomes left-aligned as soon as ...