Answered

People Picker in repeating section

(0) Share

Report

Posted on by DaynaBee

309

SOS How can I add people picker field in a repeating section along with other input fields? The items property of the gallery is set to a collection. I am trying to add three people picker fields in the repeating section, how can I achieve that ? Below here is what I have right now but I need three fields to patch a people picker field and currently its just a text input and not included in the patch function.

Please Help!

ForAll(
	 colPO,
	 If(
	 !IsBlank(TextProgName_1.Text),
	 Patch('PO', Defaults('PO'),
	 {
 Title:vendorRequest_1.LastSubmit.'Vendor Name',
 DatePrepared:vendorRequest_1.LastSubmit.'Date Prepared',
 VendorID:vendorRequest_1.LastSubmit.'Vendor ID',
 Status:vendorRequest_1.LastSubmit.Status,
 Comments:vendorRequest_1.LastSubmit.Comments,
 ProgramName:Input_ProgramName,
 CostpointID:Input_CostpointID,
 POAmount:Value(Input_POAmnt),
 PONumber:Input_PONum
	 }
	 )
	 )
	);
	ResetForm(Self);
RequestHide();

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

v-xiaochen-msft on at

Like (1)

Report
Hi @Yemata ,

Could you please tell me:

What is 'PO'? Is it a SharePoint list?

What is 'people picker field' you mentioned? Is it a Person column in SP list?

I assume you want to update a person colunm (Do not allow multiple selections) with a textinput control. you could try:

ForAll( colPO, If( !IsBlank(TextProgName_1.Text), Patch('PO', Defaults('PO'), { Title:vendorRequest_1.LastSubmit.'Vendor Name', DatePrepared:vendorRequest_1.LastSubmit.'Date Prepared', VendorID:vendorRequest_1.LastSubmit.'Vendor ID', Status:vendorRequest_1.LastSubmit.Status, Comments:vendorRequest_1.LastSubmit.Comments, ProgramName:Input_ProgramName, CostpointID:Input_CostpointID, POAmount:Value(Input_POAmnt), PONumber:Input_PONum, PersonColumn: { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & TextInput.Text, Department:"", DisplayName:"", Email:TextInput.Text, JobTitle:"", Picture:"" } } ) ) ); ResetForm(Self); RequestHide();

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

DaynaBee 309 on at

Like (0)

Report

Thank you so much Wearsky for your solution, It worked!
Thinking if there is a better way, Is there any way you could think of I could let users pick from O365 users in the current form instead of typing in the names and email in two fields?

Was this reply helpful? Yes No