Hi All,
This references a previous question that I asked: Solved: Allowing a user to create multiple records with sa... - Power Platform Community (microsoft.com). In that, I asked how I could have a user create multiple new records based on a set of input criteria. I successfully utilized the guidance in that to build out the process, but then ran into a new problem. The sequenced list has the list of users that need to be patched into the People column of the SharePoint list. However, every time I try, I end up only referencing the first user in the list for all 241 records. My most recent version of the code is here:
Collect(
'Attestation-tblAttestation',
ForAll(
Sequence(
CountRows(collectSequencedList),
1,
1
)As MySSCCreation,
{
ChangeManagementSession: dtpkCMSession.SelectedDate,
Status: {Value: "No Response"},
UserAttestationDate: Today(),
SSC_Submitter:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Department:"",
//Claims:"i:0#.f|membership|" & collectSequencedList.Email,
//DisplayName: collectSequencedList.DisplayName,
//Email: collectSequencedList.Email,
JobTitle:"",
Picture:""
}
}
)
)
I tried using Last(FirstN(collectSequencedList)).Email, but that also only generated the first user in the list as well.
collectSequencedList has the following three columns:
RowNumber, Name, Email. Rownumber starts at 1 and goes to the end of the list as well.
Any help in making sure that all 241 users or whatever are included in the SequencedList are inserted into SharePoint would be greatly appreciated.
Thanks!