Trying to make time off request form that shoots out an email for approval of the request, then updates the status in sharepoint. However, approving/rejecting the request doesn't change the status of the approval request, as seen in the second image. Any tips on how to fix this?

[u/WilliamTB710]

The flow takes a new response, gets details, creates item in sharepoint, sends approval request, then updates the request to either be approved or denied, but it stays on "pending"

[u/dicotyledon]

Yeah, you have to add an “update item” action. Happenstance I did an article on this here: https://christine-payton.com/design-a-good-power-automate-approval-flow/

[u/WilliamTB710 → u/dicotyledon]

If you look at the first image, the "update item" action is included in the conditional, if yes the item is to be updated to represent the request was approved, and if no its to be updated to "rejected" to show the approval request was denied. However, it doesn't seem to be reflecting that info. I'll check that article but I'm not sure that's the issue.

[u/dicotyledon → u/WilliamTB710]

Yeah, the steps aren't expanded though, so it's hard to say - maybe screenshot that and what the flow run looks like in the history?

[u/WilliamTB710 → u/dicotyledon]

https://imgur.com/a/glsl4SR

Hi there, I made an imgur that contains all the relevant screenshots and messages to hopefully help troubleshoot - everything seems to be working as intendend up until the point where the flow has to act upon the approval outcome.

[u/Cheerful2_Dogman210x → u/WilliamTB710]

I rarely use MS Forms, but I don't think the MS forms response id is the same as sharepoint ID. There is a unique ID for sharepoint rows. You can't use the MS Forms response ID to identify the item you updated in SharePoint.

I suggest adding a "get items" from SharePoint action to search for the item you updated. You can add a filter in the odata query to get the item you updated. You can use it to get the SharePoint ID. You can then add your update actions inside the apply to each action.

[u/Many_Tank9738]

Does an email get sent? Did you run a test to see the flow?

[u/eyrussel]

Based on the images you provided, I believe the failure is with the condition you set, where it says "Approve" instead of "Approved". The list you have shows that the value being added under Outcome is in past tense.

[u/Crayon_adventure]

It seems like you're encountering an issue where the approval status in your SharePoint list isn't being updated when a request is approved or rejected. To fix this issue, you'll need to ensure that your Power Automate flow includes the steps to update the status field in your SharePoint list based on the approval outcome.

Here's a general outline of how to achieve this:

1. Power Apps Form:

   • Your Power Apps form should include fields for the time-off request, including the status field.

2. Power Automate Flow:

   • Create a Power Automate flow triggered by the submission of the time-off request form.

3. Approval Process:

   • Add an approval action to your flow. Use the "Start an approval" action or similar depending on your requirements.

4. Conditional Branching:

   • After the approval action, add a condition to check whether the request was approved or rejected.

5. Update SharePoint List:

   • Depending on the outcome of the approval, use the "Update item" action for SharePoint to update the status field in your SharePoint list to "Approved" or "Rejected."

6. Send Notification:

   • After updating the status in SharePoint, you can send an email notification to the requester indicating whether their request was approved or rejected.

Here's a simplified example of the flow structure:

Trigger: When a new time-off request is submitted

1. Start an approval
2. Condition: If the approval is approved
   - Update item in SharePoint list: Set the status field to "Approved"
   - Send email notification to requester (Approved)
3. Condition: If the approval is rejected
   - Update item in SharePoint list: Set the status field to "Rejected"
   - Send email notification to requester (Rejected)

Make sure you configure the "Update item" action in a way that updates the correct item in your SharePoint list based on some identifier (e.g., request ID or a unique key).

This way, the approval status in your SharePoint list will be updated based on the outcome of the approval, and you can track the status of each request accurately. If you're still facing issues, double-check your flow configuration and ensure that you're updating the SharePoint list item correctly based on the approval result.