Modify Data Table in Powerapps

(0) Share

Report

Posted on by sahachiranjit32

143

ClearCollect(MyCollection, 'Copyof-DBProcessFlow'.Run(1,"spTest"))

I'm storing in MyCollection in Powerapps datatable and it returns value from PowerAutomate like this

id filename createdon
[1,2] ["sss.jpg","sss.jpg"] ["2023-05-04T11:57:58.443","2023-05-04T11:57:58.443"]

I want to split data based on comma and remove "" .. like this

id filename createdon
1 sss.jpg 2023-05-04T11:57:58.443
2 sss.jpg 2023-05-04T11:57:58.443

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,

It was a bit complex but I will try to explain:

First I used regex to get the id's, filename's and createdon's and save it in a variable called vRegex and then loop for each item and create a collection named colFinal:

With( {items:MatchAll(Substitute(Label5.Text,"""",""),"(?<=\[)[^\]]*?(?=\])").FullMatch}, Set( vRegex, { id:Split(Index(items.FullMatch,1).FullMatch,","), filename:Split(Index(items.FullMatch,2).FullMatch,","), createdon:Split(Index(items.FullMatch,3).FullMatch,",") } ) ); ClearCollect( colFinal, ForAll( Sequence(CountRows(vRegex.id)), { id:Index(vRegex.id, ThisRecord.Value).Value, filename:Index(vRegex.filename, ThisRecord.Value).Value, createdon:Index(vRegex.createdon, ThisRecord.Value).Value } ) );

And this is the result:

Any doubts please let me know

Was this reply helpful? Yes No
sahachiranjit32 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @victorcp , I'm storing data in collection (MyCollection), data is coming from power automate. How do I use substitute function in collection

Was this reply helpful? Yes No
victorcp 2,350 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

So can you take a screen shot of your collection and paste it here please?

Was this reply helpful? Yes No
sahachiranjit32 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @victorcp ,

ClearCollect(MyCollection, 'Copyof-DBProcessFlow'.Run(1,"spTest"))

This code returs as follows in DataTable

Was this reply helpful? Yes No
Verified answer

victorcp 2,350 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
sorry, I thought it was a string, in this case try this:

With( {item:First(MyCollection)}, Set( vRegex, { id:Split(Substitute(Substitute(item.id,"[",""),"]",""),","), filename:Split(Substitute(Substitute(item.filename,"[",""),"]",""),","), createdon:Split(Substitute(Substitute(item.createdon,"[",""),"]",""),",") } ) ); ClearCollect( colFinal, ForAll( Sequence(CountRows(vRegex.id)), { id:Index(vRegex.id, ThisRecord.Value).Value, filename:Index(vRegex.filename, ThisRecord.Value).Value, createdon:Index(vRegex.createdon, ThisRecord.Value).Value } ) );

Was this reply helpful? Yes No
sahachiranjit32 143 on at

Like
a
(0)

Report
Copy link

Link copied!

@victorcp , Thank you so much 🙂

Was this reply helpful? Yes No