Hi All,
I am designing a PowerApps form for a SharePoint list which contains a 'Person or Group' field. The value/user for this field is retrieved from SharePoint security group. Please see the field settings below for the field.
Please suggest how can I handle this field in PowerApp form.
Thanks,
Kunal
Solved! Go to Solution.
Hi @basukunal001 ,
Do you want to patch SP Group to Person or Group field in your SP List?
I have made a test on my side, please try the following workaround:
The Person or Group field configuration as below:
App's configuration as below:
Set the OnSelect property of the "Patch" button to following:
Patch(
'20190816_case6',
Defaults('20190816_case6'),
{
ProductName: "SP Group Test",
SPGroupPeopleField: {
Claims: "c:0o.c|federateddirectoryclaimprovider|" & LookUp(Office365Groups.ListOwnedGroups().value, mail = "PowerApps@xxxxxx.xxmicrosoft.com").id,
Department: "",
DisplayName: "Power Members",
Email: "PowerApps@xxxxxx.xxmicrosoft.com",
JobTitle: "",
Picture: ""
}
}
)
On your side, you should type the following formula:
Patch(
'Your SP List',
Defaults('Your SP List'),
{
ProductName: "SP Group Test",
SPGroupPeopleField: {
Claims: "c:0o.c|federateddirectoryclaimprovider|" & LookUp(Office365Groups.ListOwnedGroups().value, mail = "<Type Your SP Group Email Address Here>").id,
Department: "",
DisplayName: "<Type your SP Group Name Here>",
Email: "<Type Your SP Group Email Address Here>",
JobTitle: "",
Picture: ""
}
}
)
Note: You need to add Office 365 Groups connector as data source in your canvas app firstly.
Please try above solution, then check if the issue is solved.
Regards,
You might start out by taking a look at this posting. I describes what you might be looking for and more.
I hope it is helpful for you.
It seems for PowerApps, we can patch office 365 group in Person or Group field but cannot patch SharePoint group in Person or Group field.
Hi @basukunal001 ,
Do you want to patch SP Group to Person or Group field in your SP List?
I have made a test on my side, please try the following workaround:
The Person or Group field configuration as below:
App's configuration as below:
Set the OnSelect property of the "Patch" button to following:
Patch(
'20190816_case6',
Defaults('20190816_case6'),
{
ProductName: "SP Group Test",
SPGroupPeopleField: {
Claims: "c:0o.c|federateddirectoryclaimprovider|" & LookUp(Office365Groups.ListOwnedGroups().value, mail = "PowerApps@xxxxxx.xxmicrosoft.com").id,
Department: "",
DisplayName: "Power Members",
Email: "PowerApps@xxxxxx.xxmicrosoft.com",
JobTitle: "",
Picture: ""
}
}
)
On your side, you should type the following formula:
Patch(
'Your SP List',
Defaults('Your SP List'),
{
ProductName: "SP Group Test",
SPGroupPeopleField: {
Claims: "c:0o.c|federateddirectoryclaimprovider|" & LookUp(Office365Groups.ListOwnedGroups().value, mail = "<Type Your SP Group Email Address Here>").id,
Department: "",
DisplayName: "<Type your SP Group Name Here>",
Email: "<Type Your SP Group Email Address Here>",
JobTitle: "",
Picture: ""
}
}
)
Note: You need to add Office 365 Groups connector as data source in your canvas app firstly.
Please try above solution, then check if the issue is solved.
Regards,
User | Count |
---|---|
259 | |
110 | |
97 | |
52 | |
39 |