I have a Sharepoint List with a Person column that accepts multiple people. In my PowerApp I have a Combobox tied to this column that also accepts multiple people. I have not been able to figure out how to set the default for the Combobox to the current user for a new record. Any help with this would be appreciated. Thanks.
Solved! Go to Solution.
Hi @STKJ ,
Set the default property of the data card to
If(FormName.Mode= FormMode.New ,Table({
DisplayName: User().FullName,
Claims: "i:0#.f|membership|" & User().Email
}),ThisItem.PPFieldName)
where FormName = name of your form
PPFieldName = column name in SP
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Even though I am not using "Forms", I was able to use the red code below from your suggestion. Thanks!
If(lvarStatus="New",
Table({DisplayName:User().FullName,
Claims:"i:0#.f|membership|" & User().Email}),
RFQAGallery.Selected.SendEmails)
Hi @STKJ ,
Set the default property of the data card to
If(FormName.Mode= FormMode.New ,Table({
DisplayName: User().FullName,
Claims: "i:0#.f|membership|" & User().Email
}),ThisItem.PPFieldName)
where FormName = name of your form
PPFieldName = column name in SP
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Sorry, I should have mentioned I am not using a form. Thanks.
Even though I am not using "Forms", I was able to use the red code below from your suggestion. Thanks!
If(lvarStatus="New",
Table({DisplayName:User().FullName,
Claims:"i:0#.f|membership|" & User().Email}),
RFQAGallery.Selected.SendEmails)
User | Count |
---|---|
181 | |
123 | |
88 | |
44 | |
43 |
User | Count |
---|---|
247 | |
156 | |
127 | |
78 | |
73 |