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

Create Approval Flow for Monthly Amount Submissions

Hello Everyone,

 

We have a SharePoint List on which we have developed an app using PowerApps. The list is containing 12 Columns for 12 Months for each item. Each Month has tree more fields to add the amounts for the specific months. The list looks like the below.

MonthAmount 1Amount 2Amount 3
Jan 2020500500500
Feb 2020500500500

 

The user can go to the PowerApp and add the Month Amount anytime.

 

The requirement is: I want that once the user enters the amount for the respective month, an Approval flow to be triggered. Once the amount is approved then user should not make any changes in to the filled values.

 

Conditions:

1. User can enter multiple months values at a time. 

2. The Approved amount to be freeze and rest of the months can be editable by the user. 

 

Can anyone please help that how to achieve this? I can provide more information if needed.

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @AkshayManke ,

 

For the requirement to start the approval, you could create a flow with trigger when an item is created or modified, and then you could add Condition under the trigger to check if all the Amount columns isn't empty, if all the Amount columns for the item isn't empty, start the approval.

For the requirement to freeze the Approved amount, sorry for there is no any function in Microsoft flow could achieve the requirement currently.

 

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.

View solution in original post

1 REPLY 1
v-alzhan-msft
Community Support
Community Support

Hi @AkshayManke ,

 

For the requirement to start the approval, you could create a flow with trigger when an item is created or modified, and then you could add Condition under the trigger to check if all the Amount columns isn't empty, if all the Amount columns for the item isn't empty, start the approval.

For the requirement to freeze the Approved amount, sorry for there is no any function in Microsoft flow could achieve the requirement currently.

 

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.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,299)