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

Re: Copy all row record into inputbox

2 REPLIES 2
Meneghino Community Champion
Community Champion

Re: Copy all row record into inputbox

dogjumpjump
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
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,209)