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))})
User | Count |
---|---|
229 | |
105 | |
93 | |
57 | |
30 |
User | Count |
---|---|
291 | |
119 | |
106 | |
62 | |
57 |