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
Solved! Go to Solution.
hi @dogjumpjump
you can use the concatenation functions to achieve what you need:
https://powerapps.microsoft.com/en-us/tutorials/function-concatenate/
hi @dogjumpjump
you can use the concatenation functions to achieve what you need:
https://powerapps.microsoft.com/en-us/tutorials/function-concatenate/
Thanks a lot , it's work
here is my code finially
UpdateContext({tempstr:Concat(test1,name & "," & address & Char(13))})
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
198 | |
171 | |
60 | |
32 | |
31 |
User | Count |
---|---|
339 | |
270 | |
104 | |
72 | |
56 |