How to Export a PowerApps Gallery to CSV File using Power Automate | 2023 Tutorial

Поделиться
HTML-код
  • Опубликовано: 4 дек 2024

Комментарии • 87

  • @c.mdsalih
    @c.mdsalih 8 месяцев назад

    Excellent video with clear explanation. Exactly what I was looking for and it worked. Thanks a ton 👍

  • @mateohidalgo2728
    @mateohidalgo2728 Год назад +1

    De todos los tutoriales que he buscado, este es el único que me ha funcionado, gracias un nuevo suscriptor :)

  • @emmanuelnamanja5646
    @emmanuelnamanja5646 Год назад +1

    This perfect!!!! youre the man

  • @moeking5601
    @moeking5601 11 месяцев назад

    works like a charm 👍👍

  • @alexmoller5657
    @alexmoller5657 Год назад

    Thanks so much, this was so helpful - I have been stressing about this for a few days - you solved it in 20 minutes 😁

  • @werachaisrisupinanont3353
    @werachaisrisupinanont3353 4 месяца назад

    Cool , Thanks a lot

  • @rajarajacholan4110
    @rajarajacholan4110 Год назад

    Thanks, this video is more helpful to learn powerapps

  • @DiyEverythingAlways
    @DiyEverythingAlways Год назад +1

    Great video!

  • @lsh_52
    @lsh_52 Год назад

    thank you so much, this video helped me a lot to build my own project

  • @chihab7673
    @chihab7673 11 месяцев назад

    thanks you so much

  • @aimeeoneil7029
    @aimeeoneil7029 Год назад

    Thank you... helped me out once again

  • @keimomomon
    @keimomomon 7 месяцев назад

    This is very helpful! Thank you for sharing 🤩

  • @bujjibabukj9616
    @bujjibabukj9616 Год назад

    Hi,
    Perfect..... Working fine
    Thank You

  • @deepaksartape9502
    @deepaksartape9502 11 месяцев назад

    Thank you so much. This is amazing video. Can we set the column width before export the data into excel/csv?

  • @jamesdavies4352
    @jamesdavies4352 4 месяца назад

    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...

  • @JenMayB
    @JenMayB Год назад

    Thank you! I definitely need help w how to get clean output for people picker and choice boxes.

  • @pavanbevara7885
    @pavanbevara7885 20 дней назад

    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

  • @marco-ys1oi
    @marco-ys1oi 11 месяцев назад +2

    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!

    • @lauramay35
      @lauramay35 11 месяцев назад +1

      Unfortunately, I can't help you, but I have the same problem :/

  • @vasilikievangelou9518
    @vasilikievangelou9518 11 месяцев назад

    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?

  • @gihanwijesinghe3466
    @gihanwijesinghe3466 Год назад

    Thanks

  • @samoabano
    @samoabano 9 месяцев назад

    I understand json doesn't handle lookup values, is there some kind of work around?

  • @MattHayduke
    @MattHayduke Год назад +2

    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?

    • @Ponyboy-dj7dj
      @Ponyboy-dj7dj Год назад

      Same problem here

    • @michaelalex2322
      @michaelalex2322  Год назад

      Looks like they removed the action. I'll have to figure it out

    • @ericw.3250
      @ericw.3250 Год назад +1

      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)

    • @lauramay35
      @lauramay35 11 месяцев назад +1

      I have the same problem and I can't fix it

  • @daeracosta2484
    @daeracosta2484 Год назад

    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?

    • @michaelalex2322
      @michaelalex2322  Год назад

      I think they need a Power Automate Basic License. I assume they'll need this to run the Flow creating the CSV File

  • @ivioe17
    @ivioe17 6 месяцев назад

    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.

  • @breadandcheese1880
    @breadandcheese1880 8 месяцев назад

    Great video, question - Is there anything different to do if my data source is dataverse?

    • @breadandcheese1880
      @breadandcheese1880 8 месяцев назад

      Nevermind i found the answer - However another question - Any way i can rename the headers prior to downloading the file?

    • @michaelalex2322
      @michaelalex2322  8 месяцев назад

      I would rename them in the Select statement in Power Automate

  • @narendracanvas
    @narendracanvas Год назад +1

    what is the formula to do for choice field in select data operation

    • @michaelalex2322
      @michaelalex2322  Год назад

      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
      }
      }
      )

  • @KristofferFortuna
    @KristofferFortuna Год назад

    great video man..how do you remove the "Value: " prefix in multiple selection sharepoint column in Select expression?

  • @TheMayank1000
    @TheMayank1000 Год назад

    Thanks for this video Michael. Can you pls guide how to get exact data from choice fields

    • @gracesantos9868
      @gracesantos9868 Год назад

      hello, did u manage to make the app for data with choice fields?

    • @TheMayank1000
      @TheMayank1000 Год назад

      @@gracesantos9868 yes

  • @WeamKashouh
    @WeamKashouh 8 месяцев назад

    Thanks working great but I'm having trouble with getting attachment link being downloaded, how to fix it

  • @simbakum
    @simbakum Год назад

    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.

    • @michaelalex2322
      @michaelalex2322  Год назад

      Make sure you include the JSON formula in your PowerApp and in Power Automate

  • @tomasborghi4566
    @tomasborghi4566 Год назад

    Great video! Is there any way to handle special characters. Example, the á is being showed as á

    • @michaelalex2322
      @michaelalex2322  Год назад

      Haven't dealt with special characters yet. I would reach out to the Power Apps forums.

  • @yedumkaimal8051
    @yedumkaimal8051 4 месяца назад

    Thanks for this great video. However when I click the download, it shows Sharepoint link got expired.

  • @raymundjunio580
    @raymundjunio580 5 месяцев назад

    Power Apps 2 - Upon creating the flow next in compose not show the ask in power apps and Data_inputs? 3:33

  • @Sabilainaa
    @Sabilainaa Год назад +1

    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 😢

  • @petrusottie7411
    @petrusottie7411 9 месяцев назад

    @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

    • @michaelalex2322
      @michaelalex2322  9 месяцев назад +1

      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

    • @petrusottie7411
      @petrusottie7411 9 месяцев назад

      @@michaelalex2322...I see that could be the reason...thank you so much.

  • @jl1399
    @jl1399 7 месяцев назад

    what if the results need to be greater than what is currently shown in the gallery?

  • @powerplatformninjas
    @powerplatformninjas 8 месяцев назад +1

    Any update for PowerApps v2?

    • @michaelalex2322
      @michaelalex2322  8 месяцев назад

      ruclips.net/video/IX-Kvm_b9ZQ/видео.html

  • @mickyslim1000
    @mickyslim1000 Год назад

    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??

    • @mickyslim1000
      @mickyslim1000 Год назад

      I should add, the flow works if i dont add the ['Value'] on the choice fields

    • @mickyslim1000
      @mickyslim1000 Год назад

      All sorted, rebuilt it again and is working fine… for now 👍🏻

    • @michaelalex2322
      @michaelalex2322  Год назад

      Haha, glad you were able to solve it!

    • @KristofferFortuna
      @KristofferFortuna Год назад

      @mickyslim1000 how did you solved it?

  • @fkboi-t4s
    @fkboi-t4s 8 месяцев назад

    how to fix select outputs body was "Requestor Email" : null ?

  • @adobestock7048
    @adobestock7048 Год назад

    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.

    • @michaelalex2322
      @michaelalex2322  Год назад +1

      Not familiar with Dataverse, so I can't help much

  • @NathanielCongreso
    @NathanielCongreso 8 месяцев назад

    Hi, mine is opening the online excel file instead of donwloading it directly.

  • @caroltasseff1827
    @caroltasseff1827 9 месяцев назад

    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!

    • @michaelalex2322
      @michaelalex2322  9 месяцев назад

      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

  • @damnbeliefs
    @damnbeliefs 7 месяцев назад

    How do i do it with powerapps v2? is not showing me ask in power apps

    • @michaelalex2322
      @michaelalex2322  7 месяцев назад

      ruclips.net/video/IX-Kvm_b9ZQ/видео.html

  • @eyll1234
    @eyll1234 Год назад

    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.

    • @rookybeats
      @rookybeats Год назад

      Hey! Try " item()?['colname']?['Value'] "

    • @eyll1234
      @eyll1234 Год назад

      too bad it failed ...it said "Array elements can only be selected using an integer index."

    • @michaelalex2322
      @michaelalex2322  Год назад

      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

    • @eyll1234
      @eyll1234 Год назад

      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

  • @mhochups2
    @mhochups2 Год назад

    How can I do this with image files?

    • @michaelalex2322
      @michaelalex2322  Год назад +1

      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.