How to bulk delete records in a Dataverse table using Power Apps or Power Automate

Поділитися
Вставка
  • Опубліковано 11 гру 2024

КОМЕНТАРІ • 21

  • @beeepaiva
    @beeepaiva 3 місяці тому

    Amazing! I spent a lot of time trying to improve this on my flow and now with your video it worked perfect! Thank you!

  • @virajpatil6487
    @virajpatil6487 Рік тому +1

    Thank you for sharing this.... this solution no where on the web and this is what I was exactly looking for

  • @rodrsturge663
    @rodrsturge663 Рік тому +1

    Awesome, this is great for when you have to keep the dataverse current with external data

  • @glennsep
    @glennsep 9 місяців тому +1

    Great video. I am now able to bulk delete emails from my power automate cloud flow.

  • @changakevin8454
    @changakevin8454 11 місяців тому +1

    i have a question, i am trying this but, i put as paremaeter EntityName the name of my dataverse table. i got thhis error EntityNAME not found with a nmae = ...

  • @sergejamie440
    @sergejamie440 Рік тому

    Hi Darren, great video. Quick question i am trying to get the dataverse table name in the flow which is not linked to a canvas app and cant seem to get the table name to then set in the perform an unbound action step? If you could please direct me me to how to get the dataverse table in a flow not linked to a canvas app?
    Thanks Alan

    • @365assistdarrenlutchner9
      @365assistdarrenlutchner9  Рік тому

      Hi Alan, Good Question. I would suggest you ask your question in the Power Apps Community board powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

  • @josephlim2064
    @josephlim2064 Рік тому

    Hi Darren, what to enter for the RecurrencePattern at 4.40s if I want to create a recurring bulk delete job? Thank you

  • @jayasreebandaru5003
    @jayasreebandaru5003 Рік тому

    thanks for Sharing. Can we add a condition(where clause) to delete the table?

  • @advectusfb
    @advectusfb Рік тому

    is there anyway to test to see if the job has completed from a flow? once i have emptied a table i want to fill it again with fresh data.

    • @SithenderSurapur
      @SithenderSurapur 7 місяців тому

      I added do,Unitl action after my Job action, and looping the action until rowcount=0

  • @daisukeniwatari6616
    @daisukeniwatari6616 Рік тому +1

    How did you create the parameter "table name"? I cannot find any resource how to show that parameter

    • @365assistdarrenlutchner9
      @365assistdarrenlutchner9  Рік тому

      Apologies I should have explained that a bit more. Basically "Table Name" is a Parameter that is passed from the Power App and goes into Flows trigger as a Text Variable. This Document explains how to do it. learn.microsoft.com/en-us/power-apps/maker/canvas-apps/how-to/trigger-flow

    • @daisukeniwatari6616
      @daisukeniwatari6616 Рік тому

      @@365assistdarrenlutchner9 Thanks for this Darren. I was able to make the flow work. But I am having difficulty using the BulkDeleteResponse. Is that the variable I need to check if the job has succeeded?

  • @Yasinthas3
    @Yasinthas3 3 місяці тому +1

    Thank you

  • @doointhedoo
    @doointhedoo Місяць тому

    thank you Darren but you look like an AI generation. :)

    • @365assistdarrenlutchner9
      @365assistdarrenlutchner9  Місяць тому

      Thanks. If I made an AI generated image of myself I can assure you I would try to make myself younger and more handsome.