Problems updating a record in SharePoint with a User selected from an M365 Group

[PeterMurphy]

I have created a PowerApp to run our Service Desk Tickets through a Teams PowerApp.  Everything is working as expected at the moment except for adding a user to an incident as an "Assigned To" field.

In SharePoint the Data Type is User or Group and I have the drop down looking up the "Technology Team" Security Group to give a list of available users.  It is when patching the user to the record in SharePoint that doesn't seem to be working.  The patch script is below.  Can anyone point me in the right direction to get this to patch as a user account against the SP List please?

Patch(
        Incidents,
            varListItem,
            {
                Comments: newComments.Text,
                AssignedTo: {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
                                ODataType: Blank(),
                                Claims:Concatenate("i:0#.f|membership|",User().Email),
                                DisplayName:User().FullName,
                                Email:User().Email,
                                Department:"",
                                JobTitle:"",
                                Picture:""
            },,
                Status: IncidentStatus.Selected.Value
            }
        );

Reset(newComments);
Reset(incAssignedTo);
Reset(IncidentStatus);
Navigate(scrListView,ScreenTransition.CoverRight);

[WarrenBelz]

Hi @PeterMurphy ,

Please start with this standard structure

Patch(
   Incidents,
   {ID: varListItem.ID},
   {
      Comments: newComments.Text,
      AssignedTo: 
      {
         '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
         Claims: "i:0#.f|membership|" & Lower(User().Email),
         DisplayName: User().FullName,
         Email: User().Email,
         Department: "",
         JobTitle: "",
         Picture: ""
      },
      Status: IncidentStatus.Selected.Value
   }
);
Reset(newComments);
Reset(incAssignedTo);
Reset(IncidentStatus);
Navigate(scrListView,ScreenTransition.CoverRight);

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[PeterMurphy]

Thanks for your help in this, truly appreciated,

On updating the patch script I get the error of "Invalid Argument Type: Expecting a record value, but of a different schema"

This one is definitely stumping me and searching 4th Line Support (Google) shows a million different ways to do the same thing and it's tough to work out the right way on this one.

[Jon_Unzueta]

Hello @PeterMurphy 

I don't understand you well, the problem is that you can't save the assigned user?

the drop down menu filter, do you do it in the app or in SPO?

[PeterMurphy]

Apologies, On the form I am using the Office365Groups Connector to Filter to the Technology Team Group to give me a list of users available to be assigned to the Incident in SharePoint.  I am then trying to use the Office365Users connector to patch this into SharePoint as the selected user.

There are only 3 fields to patch information to in this form, which is a notes field, assigned user field and status field. 

[WarrenBelz]

Hi @PeterMurphy ,

There are two possibilities here that I see - assuming your 'Assigned to' field is a Person column, you have set it to allow multiple selections or Status is a Choice column. If the second you need

Status: {Value: IncidentStatus.Selected.Value}

or simply

Status: IncidentStatus.Selected

[PeterMurphy]

Hi,

It is from a Drop Down Box and I am using this in the Items entry:

Office365Groups.ListGroupMembers("45e09b0e-9fa7-4719-906c-7d2e45889699").value

This pulls the members from the Office365Group and displays the displayName field in the drop down list.

Would this need to be changed to a Combo Box?

[WarrenBelz]

Hi @PeterMurphy ,

The Items of the Combo Box is totally irrelevant here as you are not using it in the Patch - you are using the current logged in user's credentials. The issue is the field type you are patching it to - can you please confirm that 'Assigned To' is a single select Person column in your SharePoint list.

[PeterMurphy]

Hi @WarrenBelz 

The field settings are set to "Person or Group" and Allow Multiple Selections is switched off against this.

[WarrenBelz]

Hi @PeterMurphy ,

Some debugging required here as the below is the "out of the book" structure for patching a Person field

Patch(
   Incidents,
   {ID: varListItem.ID},
   {
      AssignedTo: 
      {
         '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
         Claims: "i:0#.f|membership|" & Lower(User().Email),
         Department: "",
         DisplayName: "User().FullName,
         Email: User().Email,
         JobTitle: "",
         Picture: ""
      }
   }
);

Please indulge me in a suspicion here - remove the other two fields and see if AssignedTo patches on its own as above