Hi, great tutorial thanks so very much. One little issue for me, have a priority column that just will not populate in the csv output, have checked and double checked but cannot find a reason for it not populating? In the outputs of the Create CSV the 'priority' field states 'null', its a single line text in the SP list as all other columns are, would appreciate any advice...
Hi, Thanks for video, but you told that gallery to CSV , i want to get the values form gallery not from DB , in flow you are using like item()?['Columnname'] but here what i have to write , you are taking form DB, but i want to get form the gallery ...could you explain please
I have tried to replicate it step by step but now PowerApp has been replaced with PowerApp V2 and I can't find the "Compose" action as shown at min.3:00 of your video. Any idea ? thanks!
Hey Michael - I only have PowerApps V2 as an option, which says it has no dynamic content. Which means no "Ask in PowerApps." So I'm basically stuck at a very early step. Do you have any advice?
Hi Michael, I like your video, it helped me a lot. I have a question, what license or add-on do your users use to download Excel files from that app? In my work i have an Office 365 license but not all my users have it, so can I request only the pugin to download the Excel report?
You will need to replace your variables. My Full OnSelect: Patch( 'Employee Data', LookUp( 'Employee Data', Title = ThisItem.Title ), { 'Favorite Fruit': { '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Id: 1, Value: cmb_fav_fruit.Selected.Value } } )
Such a good Tutorial, thank you. When I repeat your steps all the data is stored in one column. Does anybody have a solution for this problem. Also my Data looks exacly like yours in the Test Flow Steps. Thanks for the help in advance.
Hi my function not working even though I tried all instructions, it comes message the function Json has some invalid arguments. Idk what's the mistakes 😢
@AlexMichael....Hi ...I have a sharepoint list that has a boolean column where by if the value is TRUE it will put a right sign otherwise no value if it is FALSE. To my surprise when I export the records from canvas powerapps the exported CSV file does show any value in that boolean column. Please help
I assume if nothing was ever entered in the boolean column it would return null. You'll have to account for that in your PowerApp, if null then set to false
Hi, thanks, this video has really helped me get further in 20 minutes than I have in days. I do still have an issue with some choice fields throwing an error that the value doesn't exist. I get a longer message, but the error is 'Action 'Select' failed' Any advice on this please??
I’m stuck at the Select step. For my items()? expressions I am using things like items()?[‘PARENTID_x003a__x0020_RESERVE’][‘Value’]. When I try to save the flow, I get an error that says “The template validation failed….The template language function ,items, must have at least one parameter.” Can you offer any suggestions as to what I am doing wrong? Thanks!
You can try adding a question mark between [‘PARENTID_x003a__x0020_RESERVE’] and [‘Value’] (items()?[‘PARENTID_x003a__x0020_RESERVE’]?[‘Value’]). That would make the Value optional if there is no value there. Could be why you're getting that issue
Thanks so much for the video, it was really helpful. But when I export the grid data and test the flow, it shows "{""Value"":""Apple""},{""Value"":""Orange""}" in one of the fields in the csv file. How can I replace the "{""Value"":"" and just simply shows "Apple, Orange"? Thanks a lot again.
Basically, you have to concatenate all the array elements into a string. You have to use Compose action with the Join function on whatever variable is holding the data
sorry I tried that too .... but the "create CSV table" action expects array .... I have trouble converting the string back to the array for creating CSV file. @@michaelalex2322
I haven't done this with image files and don't know if it's possible. I'm sending the data over as JSON and I don't know how JSON and image work together.
Excellent video with clear explanation. Exactly what I was looking for and it worked. Thanks a ton 👍
De todos los tutoriales que he buscado, este es el único que me ha funcionado, gracias un nuevo suscriptor :)
¡Gracias por las amables palabras!
This perfect!!!! youre the man
Haha thanks, glad to help!
works like a charm 👍👍
Thanks so much, this was so helpful - I have been stressing about this for a few days - you solved it in 20 minutes 😁
Cool , Thanks a lot
Thanks, this video is more helpful to learn powerapps
Glad it helped
Great video!
Glad you enjoyed it!
thank you so much, this video helped me a lot to build my own project
You are welcome!
thanks you so much
Thank you... helped me out once again
Glad to hear it!
This is very helpful! Thank you for sharing 🤩
Glad it was helpful!
Hi,
Perfect..... Working fine
Thank You
Welcome 👍
Thank you so much. This is amazing video. Can we set the column width before export the data into excel/csv?
Hi, great tutorial thanks so very much. One little issue for me, have a priority column that just will not populate in the csv output, have checked and double checked but cannot find a reason for it not populating? In the outputs of the Create CSV the 'priority' field states 'null', its a single line text in the SP list as all other columns are, would appreciate any advice...
Thank you! I definitely need help w how to get clean output for people picker and choice boxes.
Hi, Thanks for video, but you told that gallery to CSV , i want to get the values form gallery not from DB , in flow you are using like item()?['Columnname'] but here what i have to write , you are taking form DB, but i want to get form the gallery ...could you explain please
I have tried to replicate it step by step but now PowerApp has been replaced with PowerApp V2 and I can't find the "Compose" action as shown at min.3:00 of your video. Any idea ? thanks!
Unfortunately, I can't help you, but I have the same problem :/
Hello thanks for you video, I managed to implement it, however the exported file gives only the first 100 rows. Any idea of how I could resolve it?
Thanks
No problem!
I understand json doesn't handle lookup values, is there some kind of work around?
Hey Michael - I only have PowerApps V2 as an option, which says it has no dynamic content. Which means no "Ask in PowerApps." So I'm basically stuck at a very early step. Do you have any advice?
Same problem here
Looks like they removed the action. I'll have to figure it out
Choose "Text" in the PowerApps (V2) part (and maybe rename it) and in the compose (data) as input chose the name you gave it (not the body)
I have the same problem and I can't fix it
Hi Michael,
I like your video, it helped me a lot.
I have a question, what license or add-on do your users use to download Excel files from that app?
In my work i have an Office 365 license but not all my users have it, so can I request only the pugin to download the Excel report?
I think they need a Power Automate Basic License. I assume they'll need this to run the Flow creating the CSV File
How to do a complex columns same as your example?
I have a columns that has a person &group type and i want to grab the display name into my csv file.
Great video, question - Is there anything different to do if my data source is dataverse?
Nevermind i found the answer - However another question - Any way i can rename the headers prior to downloading the file?
I would rename them in the Select statement in Power Automate
what is the formula to do for choice field in select data operation
You will need to replace your variables. My Full OnSelect:
Patch(
'Employee Data',
LookUp(
'Employee Data',
Title = ThisItem.Title
),
{
'Favorite Fruit': {
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: 1,
Value: cmb_fav_fruit.Selected.Value
}
}
)
great video man..how do you remove the "Value: " prefix in multiple selection sharepoint column in Select expression?
item()?['ColumnName']?['Value']
Thanks for this video Michael. Can you pls guide how to get exact data from choice fields
hello, did u manage to make the app for data with choice fields?
@@gracesantos9868 yes
Thanks working great but I'm having trouble with getting attachment link being downloaded, how to fix it
Such a good Tutorial, thank you. When I repeat your steps all the data is stored in one column. Does anybody have a solution for this problem. Also my Data looks exacly like yours in the Test Flow Steps. Thanks for the help in advance.
Make sure you include the JSON formula in your PowerApp and in Power Automate
Great video! Is there any way to handle special characters. Example, the á is being showed as á
Haven't dealt with special characters yet. I would reach out to the Power Apps forums.
Thanks for this great video. However when I click the download, it shows Sharepoint link got expired.
Power Apps 2 - Upon creating the flow next in compose not show the ask in power apps and Data_inputs? 3:33
Hi my function not working even though I tried all instructions, it comes message the function Json has some invalid arguments. Idk what's the mistakes 😢
Same here
@AlexMichael....Hi ...I have a sharepoint list that has a boolean column where by if the value is TRUE it will put a right sign otherwise no value if it is FALSE. To my surprise when I export the records from canvas powerapps the exported CSV file does show any value in that boolean column. Please help
I assume if nothing was ever entered in the boolean column it would return null. You'll have to account for that in your PowerApp, if null then set to false
@@michaelalex2322...I see that could be the reason...thank you so much.
what if the results need to be greater than what is currently shown in the gallery?
Any update for PowerApps v2?
ruclips.net/video/IX-Kvm_b9ZQ/видео.html
Hi, thanks, this video has really helped me get further in 20 minutes than I have in days. I do still have an issue with some choice fields throwing an error that the value doesn't exist. I get a longer message, but the error is 'Action 'Select' failed' Any advice on this please??
I should add, the flow works if i dont add the ['Value'] on the choice fields
All sorted, rebuilt it again and is working fine… for now 👍🏻
Haha, glad you were able to solve it!
@mickyslim1000 how did you solved it?
how to fix select outputs body was "Requestor Email" : null ?
Thanks, your video is very useful, but for choice column and lookup column didn't work with me, i user Dataverse, can you help me.
Not familiar with Dataverse, so I can't help much
Hi, mine is opening the online excel file instead of donwloading it directly.
I’m stuck at the Select step. For my items()? expressions I am using things like items()?[‘PARENTID_x003a__x0020_RESERVE’][‘Value’]. When I try to save the flow, I get an error that says “The template validation failed….The template language function ,items, must have at least one parameter.”
Can you offer any suggestions as to what I am doing wrong?
Thanks!
You can try adding a question mark between [‘PARENTID_x003a__x0020_RESERVE’] and [‘Value’] (items()?[‘PARENTID_x003a__x0020_RESERVE’]?[‘Value’]). That would make the Value optional if there is no value there. Could be why you're getting that issue
How do i do it with powerapps v2? is not showing me ask in power apps
ruclips.net/video/IX-Kvm_b9ZQ/видео.html
Thanks so much for the video, it was really helpful. But when I export the grid data and test the flow, it shows "{""Value"":""Apple""},{""Value"":""Orange""}" in one of the fields in the csv file. How can I replace the "{""Value"":"" and just simply shows "Apple, Orange"? Thanks a lot again.
Hey! Try " item()?['colname']?['Value'] "
too bad it failed ...it said "Array elements can only be selected using an integer index."
Basically, you have to concatenate all the array elements into a string. You have to use Compose action with the Join function on whatever variable is holding the data
sorry I tried that too .... but the "create CSV table" action expects array .... I have trouble converting the string back to the array for creating CSV file. @@michaelalex2322
How can I do this with image files?
I haven't done this with image files and don't know if it's possible. I'm sending the data over as JSON and I don't know how JSON and image work together.