Hello,
I've customized the Leave Request Approval Form on Sharepoint with Microsoft Flow.
Now I'm showing my received requests on Microsoft flow.
But I want to see my received requests on Sharepoint. Is it possible to show the received requests on Sharepoint? or show Microsoft Flow screen on Sharepoint?
Can you please teach me the step by step the leave request form with video calling with fee?
Ok in that case I wouldn't use an Approval action (or that template) at all. The steps I would use are below with screenshots further down which I hope will help you.
1. Add a choice column to your SharePoint list for Approved or Rejected
2. Create a blank flow and add a SharePoint "When a new item is created or modified" trigger. Select the site and the list.
3. Add a Get item action and select the site and the list and from Dynamic Content select ID (the item of the item that was created or modified)
4. Add a Condition control and in the left hand box select from Dynamic Content the name of the column in your SharePoint list for the Approved/Rejected (in my case it's Decision). Select is equal to in the middle box and for the right hand box click on the Expression tab on the right and enter null and select it.
5. In the green If yes channel add a "Send an email (v2)" to send you the notification that that a new request has been created and add a link to it (you'll need to click on the </> in the header area and use the html syntax in my image below.
6. In the red If no channel add another Condition control for decision is equal to Approved.
7. In the green If Yes channel add another Send an Email (v2) to let the person creating the request know that their request has been approved. In the red If no channel add another Send an Email (V2) to let them know it has been rejected.
8. When you receive the email you can click on the link to go into the item in the SharePoint list and approve or reject it and it will send the appropriate email to the requestor.
The email priority defaults to Low importance, so if you want normal or high you can change this in the advanced option on the Send an Email (V2).
If you don't want the requestor to see the Approved/Rejected choice field then you'd need to create a form in PowerApps, but that's outside the scope of this answer.
Rob
Los Gallardos
7- SharePoint approved or rejected
1- new column
2- SharePoint Form
3-Flow - Item Created - Get Item - Condition
4 -Flow - Send initial email
5-Flow - Send Approved or Rejected emails
6- Initial email on new request
8- Decision email
Hello @RobElliott
Maybe my question was wrong..
I mean, that I need to approve my requests on SharePoint.
Things that I did now:
1. Create an approval form on SharePoint.
2. Approving the request on an email or in Microsoft Flow web ( https://asia.flow.microsoft.com )
3. Updated the request status in the SharePoint list.
All I wanna do is, just to approve and reject my requests on SharePoint, not on an email.
HI @Anonymous , I assume you've used the "Request manager approval for leave requests" template in Flow which is missing one important step which is to update the SharePoint list with the response. So you need an extra column in the SharePoint list for the decision, and in Flow you need to add an update item action. You should put this before the Inform.... step to update the SharePoint list item (using ID) with "Approve" or "Reject". And you can look at all of the requests and responses in the SharePoint list.
Flow is meant to run in the background just to connect data, so you don't want to be displaying your Flow in a SharePoint page and there's no need to do so. Adding the extra column in the list and the SharePoint Update item action in Flow should give you everything you need.
Rob
Los Gallardos
Michael E. Gernaey
497
Super User 2025 Season 1
David_MA
436
Super User 2025 Season 1
Riyaz_riz11
244
Super User 2025 Season 1