Thanks @Raksh1Wadel I did not see this thread.
At present the solution from @RandyHayes is working but it is only displaying records which contain multiple "Linked Ids". I also want to include records which do not contain multiple "Linked Ids" in the collection.
Does anyone know how I can edit the syntax to ensure all records are pulled in?
//Thanks to Randy Hayes https://powerusers.microsoft.com/t5/Building-Power-Apps/Multiple-column-split-into-rows/td-p/715847
Clear(collect_Mitigations2);
ForAll(
spl_Mitigation,
With(
{
mitigations: Split(
LinkedRiskIDs,
";"
)
},
With(
{statCount: CountRows(mitigations)},
ForAll(
Sequence(Max(statCount)),
Collect(
collect_Mitigations2,
{
Title: Title,
ID: ID,
Details: Details,
Date_x0020_complete: Date_x0020_complete,
Owner: Owner,
DueDate: DueDate,
Status: Status,
RAG_x0020_Status: RAG_x0020_Status,
Comments: Comments,
Last_x0020_Comment_x0020_DateTim: Last_x0020_Comment_x0020_DateTim,
Ongoing_Mitigation: Ongoing_Mitigation,
RiskID: If(
Value > statCount,
"",
Last(
FirstN(
mitigations,
Value
)
).Result
)
}
)
)
)
)
)
