Populating person or group field from dropdown list

[danbert1973]

I'm having an issue whereby I'm trying to add a new record to a SharePoint list (via an integrated form), however I've been sometimes getting the 'Skip to Main Content' message, and I have struggled to work out why.  I've finally found the reason I believe, and it seems to be connected to a field that is updated from a Dropdown list that looks at users who are a member of a specific group. 

The 'Items' property of the source dropdown list is below:

Sort(Office365Groups.ListGroupMembers("45fab24c-6729-47bb-941f-3a4aa34ca6ef").value.displayName,displayName)

The 'Update' property of the field it populates is below:

If(Text(NewFormMain.Mode)="1",{ 
DisplayName:Dropdown1_1.Selected.displayName,
Claims:"i:0#.f|membership|" & Lower(LookUp(Office365Users.SearchUser(),
DisplayName = Dropdown1_1.Selected.displayName,Mail)), 
Department:"",  
Email:LookUp(Office365Users.SearchUser(),
DisplayName = Dropdown1_1.Selected.displayName,Mail), 
JobTitle:"", 
Picture:""
},Dropdown1_1.Selected)

What I have discovered is that the form will save without issue if I select one of the first 22 users in the dropdown list.  Anything after that gives me the 'Skip to main content' error, and the record will not save.  If I test within Powerapps I get the error "The specified user i:0#.f|membership| could not be found".

There are only 72 users in the group and I've not seen any limits specific to 22.  Anyone know where I'm going wrong here?

Many thanks

[RandyHayes · Accepted solution]

@danbert1973 

Please consider changing your dropdown Items property to:

Sort(Office365Groups.ListGroupMembers("45fab24c-6729-47bb-941f-3a4aa34ca6ef").value, displayName)

Then change your Update property to the following:

{ 
    Claims:"i:0#.f|membership|" & Lower(Dropdown1_1.Selected.mail),
    DisplayName = Dropdown1_1.Selected.displayName, 
    Department:"",  
    Email: Dropdown1_1.Selected.mail, 
    JobTitle:"", 
    Picture:""
}

I hope this is helpful for you.

[danbert1973]

Hi @RandyHayes 

Thanks so much for your suggestion.  I did think my method of getting the group members I needed from the dropdown was a bit convoluted, but your solution has simplified it and removed the item limit (and error).

Thanks again

[Dan7Merc]

Follow up on this Item but in a slightly different scenario.

what is the equivalent of a SharePoint Persons or Group column in a Data Verse Table?