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

Thanks a lot , it's work

 

 

here is my code finially

 

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,290)