You’re offline. This is a read only version of the page.
Hi everyone,
How can I split column values by delimiter as new rows into a Collection?
Example below:
regards,
AmiK
Hello,
@Amik , can You tell me what exactly was the problem with empty values?
I have used this formula based on xls table, and worked perfect.
After swap xls table to dataverse (the same data, the same columns, only different is a new column (ID) - auto-number type) the formula returns only records where the column with split values is not empty.
Best Regards, Krzysiek
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?
Share
Report
All responses (
Answers (
//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
)
}
)
)
)
)
)
Hi,
You can refer to this link it will help you to resolve your issue.
Solved: Multiple column split into rows - Power Platform Community (microsoft.com)
I hope it helps
If this post helps, then please consider Accept it as the solution to help the others and consider giving it a "Thumbs Up."
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
