Field in Form, different read and write datasets

(0) Share

Report

Posted on by HD-04081521-0

This might be an easy one for you all

I have a Form with fields, The form is linked to a SharePoint List called "MAIN EMR Sections" I have added all the fields to the form

1 of the fields is a People field. I would like it to do a search on organisational people from office365users. Once the said person is found. I would like it to write the info back to the SharePoint List, when the user clicks the Submit button, along with all the other fields in the form

Is this possible?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Kalathiya 1,669 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hello @HD-04081521-0,

Yes, It's possible.

First, make sure you add the Office 365 Users connector to your app. This connector allows you to search your organisation’s users and is commonly used for People Picker scenarios.

You can then use a ComboBox (or People Picker control) with Office365Users to search for users. Once a person is selected, you can write that value back to a SharePoint Person or Group column when the user clicks the Submit button.

ComboBox Item Property:

Office365Users.SearchUserV2({searchTerm:Self.SearchText,top:999}).value

Display Field Property:

["DisplayName","Mail"]

Select Multiple Property must be false.

If you are submitting using Form Control then - DataCard update Property

{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & YourDorpDownControlName.Selected.Mail, Department: "", DisplayName: YourDorpDownControlName.Selected.DisplayName, Email: YourDorpDownControlName.Selected.Mail, JobTitle: "", Picture: "" } //YourDorpDownControlName - Replace this control name with your dropdown control name

Note: YourDorpDownControlName - Replace this control name with your dropdown control name

If you are patching or creating new records:

Patch( 'MAIN EMR Sections', //'MAIN EMR Sections' - Replace this with your SharePoint list name Defaults('MAIN EMR Sections'), { PersonFieldName: { //PersonFieldName - Replace this with your Person or Group column field name '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & YourDorpDownControlName.Selected.Mail, Department: "", DisplayName: YourDorpDownControlName.Selected.DisplayName, Email: YourDorpDownControlName.Selected.Mail, JobTitle: "", Picture: "" } //YourDorpDownControlName - Replace this control name with your dropdown control name } )

Reference Link:

https://www.matthewdevaney.com/power-apps-people-picker-delegation-workaround/

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

1 people found this reply helpful.

Was this reply helpful? Yes No
WarrenBelz 154,793 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @HD-04081521-0,

Adding to @Kalathiya, post, you also need to look at the DefaultSelectedItems when you use that connector - this blog of mine should give you some guidance on that.

Also the '@odata.type' reference is no longer needed when writing to this field type and also these fields are now Delegable (there were limitations in 2022 when that blog was posted)

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 154,793 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @HD-04081521-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No