cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Maziear
Level: Power Up

Process flow for a excel document

Hi,

 

I am looking to create a flow for our service processes in sharepoint. we would need the flow to do these steps:

 

Excel document contains 7 sheets

1- trigger flow when document (Excel) is added

2- send email to USER1 to complete Sheet1

2- USER1 completes sheet1, send an email to USER2

3- User 2 to complete sheet 2, send email to USER3

4- 5 6 7 8 - User 4,5,6,7 (as same as user 1 and 2)

9- Document uploader to recieve and email on completion of the 7th user

10- move completed excel to complete folder,

 

Please if you can help me out how to achive this flow for our processes.

 

Thanks

Maz                                                                                                                        

2 REPLIES 2
Community Support Team
Community Support Team

Re: Process flow for a excel document

Hi @Maziear,

 

Where does the Excel file store? Is it a SharePoint library or a OneDrive folder?

 

There is no way to detect if the User1 (or User2, User3,etc.) has completed the Sheet1 (Sheet2, Sheet3, etc.) of a Excel file in Microsoft Flow currently, I afraid that there is no way to achieve your needs in Microsoft Flow.

 

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Maziear
Level: Power Up

Re: Process flow for a excel document

Hi @x-vida-msft ,

Thank you for your reply.
So my best approach would be mini automated. Ask each member to complete and put in a seperate folder and creat 7 different flows to triger and email for each user.?

So it would be folder 1,2,3,4,5,6,7,8
Folder to trigger email to user 1, after user 1 completes move it to folder 2, then user 2 to be emailed and so on for the next folders??

Kindest regards
Maziear


Kindest regards

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (6,158)