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

Re: Copy all row record into inputbox

2 REPLIES 2
Community Champion
Community Champion

Re: Copy all row record into inputbox

Highlighted
Frequent Visitor

Re: Copy all row record into inputbox

Thanks a lot , it's work

 

 

here is my code finially

 

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

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (8,470)