
Announcements
I've set the Text Input Default value based on a Lookup(). I'm using the Lookup list to maintain my list of approvers and alternates. The problem I'm having is when the flow runs, it is not updating the Default Value of the Datacard to the Approver who responded in the approval process, it is keeping that default approver. Currently I have the DataCardValue set to be If(SharePointForm1.Mode.New, Lookup(Approver, Title = "Dept", Approver), Parent.Default), and when the flow runs and another approver (Alternate) approves, it doesn't change the name. I know I am missing something, just not sure what.
Hi @kmw1130
I don't know if you still need help with this one as it is a couple weeks old, but here goes.
Instead of changing the Default Value of the DataCardValue field, set the Default of the DataCard itself.
The formula would be something like:
If(
SharePointForm1.Mode = FormMode.New,
LookUp(
Approver,
Title = "Dept",
Approver
)
,
ThisItem.Approver
)
You would set your DataCardValue control Default formula back to Parent.Default.
The first part of your IF statement should be "SharePointForm1.Mode = FormMode.New" instead of "SharePointForm1.Mode.New"
You should also check your Approval Flow to ensure that after the Approval completes that you are setting the Approver field using an "Update Item" Action. You will need to set the Approver field using the Email address of the user that completed the Approval.
The Test Flow I made looks something like this:
After the "Start and wait for an approval" Action, a variable is set to the "Responses Approver Email". I am assuming your approval Action is set to "Approve/Reject - First to respond" for the Approval Type. This will capture the Approver's email address. Then an "Update Item" Action can be run to update the "Approver" field for the item.
I assumed the the "Approver" field was a People Picker field and set it using Claims:
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
-Mark