You’re offline. This is a read only version of the page.
Hi Everyone!
I am very new to Power Automate and have managed to get so far but could really do with some help in finishing my flow off to help me complete this quarters objective.
I am implementing a new procurement process. The data for each order required is currently captured via Forms.
Flow then pulls the data into a row on my procurement tracker and email is sent to me containing all the relevant information regarding the order for ease instead of having to open the table each time a procurement request is made.
The current flow process is below:
I have add in a column to my procurement tracker which allows me to update the order status of each procurement request. Listed below:
1. Ordered
2. Pending Approval
3. Delivered
I would like an email sent to the respondents email address relating to the relevant order each time the order status is updated.
Can this be done?
Thank you everyone!
You are storing this info in Excel and the only trigger for Excel in Power Automate is selected row. Please see the below link how to use selected item and execute the flow.
https://sergeluca.wordpress.com/2018/07/24/run-a-flow-for-a-selected-excel-item/
So once you change the status select the row and run the flow.
If your information is stored in SharePoint or SQL you could utilise the auto trigger based in column values (Status changes).
Thanks
There is no action that trigger a Flow when a rows is updated. You could design a way to do this build it would be slow and complicated. You would start with a SharePoint trigger that fires when a document is changed and go from there....
I suggest that a better way to go would be to store you data in a SharePoint list rather than Excel. You can have a Flow trigger when a row of data has changed. If you want to work in Excel, you can link Excel to the SharePoint list (read only).
The issue will be checking for a change in a column - SharePoint does not directly support monitoring column changes. Here is a link to a blog post that I wrote that discuss how this can be done.
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
