I have a table in the Dataverse created and updated by a PowerApp. Here is what I am trying to do.
It all sounds easy in my head but I get muddled with all of the options.
Welcome to Power Automate 😂
Hmm. I can paste in a column name with a space. So odd.
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.
Hmmm. Interesting. I wonder what I am doing differently. I simply can't enter a space after the word Campaign in that second row.
I can't confirm that.
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'?
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?
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.
I need to replace it with a file of the exact same name
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.
Michael E. Gernaey
566
Super User 2025 Season 1
David_MA
516
Super User 2025 Season 1
stampcoin
492