Unanswered

update people picker on sharepoint when combobox is change or updated

(0) Share

Report

Posted on by ivandgreat

I have a combobox in a form with a choice type, but i wanted to show and update the people picker combobox with the current user who select/update the choice type and update the SP list as well when submitted the form, rather than selecting the name.

How can i update the SP table? i don't know how can i do it, somehow im stuck.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

v-liwei-msft on at

Like (0)

Report
Hi @ivandgreat

Are you trying to update a Person column in SharePoint based on the current user using the ComboBox?
You can use the formula in the upload button:

Patch( 'TABLE NAME', PERSONLOOKUPNAME: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|"&User().Email, Department: "", DisplayName: User(). DisplayName, Email: User(). Email, JobTitle: "", Picture: "" } } )

I think this link will help you:

How to Patch Person Lookup in PowerApps with Share... - Power Platform Community (microsoft.com)

Best Regards,

Levi

Was this reply helpful? Yes No
ivandgreat 43 on at

Like (0)

Report

thanks.. but i wanted to update the person name when the combobox is selected

Was this reply helpful? Yes No
v-liwei-msft on at

Like (0)

Report
Hi @ivandgreat

You can use the formula to get the name:

User(). DisplayName

Best Regards,

Levi

Was this reply helpful? Yes No
ivandgreat 43 on at

Like (0)

Report

I wanted to update the people picker based on the other combobox choice value.

Was this reply helpful? Yes No
v-liwei-msft on at

Like (0)

Report

Hi @ivandgreat

The User function can obtain the user information currently using the App.

Can you explain to me how you want the people picker to change based on the choice column.

Best Regards,

Levi

Was this reply helpful? Yes No
ivandgreat 43 on at

Like (0)

Report

Hi again, everytime i make onchange on the choice combobox with respect to value,
example, "Migrated" the people picker should be the current user,
if it's empty or blank.. the peoplepicker should be blank as well.
if choice value is not "Migrated", the people picker could be a default name or static name.

Was this reply helpful? Yes No
Verified answer

v-liwei-msft on at

Like (1)

Report
Hi @ivandgreat

I'm assuming your Form is New Form and the Items property of the people picker ComboBox is Choice(DataSource.Person Column).
Depending on your needs, you can use the formula in the DefaultSelectedItems property of the people picker ComboBox(Please note that when the ComboBox selection value is not "Migrated" and is not empty, you still need to enter your default user information in this format)

If( ComboBox.Selected.Value = "Migrated", { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & User().Email, Department: "", DisplayName: User().FullName, Email: User(). Email, JobTitle: "", Picture: "" }, If( IsBlank(ComboBox2.Selected.Value), Blank(), If( !IsBlank(ComboBox2.Selected.Value) && ComboBox.Selected.Value <> "Migrated", { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims: "i:0#.f|membership|" & "DefaultUserEmail", Department: "", DisplayName: "DefaultUserName", Email: "DefaultUserEmail", JobTitle: "", Picture: "" } ) ) )

Was this reply helpful? Yes No