SharePoint List - When column (Status Type changed to approved) is updated, I want it to update 2 other columns automatically - Approve changes to Yes; StatusText changes to Approved

Question

In a SharePoint list - When column (Status Type changed to approved) is updated, I want it to update 2 other columns automatically - Approve changes to Yes; StatusText changes to Approved

Answer 1

Dear @Beant Lallh, 

Based on my understanding and the tests I performed, kindly try these following steps:

• Create a new Automated cloud flow > Choose Trigger > When an item is created or modified (SharePoint). > Create

In Trigger > select your SharePoint site address and the List Name of that SharePoint site

• In Trigger > Settings > Trigger conditions > Add:

@equals(triggerBody()?['StatusType']?['Value'], 'Approved')

• Add new Actions > Condition > follow the underneath image
• In True Branch > Add Action > Choose Update item
• In Update item > follow the underneath image
• 
• In False Branch > Add Action > Choose Update item
• In Update item > follow the underneath image
• After the above steps > Save and return to the SharePoint site to add new item to check if the flow run

The Q&A forum has limited coverage for Power Automate, so if those steps do not resolve the issue, kindly raise your case in the Power Apps Community for dedicated assistance: Find Answers | Microsoft Power Platform Community. Also, because this flow has some information cannot be shared in this community because it contains personal information, so in case you need someone who can help directly, kindly ask your Global Admin to submit a ticket in admin center.

I’m really glad I had the chance to assist you because this is quite an interesting topic. It’s a small feature, but it can significantly impact the user experience. I truly appreciate learning about this issue through you.

Answer 2

I tried this, I keep getting an error message.

Answer 3

Dear @Beant Lallh, 

Thank you for posting your question in the Microsoft Q&A forum.  

Could you confirm if you are currently creating a flow in Power Automate? 

Please help me share: 

The exact error message you are seeing and, if possible, a screenshot of the error.  The actual column types for these fields in your SharePoint list: 

• Status Type 
• Approve changes 
• StatusText 

If you prefer an easier alternative instead of using Power Automate, you can create calculated columns in your SharePoint list. This approach automatically displays the desired values based on the Status Type without needing a flow.   

Approve changes (Calculated):  =IF([Status type]="Approved","Yes","No") 

Status text (Calculated):  =IF([Status type]="Approved","Approved","") 

You can consider trying this method if it meets your requirements. Also, give me error message and column types if you want to continue using Power Automate. 

Looking forward to your reply!  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 4

running another flow that works:

Answer 5

Hi - I decided to run this flow after 5:00pm not to interfere with my 1st flow (email approvals, etc), this seems to have worked. Thank you for your assistance.