Unanswered

update the current user to the share point list

(0) Share

Report

Posted on by arshad2

i have a multi selection person field in share point, they contain multiple person at the start but on select of the button, i want to update the field to the current user only. how should i code the onselect button

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

theapurva 970 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hello,
In your code just add Table() to your code for people picker column:
'Transport Approved By':Table ({ Claims: Blank(), DisplayName: Blank(), Email: Blank(), Department: Blank(), Picture: Blank(), JobTitle: Blank() })

Was this reply helpful? Yes No
theapurva 970 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @arshad2,
Did that work for you or still facing any issue?
I will be happy to help you further.
Otherwise, Please accept the solution as answer if it resolved your issue.

Was this reply helpful? Yes No
arshad2 51 on at

Like (1)

Report
Copy link

Link copied!

Hi @theapurva ,
it didnt work for me, still it showed a error that department is missing.

i managed to take the current user a collection and calling the collection for the specific patch, then it works:
ClearCollect(
CurrentUser,
{
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|" & User().Email,
Department:"",
DisplayName:User().FullName,
Email:User().Email,
JobTitle:"",
Picture:User().Image
}
);
Set(
myItem,
LookUp(
'Transport Applicants',
ID = Gallery3_1.Selected.ID
)
);
Patch(
'Transport Applicants',
myItem,
{

'Transport Approval Status': {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
ID: 1,
Value: "Approved"
},
'Transport Approved By': CurrentUser,
'Transport Approval Time': Now()
});
);

Was this reply helpful? Yes No