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.
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:
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.
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.
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.
Under expression tab, please enter the code likes below:
Note: I just made another test, so the column name changed.
Speakers, submit your sessions now! Call for speakers ends Feb. 10!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!