Power Platform Community Forum Thread Details

Hi Peeps,

I'm blocked on an issue where one field in my ForAll loop is not returning the correct results.

The issue: The below formula works correctly for either 1 or 2 user selections, but doesn't output the right title when 3 or more users are selected. Noting that when 3 or more users are selected, the userId & userName fields have the right details, its only the title field that doesn't..?!?!?!?!

The formula:

Clear(colThisItem);
ForAll(AddUsers.SelectedItemsText,
Collect(colThisItem,
{ID: CountRows(colThisItem)+1,
userName:Last(FirstN(AddUsers.SelectedItems, CountRows(colThisItem)+1)).Result,
userId: Last(FirstN(Distinct(Filter(eng, displayName in AddUsers.SelectedItems || IsBlank(AddUsers.SelectedItems)),userId), CountRows(colThisItem)+1)).Result,
title:Last(FirstN(Distinct(Filter(eng, displayName in AddUsers.SelectedItems || IsBlank(AddUsers.SelectedItems)),title), CountRows(colThisItem)+1)).Result,
groupId:Last(FirstN(Distinct(Filter(groups, name in Dropdown_Team.Selected.Result),id), CountRows(colThisItem)+1)).Result,
groupName:Last(FirstN(Distinct(Filter(groups, name in Dropdown_Team.Selected.Result),name), CountRows(colThisItem)+1)).Result
})
);

Any steer on this would be GREATLY appreciated