I'm a little new to Power Automate/Flow. Basically what I've got a setup
I'm sure this is possible, but as I'm new to all this, I'm not sure how to accomplish this. Through a flow, Screenshots of a possible flow would be helpful, if possible.
The second option is the one I was trying before I posted here. I think its the best way to do it.
Here is a screenshot of my SharePoint list. The column; Proposed Budget & Starting CB... are where the figures get saved. 'Approval Change budget' is the trigger you were talking about. When an Approver goes into the App and changes the status of that column to Approved I want the flow to move it from Proposed Budget & CB.. in to Last Approved Budget & LA....
Does this help you?
I am afraid I will need some extra assistance, since your column names have special characters (spaces) meaning thir internal name will not be the same as the one displayed, and we need the internal name to design our flow!
So, our new flow shall make its magic whenever an approver changes 'Approval Change budget' choice column value to 'Approved' in any of the SP list items, right?
In such case, I would recommend you to:
1.- Add a 'When an item is created or modified' trigger
2.- Add a Condition action block:
-on the left side of your condition, click on 'dynamic content' and pick the column 'Approval Change budget'
-select as the operator 'equals'
-on the right side of your condition, add 'Approved' or whatever other text string you defined in your Choice column
Please hover the mouse over the left side of your condition to inspect 'Approval Change budget' internal name and share a screenshot with its internal name.
Save your flow, add a dummy item on your sharepoint list for testing purposes ('Approval Change budget' value shall not be 'Approved' yet). Once the item is created, modify column 'Approval Change budget' and select 'Approved'.
No go back and refresh your flow details page, verify your flow has been executed twice (first when you created the item, second when you updated it manually)
Once you share 'Approval Change budget' internal name, we will keep on with the design by adding 'Update item' to the true branch of your Condition.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.