Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

From Datasverse to Azure Blob and everything in between

(0) ShareShare
ReportReport
Posted on by 825 Super User 2025 Season 1

I have a table in the Dataverse created and updated by a PowerApp. Here is what I am trying to do.

 

  1. When a row is added, deleted or modified I want to trigger the flow
  2. I don't need all of the columns, so I need to pick which ones I want.
  3. Change the column names.
  4. Write the output to a CSV file.
  5. Store the CSV file in Azure Blob (or possibly Azure File Storage)

It all sounds easy in my head but I get muddled with all of the options.

  • Matthy79 Profile Picture
    4,178 Super User 2024 Season 1 on at
    Re: From Datasverse to Azure Blob and everything in between

    Welcome to Power Automate 😂

  • futr_vision Profile Picture
    825 Super User 2025 Season 1 on at
    Re: From Datasverse to Azure Blob and everything in between

    Hmm. I can paste in a column name with a space. So odd.

     

  • Matthy79 Profile Picture
    4,178 Super User 2024 Season 1 on at
    Re: From Datasverse to Azure Blob and everything in between

    Maybe one of those special bugs. You can try to use the clipboard or a formula (string('Campaign whatever')) or you stick with the select action.

  • futr_vision Profile Picture
    825 Super User 2025 Season 1 on at
    Re: From Datasverse to Azure Blob and everything in between

    Hmmm. Interesting. I wonder what I am doing differently. I simply can't enter a space after the word Campaign in that second row.

    futr_vision_0-1699298309067.png

     

  • Matthy79 Profile Picture
    4,178 Super User 2024 Season 1 on at
    Re: From Datasverse to Azure Blob and everything in between

    I can't confirm that.

     

    Matthy79_1-1699297090046.png

     

    Matthy79_0-1699297065772.png

     

  • futr_vision Profile Picture
    825 Super User 2025 Season 1 on at
    Re: From Datasverse to Azure Blob and everything in between

    I don't have an Azure Blob storage instance provisioned yet but how would this process work? It looks like instead of 'Create File' I would use 'Create Blob'? I see there is also an 'Update Blob' action. Maybe here I need to use a condition that checks to see if the blob exists and it doesn't 'Create Blob' and if it does exist 'Update Blob'?

  • futr_vision Profile Picture
    825 Super User 2025 Season 1 on at
    Re: From Datasverse to Azure Blob and everything in between

    Just a note here. I tried removing the 'Select" action and do my column culling in the 'Create CVS Table' action. The 'Create CVS Table' action does not allow you to use a space in the column name. Is there a reason for this?

  • Matthy79 Profile Picture
    4,178 Super User 2024 Season 1 on at
    Re: From Datasverse to Azure Blob and everything in between

    There are a lot of ways to do this. One way would be to create a temporary file and use “move file” to move it to the real place. Move file has the option to replace the file. Or you can check if the file exists and delete it. I am sure there are other options too.

  • futr_vision Profile Picture
    825 Super User 2025 Season 1 on at
    Re: From Datasverse to Azure Blob and everything in between

    I need to replace it with a file of the exact same name

  • Matthy79 Profile Picture
    4,178 Super User 2024 Season 1 on at
    Re: From Datasverse to Azure Blob and everything in between

    You can also change the values during create csv the same way you do with the select action.

     

    For “File already exist” you have to think about what you want to happen. You could create the file with a timestamp or you replace the file or give it a new name. Depending on what you decide, your flow needs to be changed a little.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492