Capture the name of the person who changed the drop down value to submitted

(0) Share

Report

Posted on by cyberco01

480

Hi All,

I have a PowerApps Form linked to SharePoint.

In that I have a drop-down with status - Draft, Submitted, Closed.

I need to capture the name of the person who changed the value of the drop-down to Submitted only.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@cyberco01In the OnChange of the drop-down, check if Self. SelectefText="Submitted" and capture the currently User name there using, Office365Users.MyProfile().DisplayName

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report
Copy link

Link copied!

@CNT So do i need to create another person group field for that so that name is stored?

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@cyberco01 if you want to store just the name, single line of text would do. But if you want to refer to that person itself, you need to create a person or group field. Depends on your requirement.

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report
Copy link

Link copied!

@CNT, Kindly guide me where the above code can be written on the person group field to capture who changed the status to Submitted.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@cyberco01 Place this code in the OnChange of the drop down (replace yourSPList, the record to be patched & personColumn as per your need),

If(Self. SelectefText="Submitted", Set(varPerson,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & User().Email, Department:"", DisplayName:User().FullName, Email:User().Email, JobTitle:"", Picture:"" }); Patch(yourSPList, the record to be patched,{personColumn:varPerson}) )

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report
Copy link

Link copied!

@CNT Thanks for the response.
Please guide me on how I can get the record to be patched. The ID field on my list is the unique identifier for each record.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@cyberco01 I'll like to know 2 things,

1. Where are you capturing the information, is it in an EditForm?

2. When do you want to Patch the changes - as soon as the status changes? or when the user click a submit button?

It would be helpful if you could share some screen shots.

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report
Copy link

Link copied!

@CNT , Below is the screenshot of my form. The single form handles edit, new, and view.
The highlighted drop-down has values - Draft, Submitted, Closed.
I need to capture the name of the person who changed the drop-down value to 'Submitted' in a Person-Group field.
The process will be - the user will change status to Submitted and click on SAVE on the form.
This value of the new Person Group need not change if any other changes to other fields are done to the form.
It just needs to capture the value when the status is changed to Submitted.

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@cyberco01

In the OnSave of SharePointIntegration,

do the following....

SubmitForm(SharePointForm1); If(Combobox.Selected.Value="Submitted", Set(varPerson,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & User().Email, Department:"", DisplayName:User().FullName, Email:User().Email, JobTitle:"", Picture:"" }); Patch(yourSPList, SharePointForm1.LastSubmit,{personColumn:varPerson}) )

** remember to replace Combobox, SharePointForm1, yourSPList, personColumn as applicable.

Was this reply helpful? Yes No