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.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!