how to patch people picker column of sharepoint

(0) Share

Report

Posted on by venky232

i have 3 people picker coloumn in sharepoint list user,manager,tainer.

i want to patch the details i used below code it is patching only user .

how to do for login user manager & trainer(using textinputbox.)

User: {
Claims: "i:0#.f|membership|" & User().Email,
Department: "",
DisplayName: "",
Email: "",
JobTitle: "",
Picture: ""
},
Manager: ?
Trainer: patch input text box - ThisRecord.Trainer ?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @venky232 ,

See the sample syntax below. I would advise against trying to update the Claims token using a Text Input Box and instead using a Dropdown or Combo Box control with a trustworthy source of data in the Items property (e.g. Choices([@'Your Data'].'Your Manager Column').

Patch( 'Your Data', Defaults('Your Data'), { User: { Claims: "i:0#.f|membership|" & Lower(User().Email), Department: "", DisplayName: "", Email: "", JobTitle: "", Picture: "" }, Manager: { Claims: "i:0#.f|membership|" & Lower(ComboBox1.Selected.Email), Department: "", DisplayName: "", Email: "", JobTitle: "", Picture: "" }, Trainer: { Claims: "i:0#.f|membership|" & Lower(Dropdown1.Selected.Email), Department: "", DisplayName: "", Email: "", JobTitle: "", Picture: "" } } )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!
its working but i created gallery as grid type & patching gallery as bulk

if i add combo box(inserted in gallery Record for bulk update) it is showing same name for all records.
i need like ThisRecord.Trainer Combox , how to do this.
Trainer: { Claims: "i:0#.f|membership|" & Lower(Dropdown1.Selected.Email), Department: "", DisplayName: "", Email: "", JobTitle: "", Picture: "" }

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@venky232 assuming the Items property of your Combo Box control inside the Gallery is e.g.:

Choices([@'Your Data'].Trainer Name)

Set the DefaultSelectedItems property of the Combo Box control to:

{Value: ThisItem.Trainer.DisplayName}

Then apply the below to the OnSelect property of a Button (outside of the Gallery):

Patch ( 'Your Data', ForAll( 'Your Gallery'.AllItems, { ID: ID, Trainer: ComboBox1.Selected } ) )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!

Trainer name in gallery is text inputbox

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@venky232 I do not know what your response means.

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report
Copy link

Link copied!
im using textinputbox instead of combobox
Trainer: ComboBox1.Selected
text input box inserted in blank gallery as records and submiting bulk records using ForAll patch

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@venky232 as I strongly worded in my first response to your post, do no use a Text Input box to Patch a People field.

Was this reply helpful? Yes No