Copy all row record into inputbox

[dogjumpjump]

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

[Meneghino · Accepted solution]

hi @dogjumpjump

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

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

[dogjumpjump]

Thanks a lot , it's work

here is my code finially

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