cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Community Champion
Community Champion

2 REPLIES 2
Community Champion
Community Champion

Thanks a lot , it's work

 

 

here is my code finially

 

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

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (31,640)