Answered

How to split array into a datatable or html text box

(0) Share

Report

Posted on by robevans Microsoft Employee

I have an array that I store in a collection and currently I can dump the data into a data table. I've been struggling on how I can split that array by ",". I've tried the split function, but have had no success. I'm also not entirely sure where the split function should be entered, either at the trigger (the button) or the datatable piece.

split(collection,",")

Screen Shot 2019-06-03 at 4.23.27 PM.png

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Do you actually have an array or a comma delimited string stored in the collection. When I create a collection using the following code I can bind the collection directly to the datatable and each array value becomes a row.

ClearCollect(mytable,["Test1","Test2","Test3"])

Can you provide a screen shot of what is in your collection after you load the array?

Was this reply helpful? Yes No
robevans Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
So here's my button code that collects the data from Flow Array and also what my table looks like.

Here's the body being sent over from Flow.

{ "vardata": "[\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\",\"done\"]" }

Was this reply helpful? Yes No
robevans Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

On second look the type is a String and not an array being sent from Flow. This should still allow to split though?

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, it should allow split. The issue may be how it interprets the string. The escaped double quotes may still cause an issue.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @robevans ,

Could you please share a bit more about the result the DEV_HSRedaction.Run() formula returns? Just like ["done", "done", "done", ...., "done"] (a string value)?

Do you want to split the ["done","done","done", ...] string value into an array into a Data Table?

Based on the needs that you mentioned, I think the combination of Substitute function and Split function could achieve your needs.

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the Data Table2 to following formula:

Split(
Substitute(
Substitute(
Substitute(
Substitute(First(datafromflow).Value, "[", ""),
"]",""
),
"'",""
),
" ",""
),
","
)

On your side, please set the Items property of the Data Table control to following:

Split( Substitute( Substitute( Substitute( Substitute(First(datafromflow).Value, "[", ""), "]","" ), "'","" ), " ","" ), "," )

More details about the Substitute function and Split function, please check the following article:

Substitute function, Split function

Please take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
robevans Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-xida-msft that worked for the most part. Except the quotes are still present before and after done for me, but your screenshot is showing as removed. Did I miss a step?

Was this reply helpful? Yes No