cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AkshayManke
Continued Contributor
Continued Contributor

Check a Field Value in-Between when The Approval Flow is Started

Hi,

 

We are building an application using PowerApps (SP List at the backend) and for the workflows are using PowerAutomate.

 

After creating the Item in using PowerApps, a workflow gets triggered and request for approval. But parallel to the 'PowerAutomate Approval' we have created a screen in the PowerApps where an Admin can go and approve the request. 

 

The problem we are facing is that: Suppose the Admin approved the request then still the PowerAutomate approver can approve or reject the request which we don't want. We want that, if the item is approved by the Admin then the original approver should not change the status.

 

How can we achieve this?

4 REPLIES 4
JohnAageAnderse
Super User
Super User

Hello @AkshayManke 

In the situation that the Admin has approved the item, then when the Approver approves or rejects, reread the item and check if it is already approved and do nothing 🙂

Is that an option for you?

Kind regards, John

Hi @JohnAageAnderse,

 

Thanks for suggesting it, but i already tried the same. I added a condition in the approval reread after approve or reject. However it is not working as expected. I have attached the snap. Can you please share a snap or explain in details, what actions i have to add and where?

 

Capture.JPG 

Hello @AkshayManke 

The flow look fine, but the column AdminA... in Condition 2, what column type is that?

If it is a Yes/No column, then the operator should be "is equal to" and the comparision value should be true (an expression)!

 

You can always check what the actual values are after you flow has executed - just open the flow run and by expanding the actions, you should be able to see what the values are for the different columns.

Kind regards, John

Hi @JohnAageAnderse,

 

The column name is AdminApproved and the type is Choice with 'Yes' and 'No' value. By default it is 'No' but when Admin approves it, the value gets change to 'Yes' from PowerApps using Patch function.

 

While i am trying the solution suggested by you, i found that PowerAutomate is not recognizing the changed value as 'Yes' and it is showing 'No' value. Below the snap where i captured the value using Compose action in PowerAutomate. 

 

Capture.JPG

 

How can we tell PowerAutomate that the value is changed from 'No' to 'Yes'? I think that will resolve my issue.

 

Regards,

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,758)