web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Verify data from Forms...

Power Automate - Building Flows

Suggested answer

Verify data from Forms to upload in Excel files

(0) Share

Report

Report

Posted on by Vkevin

32

Hey,

I'd like to create a flow that collects an answer (a number) from a Form, this answer is verified and sent to an excel file (a “name” column in a table). I'd like there to be a condition that checks whether or not the value exists in the column before adding it: If the number isn't present, add it. If the number is already present in the list, do nothing.
I've tried to reproduce this flow but I can't, I get an error message
Can you please help me?

Categories:

Business Process Flows

Capture d'écran 2...

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Robu1 1,419 Super User 2025 Season 2 on at

Like (0)

Report

Verify data from Forms to upload in Excel files

Hi Vkevin.

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

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 650 Super User 2025 Season 2

#2

Tomac 341 Moderator

#3

developerAJ 256

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans