Skip to main content
Community site session details

Community site session details

Session Id : +OARxNP9QHPkSpo+le2Qgv
Power Apps - Building Power Apps
Answered

Help on Person Column in SP List, not showing in combo box control & Patch for person type column

Like (0) ShareShare
ReportReport
Posted on 13 Jul 2023 22:44:55 by 58

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,

 

RedcapVS_2-1689287913763.png

 

I was able to pull out the data from the group on 'AGENT' combo box control:

RedcapVS_0-1689287652512.png

 

With Item Property.

Office365Groups.ListGroupMembers("GroupID").value

 

RedcapVS_1-1689287776580.png

 

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. 

  • RedcapVS Profile Picture
    58 on 17 Jul 2023 at 01:37:19
    Re: Help on Person Column in SP List, not showing in combo box control & Patch for person type column

    Got it!

    Looks like I have to communicate with our admin then.

     

    Thank you 🙂

     

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on 17 Jul 2023 at 01:16:04
    Re: Help on Person Column in SP List, not showing in combo box control & Patch for person type column

    Hi @RedcapVS,

    You should check group id and group displayname in azure admin center:

    https://portal.azure.com

  • RedcapVS Profile Picture
    58 on 16 Jul 2023 at 22:16:48
    Re: Help on Person Column in SP List, not showing in combo box control & Patch for person type column

    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.

  • v-qiaqi@microsoft.com Profile Picture
    on 14 Jul 2023 at 06:14:12
    Re: Help on Person Column in SP List, not showing in combo box control & Patch for person type column

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Loading started