Check if a value exist in excel then update row value

(0) Share

Report

Posted on by Majingcth

I tried a few flows but they failed

I have a table with 2 columns only as below. I am getting 2 variables from an email, which are Tran_No and Status.

My flow I would like to check if the variable Tran_No exist in the excel table. If yes, update the new Status to existing Status column.

Can someone help please?

Tran_No	Status
12345	In Progress
12346	In Progress
12347	In Progress

My flow:

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

abm abm 32,975 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Majingcth

Please see this solution which I provided for another post.

https://powerusers.microsoft.com/t5/Building-Flows/Update-Row-Automatic-adding-numbers-in-the-same-row/m-p/356448#M39570

If you need any further help please let me know.

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

Was this reply helpful? Yes No
Majingcth 47 on at

Like (0)

Report
Copy link

Link copied!

Hi @abm
i studied your post and tried mine, but still fail.

I trigger by input a Tran_No = 12347 and Status = Completed, I expect to update excel for row with Tran_No = 12347 only. Can you figure out my issue?

My update flow:

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (2)

Report
Copy link

Link copied!
Hi @Majingcth ,

Please refer to screenshot below to create the flow:

The expression in the Condition as below:

length(body('Filter_array'))

The expression for the Transaction No column in the Update a row action as below:

item()?['Transaction No']

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Majingcth 47 on at

Like (0)

Report
Copy link

Link copied!

@v-alzhan-msft ,

Great, I tried it, it works. Thanks.

However, 1 more question.

When there is a Tran_No found in the list, and there status is already 'Completed', if the new Status is 'In Progress', I would like to keep it as 'Completed' and not update 'In Progress' to the row, how can this be done?

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @Majingcth ,

If your asking problem has been solved, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

And if you have another question, please post the new questuion in the flow forum for other users to easily identify.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No