I have a people picker field in the SharePoint list and I am displaying that in PowerApps in New Form. Users should be able to enter user name and submit the form. It is working as expected.
Also, I would like this people picker to show current user name by default when new form shows up and if user doesn't change this in the people picker, it should just save current user name in the people field in SharePoint. I know that I can display current user by User().DisplayName but I am not sure where to put that. I have tried adding it in the Default property but that is not working. It is giving an error property expects record value but this produces a text value.
Solved! Go to Solution.
This doesn't seem to properly work for me. It will update the field in powerapps with the users name, but when submitting, it doesn't actually pass the user to the person field in the sharepoint list. Did it work for you?
Setting the Default and DefaultSelectedItems does not work for me and it does not get saved. I've tried changing the Update property of the data card as well but no luck. Has anything changed?
not with this new simple method. Please refer to my older post, but here it is again.
on the App Onstart action set the following variables:
for the person field on the DefaultSelectedItems action
Claims: "i:0#.f|membership|" & gvCurrentUser.userPrincipalName,
where is the OnStart option? This doesn't seen to exist anywhere in my form.
I have looked everywhere in the datacards, fields, etc and No OnStart
THERE IS A BETTER WAY NOW!!
This resolves the issue of patching/submitting the app user (User() ) to a sharepoint Person/Group Column.
The Person/Group Column, whether in a form or freestyle, utilizes the ComboBox with the items set to Choices([@ambiguousSPOList].ColumnName), this makes sure the data is patched/submitted correctly when done.
Below is the code you can place into the "DefaultSelectedItems" of the ComboBox:
Lookup('SPOListDataTable'.ColumnName As CN, CN.ColumnName.Email = User().Email).ColumnName
The Super User program for 2022 - Season 2 has kicked off!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.