Unanswered

Updating row in excel table

(0) Share

Report

Posted on by pisbilir

I have a flow that simply validates an excel sheet with contact information such as full name, email etc.., the flow is supposed to connect to the excel sheet, search for users based on the emails provided in the table, if the email matches the email address in outlook then it should update a cell with the string "active user" if not it will update a cell with the string "needs" updating. The key column is a column called Active User?

I have every cell in that column set to 000 as the key value in the script is set to 000.
When I run the script I get an error that says the column already contains the string active user but when i check to see if the excel sheet updated, it has not.

Why would this happening?

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

pisbilir 10 on at

Like (0)

Report
Copy link

Link copied!

Heres the error message attached

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @pisbilir ,

The output of Search for users(V2) is based on the users found in the email you provide in Excel, so you should determine whether this output is empty to determine whether users are found. You can try my test method:
emptyExpression:empty(outputs('Search_for_users_(V2)')?['body/value'])

Hope this helps you!
-----------------------------------------------------------------------------------------------------------------------------------
If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,
Rimmon Li

Was this reply helpful? Yes No