Excel Expense Form automate with emails and approvals

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3145686%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EExcel%20Expense%20Form%20automate%20with%20emails%20and%20approvals%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3145686%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EI%20have%20an%20expense%20form%20in%20Excel%20I%20want%20to%20add%20to%20a%20sharepoint%20library.%20The%20library%20has%20a%20column%20for%20employee%20name%20which%20will%20become%20like%20an%20ID%20to%20send%20the%20flow.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20want%20a%20flow%20that%20when%20users%20upload%20their%20excel%20expense%20forms%20to%20this%20library%20in%20a%20folder%20called%20Pending%20to%20trigger%20a%20flow%20to%20send%20an%20email%20OR%20notify%20their%20manager%20to%20check%20the%20expense%20form%20for%20approval.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EWhen%20the%20manager%20approves%20this%20excel%20sheet%20it%20should%20be%20moved%20to%20another%20folder%20automaticaally%20and%20send%20another%20email%20to%20the%20accountant%20to%20see%20the%20excel%20sheet%20in%20approved%20folder%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EAm%20I%20complicating%20things%3F%20Ijust%20want%20users%20to%20create%2Fupload%20their%20excel%20expense%20forms%20in%20Sharepoint%20and%20let%20the%20flow%20do%20the%20above.%20I%20am%20not%20looking%20at%20a%20complicated%20solution%2C%20cannot%20find%20a%20template%20in%20Power%20Automate%20that%20can%20automate%20this.%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%20for%20reading%20and%20appreciate%20your%20help.%20Thanks!%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3145686%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3ESharePoint%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

I have an expense form in Excel I want to add to a sharepoint library. The library has a column for employee name which will become like an ID to send the flow.

I want a flow that when users upload their excel expense forms to this library in a folder called Pending to trigger a flow to send an email OR notify their manager to check the expense form for approval. 

When the manager approves this excel sheet it should be moved to another folder automaticaally and send another email to the accountant to see the excel sheet in approved folder 

 

Am I complicating things? Ijust want users to create/upload their excel expense forms in Sharepoint and let the flow do the above. I am not looking at a complicated solution, cannot find a template in Power Automate that can automate this. 

 

Thanks for reading and appreciate your help. Thanks! 

0 Replies