Good day everyone!
I think I might have messed up with my data since I wish to change the choice column to person type column in SP List,
I was able to pull out the data from the group on 'AGENT' combo box control:
With Item Property.
Office365Groups.ListGroupMembers("GroupID").value
The Update property of data card is:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUser(), DisplayName = cbagt.Selected.displayName).Mail),
Department: "",
DisplayName: cbagt.Selected.displayName,
Email: LookUp(Office365Users.SearchUser(), DisplayName = cbagt.Selected.displayName).Mail,
JobTitle: "",
Picture: ""
}
However, it is not showing the data from SP List which I already updated. Also, would like to ask help on the patch.
Patch(
Tracker,
GalIA.Selected,
{
TEAM: ddteam.Selected,
CHANNEL: ddchan.Selected,
'PRIMARY TICKET REFERENCE NO.': txt_ptr.Text,
'DATE RECEIVED': dte_rcd.SelectedDate,
'CRMS REFERENCE NO., IF ANY': txt_crm.Text,
AGENT: cbagt.Selected, // Is this the correct format for patching person type column? It doesn't save the selected item in SP List.
'NAME OF CLIENT': txt_noc.Text,
Would highly appreciate any assistance on this. 🙂
Thank you in advance.
Got it!
Looks like I have to communicate with our admin then.
Thank you 🙂
Hi @RedcapVS,
You should check group id and group displayname in azure admin center:
Hi Qi,
Thanks for the advise. Just to clarify, the groupdisplayName you mentioned and groupemail, is this generic or something that I need to check on our MS Teams?
Thank you.
Hi @RedcapVS,
If you want to update a Group, you need to format as below:
{
Claims: "c:0o.c|federateddirectoryclaimprovider|" & groupid
DisplayName: groudisplayName;
Email: groupemail;
Department: "";
JobTitle: "";
Picture: ""
}
Further, you could get your group id by following formula:
LookUp(Office365Groups.ListOwnedGroupsV2().value, displayName = groupdisplayname).id