cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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. 

6 REPLIES 6
Community Support
Community Support

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.

@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.

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.

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

I do not have the option to select "Get Rows", only "Get Row"

New Member

Try "list rows"

Helpful resources

Announcements
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (2,870)