Thank you for choosing Microsoft Community.
Here’s a step-by-step guide:
Trigger: Use the "When a new response is submitted" trigger for Microsoft Forms to start the flow when a form is submitted.
Get Response Details: Add the "Get response details" action to retrieve the form response.
List Rows Present in a Table: Use the "List rows present in a table" action for Excel Online (Business) to get the existing values from the "name" column in your Excel file.
Condition: Add a "Condition" action to check if the number from the form response exists in the "name" column.
Condition: contains(outputs('List_rows_present_in_a_table')?['body/value'], <number_from_form>)
Add Row: If the number does not exist, use the "Add a row into a table" action to add the new number to the Excel file.
Here’s a more detailed breakdown of each step:
Trigger:
Select "When a new response is submitted" from Microsoft Forms.
Choose your form from the dropdown list.
Get Response Details:
Add the "Get response details" action.
Select your form and use the dynamic content to get the "Response ID".
List Rows Present in a Table:
Add the "List rows present in a table" action.
Select your Excel file and table.
Condition:
Add a "Condition" action.
In the condition, use an expression to check if the number exists in the "name" column.
Example expression: contains(outputs('List_rows_present_in_a_table')?['body/value'], <number_from_form>)
Add Row:
If the condition is false (the number does not exist), add the "Add a row into a table" action.
Select your Excel file and table.
Map the form response to the "name" column.
This should help you create a flow that checks for the existence of a number before adding it to your Excel file.
If this Post helped you, please click "Does this answer your question" and like this post to help others in the community find the answer too!
Happy to help
Robu 1
32
Share
Report
All responses (
Answers (
