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.

View solution in original post

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.

Top Solution Authors
Users online (1,227)