If condition issue when used inside item field (status) of update item task

[mappleleaf]

Dear Members,

I want to compare a condition when item is changed or created using power automate. There are two fields in the list:status and reviewer. 

When the user changes the status of file to approve (user can choose, pending, approve, reject) for an item in the list, I want to populate the reviewer name automatically to reviewer column of the modified item using the power automate.

I created an automate flow once an item is changed or modified and then added an updated item. Inside the review row of update item, I am trying to write an if condition to compare status of item equals 'approve' then show the last modified person name.

How to write an query for it. I tried but power automate is not letting me write the query.

Could you please suggest how to write the query or suggest any alternative solution?

Thank you very much.

Regards,

ML

[v-qiaqi-msft · Accepted solution]

Hi @mappleleaf,

Based on the issue that you mentioned, do you want to update the reviewer based on the status updated?

Could you please share a bit more about the scenario?
I have made a simple test for you, please take a try as below.

1). Add the "When an existing item is modified" as a trigger.

2). Write a condition to filter out the record that your status column is equal to "approve". Note that in my scenario, I have a Choice type as example, so I select Managers Value. If your status column is a Text type, please select column name (like Managers in my scenario)directly.

3). Add the Update item action within the If yes bar. I have a Person column to save the modified user name.

Here is the result.