Answered

Checking if a row exists in Excel

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am writing an approval from a Forms submission. When the submission is made, I want to compare the ID number there to see if it is in a particular Excel sheet. If the ID number is found in the Excel sheet, then email the respondant and the flow ends. If it is not in the spreadsheet, I want to start an approval for thier entry. I'm stuck. Any help out there?

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Verified answer

PhilippeR 87 on at

Like
a
(2)

Report
Copy link

Link copied!

Get a row, will find your row.
Then add // branch to handle error.
One run after success (left one) and the other run after Has failed
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. I knew I was trying to make it too complicated. The best solutions are often the simple ones.
DragonLord 200 on at

Like
a
(1)

Report
Copy link

Link copied!

this works ok, but the flow does show as "Failed " due to the missing rows.
I would guess that if a flow fails too often it gets turned off?>