cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sprinke
Level: Powered On

Check if value from form exists in Excel table

Hello, I'm just getting started with Flow.

 

I've created a form, in which people will submit their email address (among other things).

 

I would like to check if the email address exists in an Excel table (and then do some more stuff).

 

Not sure how to do this? I've tried Excel Get Row action, but the flow fails because no Id found. 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Check if value from form exists in Excel table

Hi @sprinke,

 

Do you want to check if an email address exists in an Excel table?

 

Please try to use the action Get rows instead of Get row, then add a condition to check if the submitted email address exists in the Excel table.

 

I have created a flow to check if the email address exists in the Excel table, if no, insert a row in the table.

 

After the trigger When a new response is submitted, Initialize variable, type set as String.

 

Add the action Get response details, then Get rows from the Excel table.

 

Add an action Select, select the email address from the table.

 

Then the action Set variable, value set as:

Body(‘select’)

 

Add the Condition, if the email variable contains EmailAddress, do nothing, if no, insert it into the excel table.

 

Please take the following screenshots for a reference.

1.PNG2.PNG3.PNG

 

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sprinke
Level: Powered On

Re: Check if value from form exists in Excel table

@v-yamao-msft,

 

Thank you for your kind reply.

 

I am trying your example, but something is not working. I think I am getting mixed up in this step.

flow1.png

 

 

I don't know if I am mapping correctly, and I don't know what to set as the value of the variable in that next step. In your explanation, you wrote "Body('select')" but when I did that, it put the text string "Body('select')" as the contents of the variable.

Community Support Team
Community Support Team

Re: Check if value from form exists in Excel table

Hi @sprinke,

 

Under expression tab, please enter the code likes below:

1.PNG

Note: I just made another test, so the column name changed.

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kcf1982
Level: Power Up

Re: Check if value from form exists in Excel table

Get rows doesn't look like it exists anymore. What are my other options to do the same thing?

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users Online
Currently online: 461 members 6,059 guests
Please welcome our newest community members: