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
a
(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
a
(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
a
(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