Answered

Flow to update Status Column in SharePoint

(0) Share

Report

Posted on by rameshmukka

1,121

I have status column in SharePoint list with Values (New, Open, Supplier Email Sent,Closed). The status is set to "Open" when a column "Procurement Comments" is added some data. And status is set to "Supplier Email Sent" when choice column "Send Email to Supplier" is set to Yes. I have one flow for each of them and they are doing the task fine as long they are working individually.

There are also scenarios where both columns "Procurement Comments and "Supplier Email Sent" of an item can be submitted at the same time. In that case my status column should take precedence for "Supplier Email Sent" and not "Open" How can I deal this in my flow? In this scenario my status column is updated to Open which should not be case. My trigger for both the flows are "When an item is created or modified".

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @RameshMukka ,

You could refer to screenshot below to create the flow:

The expression in the Condition as below:

empty(outputs('Supplier_Email_Sent'))

The expression in the Condition 2 as below:

empty(outputs('Procurement_Comments'))

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
tadahow 3 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Would this not update those fields left empty? I'm worried they will completely change all the data when I'm only trying to update the single column.

Thanks!

Was this reply helpful? Yes No
rameshmukka 1,121 on at

Like (0)

Report
Copy link

Link copied!

I have ended up changing whole flow with trigger "When an item or a file is modified" and had my own actions to run when a specific column is modified in my SharePoint list.

Was this reply helpful? Yes No