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...
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!
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?
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
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?
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 😢
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??
@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
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 } } )
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!
Great video!
Glad you enjoyed it!
This perfect!!!! youre the man
Haha thanks, glad to help!
Thanks so much, this was so helpful - I have been stressing about this for a few days - you solved it in 20 minutes 😁
works like a charm 👍👍
Thanks, this video is more helpful to learn powerapps
Glad it helped
Thank you so much. This is amazing video. Can we set the column width before export the data into excel/csv?
thank you so much, this video helped me a lot to build my own project
You are welcome!
This is very helpful! Thank you for sharing 🤩
Glad it was helpful!
Hi,
Perfect..... Working fine
Thank You
Welcome 👍
Thank you... helped me out once again
Glad to hear it!
Cool , Thanks a lot
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...
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 :/
Thank you! I definitely need help w how to get clean output for people picker and choice boxes.
thanks you so much
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
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
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
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
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?
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
great video man..how do you remove the "Value: " prefix in multiple selection sharepoint column in Select expression?
item()?['ColumnName']?['Value']
I understand json doesn't handle lookup values, is there some kind of work around?
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
No problem!
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
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.
Power Apps 2 - Upon creating the flow next in compose not show the ask in power apps and Data_inputs? 3:33
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?
Thanks working great but I'm having trouble with getting attachment link being downloaded, how to fix it
@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 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
}
}
)
Thanks for this great video. However when I click the download, it shows Sharepoint link got expired.
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
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
what if the results need to be greater than what is currently shown in the gallery?
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
Any update for PowerApps v2?
ruclips.net/video/IX-Kvm_b9ZQ/видео.html
how to fix select outputs body was "Requestor Email" : null ?
Hi, mine is opening the online excel file instead of donwloading it directly.
How do i do it with powerapps v2? is not showing me ask in power apps
ruclips.net/video/IX-Kvm_b9ZQ/видео.html
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.