Capturing the time stamp of the approval

[cooltechie]

Hello,

I have a PowerApps form where I would like to capture the time stamp of Approval by the manager.The approval field is a choice field with values "In Progress", "Ready for review" and "Manager approved".  I have two fields,  Date Approved and Approved by where I would like to capture the time stamp when the value of the Approval field is changed from "Ready for Review" to "Manager Approved" . Also capture the name of the person who changed the value from "Ready for Review" to "Manager Approved".

Please advise,

Thanks

[seadude]

Hi @cooltechie. There are a few ways to do this. Assuming you have the following:

• Approval_Type field with choices "In Progress", "Ready", "Manager Approved"
  
  • Set OnChange property to:

  • If(
        Approval_Type.Selected.Value = "Manager Approved",
        Set(varApproverName, User().Name);
        Set(varApprovedTime, Now())
    
    

• Approved_By field
  • Set Default or Text property to varApproverName
• Approval_Date field
  • Set Default or Text property to varApprovedTime

Good luck!

[cooltechie]

Hello

Thank you for your response. I am getting an invalid argument error.

Regards,

[cooltechie]

I tried the following:

If('Approval Status'.Value = "Manager Approved",
Set(varApproverName, User().Email);
Set(varApprovedTime, Now()), "")

I don't get access to Approval Status.Selected.Value property.  But I get Value property. However, with my formula, the approval time is recorded even if the value is "In Progress". How can I correct this?

[cooltechie]

Also, in the same logic, I would like to capture the time when the Approval status is changed from In Progress to Ready for Review into a submitted time field. Please advise how to achieve this.

Thanks

[v-xida-msft]

Hi @cooltechie,

Could you please share a screenshot more about your app's configuration?

Could you please share a bit more about the "Approved by" column? Is it a Person type column or Single line of text column?

Based on the formula that you provided, I think there is something wrong with it.

I agree with @seadude's thought almost, I assume that the "Approved by" column is a Single line of text column in your SP list, I have made a test on my side, please take a try with the following workaround:

Within above custom form, set the OnChange property of the Combo Box control within the ApprovalStatus Data card to following:

If(
    DataCardValue2.Selected.Value = "Ready for review" || DataCardValue2.Selected.Value = "Manager approved",
    Set(capturedTime, Now());Set(capturedUser, User().FullName)
)

Note: The DataCardValue2 represents the Combo Box control within the ApprovalStatus Data card.

Set the Default property of the Date Approved data card to following:

If(
    !IsBlank(capturedTime),
    capturedTime,
    ThisItem.'Date Approved'
)

Set the Default property of the Approved by data card to following:

If(
    !IsBlank(capturedUser),
    capturedUser,
    ThisItem.'Approved by'
)

Set the OnNew property of the SharePointIntegration control to following:

Set(capturedTime, Blank()); /* <- Add formula here */
Set(capturedUser, Blank()); /* <- Add formula here */
NewForm(SharePointForm1)

Set the OnEdit property of the SharePointIntegration control to following:

Set(capturedTime, Blank());
Set(capturedUser, Blank());
EditForm(SharePointForm1)

Set the OnView property of the SharePointIntegration control to following:

Set(capturedTime, Blank());
Set(capturedUser, Blank());
ViewForm(SharePointForm1)

The GIF screenshot as below:

Note: The Approval_Type @seadude mentioned in his formula is not the 'Approval Status' column in your SP list, it represents the Combo box control within the Approval Status Data card in your Edit form.

Best regards,

Kris

[cooltechie]

Hi Kris,

Thank you for the instructions. I will give it a try.  As far as Approved by field goes, I have it as Person Type field. However, It doesn't have to be a person field. I can change it to Single Line Text field. 

Also, when the Status is Changed to "Ready for Review", I would like to capture that in a seperate time stamp field known as "submitted time stamp". How can I modify your code to achieve the same? Can we add multiple if statements for the same control's Onchange event?

Please advise,

Thanks

[cooltechie]

Hi Kris,

This worked for Approved time capture. However, I would like to capture another time i.e when a user changes the value from In Progress to "Ready for Review". I would like to set that as "submitted By" time.

Thanks.

[Nat_SGRE]

Hi all,

Following this topic, I tried the formulas/changes suggested by @seadude, however looks like that I cannot apply the same formulas to a Gallery.

You see, I have this gallery:

and I would like to get the date when the Approval status changes to = "Approved" or "Rejected" or "On hold", but when is in "pending" status or in blank the date should be empty.

• Approval status dropdown > OnChange property: 

If( 

Approval status.Selected.Value = "Approved" ||

Approval status.Selected.Value = "Rejected" ||

Approval status.Selected.Value = "On hold",

Set(varApprovedTime, Now()))

• Status date (datepicker) > DefaultDate property: 

If(
!IsBlank(varApprovedTime),
varApprovedTime,
ThisItem.'status date')
)

• App OnStart property: Set(varApprovedTime, Blank())

After all this, I get errors and the column of "status date" the gallery just gets the same date repeated for all rows.

Any suggestions on how can I fix it?

Thanks in advance