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

excel get a row but fail

I use the "Get a row" on Excel Online to read 2 fields: ClientName and Location, which are used in the

Approval email.

excel.png

 

how to test that it finds the corresponding row in Excel?

So that, if it cannot find the row, set both ClientName and Location as empty.

 

Thanks,

Joe

1 REPLY 1
Highlighted
Dual Super User III
Dual Super User III

Hi @uogadmin 

 

You can configure a run after condition and then add a parallel branch for the run after on another approval action. PLease see the screenshot below:

ls.PNG

If you click the ... on the approval action 2, you can find the run after setting and set it as shown below:

ll.PNGThis will ensure that the when the item is not found in the get row, the approval two will kick off and you can configure those actions accordingly. You can add a terminate as scuccessful action after the approval 2 action so that the flow does not register it as failed when the item is not found in excel. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,036)