cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dogjumpjump
Frequent Visitor

Copy all row record into inputbox

I am thinking about export table/collection/datasource to a file and save on ondrive,

 

I can use FLOW to create a csv file, and write a content into the file

 

but I fail to write all data in each rows of Table into CSV file

 

my idea is,

 

1. create a collection

2. read row one by one , and save each data into a inputbox (or variable)

3. user Flow function to write value of inputbox into as a content of CSV file

4. CSV file saved into user onedrive

 

In normal C# program, we can use for loop to save data in each row into a string variable, like

 

String tempstr = "";

foreach (DataRow dr in table.Rows) {

        tempstr += dr[0].value + "," + dr[1].value + Chr(13);

}

 

expect output of tempstr  : 

 

edward,123456

anna,4755

....

 

but there is no such concept on powerapss programing

so, I find this function, ForAll , may work, but I fail with this statement

 

ForAll(test1,UpdateContext({tempstr:name}))

 

Error : The function connot be invoked within ForAll

 

I would like to know, any other way can I implement my idea?

 

Thanks a lot

Edward

1 ACCEPTED SOLUTION

Accepted Solutions
Meneghino
Community Champion
Community Champion

2 REPLIES 2
Meneghino
Community Champion
Community Champion

hi @dogjumpjump

you can use the concatenation functions to achieve what you need:

https://powerapps.microsoft.com/en-us/tutorials/function-concatenate/

Thanks a lot , it's work

 

 

here is my code finially

 

UpdateContext({tempstr:Concat(test1,name & "," & address & Char(13))})

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,518)