cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ThomasEarlS1
Frequent Visitor

Procurement Process

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:

 

Procurement Flow.PNG

 

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!

2 REPLIES 2
ScottShearer
Super User III
Super User III

@ThomasEarlS1 

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.

 

 

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
abm
Super User III
Super User III

Hi @ThomasEarlS1 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

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 (2,091)