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

All responses (5)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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.
Jessetechno 30 on at

Like
a
(0)

Report
Copy link

Link copied!

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!
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.
Jessetechno 30 on at

Like
a
(0)

Report
Copy link

Link copied!
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.
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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.