How to automate a request form and approval flow with MS Power Automate, Forms, SharePoint, Outlook

Balance is key for a healthy life. The more we can streamline and simplify processes, the more we can focus on self-care.

Delay until expression: formatDateTime('Effective date', 'yyyy-MM-ddT12:00:00')

[TalktomeGoose-vmdn]

I know this post is a bit old but I'm really hoping you can help. I'm frustrated with spending hours/days on what seems to be so simple. in your 3:39 where you Add a row into a table, what did you actually do? Did you have to populate all the fields with the dynamic content or did it populate itself? My issue is, I created the form, so the form's Excel file is saved to my drive. I have created a list in Sharepoint that pulls all the info from the Excel file. So I have my Excel file, which is on my drive and my Sharepoint list which is in our teams group site. When I try to add the location I am able to retrieve my groups location, however I'm not certain about the Document Library? I see that you used Documents, but when I go to the teams document library, neither my Excel file or Sharepoint list shows up. I guess I'm confused what "table" you are adding from the document library? Please, please pretty please help me, I will be forever grateful. Thank you in advance for your time.

[mohammedshengheer]

Great effort on building the flow, I was looking for a simple change request form approval process but this is way deeper and more efficient.

I will try to test this and modify it based on our needs.

Thank you for the great video.

[minu]

Hi, I have a single Excel data. Specific rows that need to be shared with different users. I need to automate an email flow which should pick the rows to specific user and send an email with that data only. And when that emal reach to that user they have to respond with thier response as yes or no for each line item. At the end I need an those users response in an Excel. Is it possible by using power automate and excel together or any ms office tool

[danielsalinas]

Hello! new subscriber here!!! glad i found this tutorial! thanks for sharing knowledge. I have only one question in minute 6:41 im not able to find the expresión for "delay until" could you specify it. thanks in advance. and sorry for my broken english. :) cheers from CHILE.

[akinloluwababalola]

Thank you for this video. Please how do I display the status of approval for each application in a dashboard?

[jkax]

Thanks for this amazing flow! Do you know why I cant add a row? my sharepoint didn't appear. And how you do Approver variable from sharepoint?

[ronalddosano]

This is very helpful. Moreover, I hope that you could help me to set up the approver list on Sharepoint.

[flippingepic]

I'm waiting for the result simulation...