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






but there is no such concept on powerapss programing

so, I find this function, ForAll , may work, but I fail with this statement




Error : The function connot be invoked within ForAll


I would like to know, any other way can I implement my idea?


Thanks a lot



Accepted Solutions
Community Champion
Community Champion

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

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)