Hi,
I am wondering why the "DefaultSelectedItem" value of my people picker field doesn't write back to the SharePoint list.
The default value that I used for GenManager field is coming from a list in Sharepoint. Please see image below...
Anyone here knows what I have missed?
I would appreciate any help. Thanks!
Regards,
-K
Solved! Go to Solution.
Hi @KMagadia ,
Please refer to this blog: Defining default values for complex SharePoint types in forms
What should be put in 'DefaultSelectedItem' property in this case is the 'Claims' property of the person object, however, the Distinct function returns the Result of distinct DisplayName.
Please try to modify the 'DefaultSelectedItem' property as follows.
AddColumns(Filter('SP list',GenManager.Claims in Distinct(Filter('SP list', Department =DrpDept.Selected.Result),GenManager.Claims)),"Claims",GenManager.Claims,"DisplayName",GenManager.DisplayName)
Hope this helps.
Sik
Hi @KMagadia ,
Please refer to this blog: Defining default values for complex SharePoint types in forms
What should be put in 'DefaultSelectedItem' property in this case is the 'Claims' property of the person object, however, the Distinct function returns the Result of distinct DisplayName.
Please try to modify the 'DefaultSelectedItem' property as follows.
AddColumns(Filter('SP list',GenManager.Claims in Distinct(Filter('SP list', Department =DrpDept.Selected.Result),GenManager.Claims)),"Claims",GenManager.Claims,"DisplayName",GenManager.DisplayName)
Hope this helps.
Sik
Hi @v-siky-msft,
Thank you for your response.
I did try to use that code and it now writes back the name into the list. Though the code appears to have a delegation warning but I would care less as the SharePoint list which I am looking at won't have large dataset.
Thank you!
Regards,
-K
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
User | Count |
---|---|
256 | |
215 | |
76 | |
38 | |
33 |
User | Count |
---|---|
329 | |
222 | |
124 | |
71 | |
54 |