I'm using an Issue list in SharePoint. I want to set the "Assigned To" field to a specific person. Can that be easily done? I would like to open up the list in PowerApps and set the default value to "someone@company.com". The only options I've found is to set it to the current user. That won't resolve my issue.
Thanks for your suggestions.
Solved! Go to Solution.
Hi @JMUSharePoint ,
Do you want to set the Default value of the "Assigned To" field to a specific person in your Org within the Edit form of your app?
Is the Issue list that you mentioned a Issue Tracking SP list?
I have made a test on my side, please take a try with the following workaround:
Set the DefaultSelectedItems property of the Combo Box control within the Assigned To Data card to following:
If( EditForm1.Mode=FormMode.New, { DisplayName: Office365Users.UserProfile("Test3@xxxxxx.xxmicrosoft.com").DisplayName, Claims: "i:0#.f|membership|" & Lower("Test3@xxxxxx.xxmicrosoft.com"), Department: "", Email: "Test3@xxxxxx.xxmicrosoft.com", JobTitle: "", Picture: "" }, Parent.Default )
On your side, you should type the following formula:
If( EditForm1.Mode=FormMode.New, { DisplayName: Office365Users.UserProfile("someone@company.com").DisplayName, Claims: "i:0#.f|membership|" & Lower("someone@company.com"), Department: "", Email: "someone@company.com", JobTitle: "", Picture: "" }, Parent.Default
)
Note: I assume that the "someonoe@company.com" represents a specific person in your Org. You could not specify an external user (outside your Org) within this Assigned To field.
More details about setting a default value for a Person field within the Edit form, please check the following blog:
https://powerapps.microsoft.com/en-us/blog/default-values-for-complex-sharepoint-types/
Also please check the response within the following thread:
Best regards,
Hi @JMUSharePoint ,
Do you want to set the Default value of the "Assigned To" field to a specific person in your Org within the Edit form of your app?
Is the Issue list that you mentioned a Issue Tracking SP list?
I have made a test on my side, please take a try with the following workaround:
Set the DefaultSelectedItems property of the Combo Box control within the Assigned To Data card to following:
If( EditForm1.Mode=FormMode.New, { DisplayName: Office365Users.UserProfile("Test3@xxxxxx.xxmicrosoft.com").DisplayName, Claims: "i:0#.f|membership|" & Lower("Test3@xxxxxx.xxmicrosoft.com"), Department: "", Email: "Test3@xxxxxx.xxmicrosoft.com", JobTitle: "", Picture: "" }, Parent.Default )
On your side, you should type the following formula:
If( EditForm1.Mode=FormMode.New, { DisplayName: Office365Users.UserProfile("someone@company.com").DisplayName, Claims: "i:0#.f|membership|" & Lower("someone@company.com"), Department: "", Email: "someone@company.com", JobTitle: "", Picture: "" }, Parent.Default
)
Note: I assume that the "someonoe@company.com" represents a specific person in your Org. You could not specify an external user (outside your Org) within this Assigned To field.
More details about setting a default value for a Person field within the Edit form, please check the following blog:
https://powerapps.microsoft.com/en-us/blog/default-values-for-complex-sharepoint-types/
Also please check the response within the following thread:
Best regards,
I just now got back to this but it worked! Thank you so much for your help.
Sandy
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
193 | |
95 | |
64 | |
62 | |
58 |
User | Count |
---|---|
244 | |
166 | |
91 | |
78 | |
76 |