Answered

Merge a table with 1 row every 2nd row

(0) Share

Report

Posted on by Jessetechno

I have a collection of data coming from an email that works like this:

"TIMESTAMP","Content","TIMESTAMP1","Content1","TIMESTAMP2","Content2","TIMESTAMP3","Content3"

I have this code that divides it where I can place it in a sub-gallery (inside the first one) to display in order with only the last 4:

LastN(Split(ThisItem.notes,","),4)

Result:

TIMESTAMP3

Content3

TIMESTAMP4

Content4

I would like to get it to combine each TimeStamp and Content together resulting in:

TIMESTAMP3: Content3

TIMESTAMP4: Content4

I am stumped as that what would be the best way to go about it.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
@Jessetechno

Please try the following,

ClearCollect(result, With({varSplitStrings: Split("TIMESTAMP1,Content1,TIMESTAMP2,Content2,TIMESTAMP3,Content3,TIMESTAMP4,Content4",",")}, LastN(RemoveIf(ForAll(Sequence(CountRows(varSplitStrings)), If(Mod(ThisRecord.Value,2)<>0, Index(varSplitStrings, ThisRecord.Value).Value & ": " & Index(varSplitStrings, ThisRecord.Value+1).Value ) ), ThisRecord.Value=Blank()), 2) ) )

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Jessetechno 30 on at

Like (0)

Report

I mean it kind of work, but it cuts out the first bit of data. I am gonna play with it to see if I can get that beginning data working. But its pretty good!

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@Jessetechno what do you mean by - it cuts the first bit of data. It does exactly what you wanted.

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Jessetechno 30 on at

Like (0)

Report
It does combine

"TIMESTAMP3,Content3,TIMESTAMP4,Content4"

but it got rid of:
"TIMESTAMP1,Content1,TIMESTAMP2,Content2"
I can see how it looks like I wanted this data out but that was a miscommunication on my part. I need all the data.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
@Jessetechno

Please try the following,

ClearCollect(result, With({varSplitStrings: Split("TIMESTAMP1,Content1,TIMESTAMP2,Content2,TIMESTAMP3,Content3,TIMESTAMP4,Content4",",")}, RemoveIf(ForAll(Sequence(CountRows(varSplitStrings)), If(Mod(ThisRecord.Value,2)<>0, Index(varSplitStrings, ThisRecord.Value).Value & ": " & Index(varSplitStrings, ThisRecord.Value+1).Value) ), ThisRecord.Value=Blank()) ) )

Please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No