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.
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: