Hi all,
I'm really new to Power Automate so would appreciate your advice on this:
Trying to export data from my Sharepoint List to a .csv file (example in the screenshot below), but I have two issues:
Many thanks in advance for the assistance!
Hi @lzh1991,
Thanks for sharing the raw inputs of the Create CSV table aciton.
Apologies if it is was not clear. But I was looking for a screenshot of the whole flow setup.
So, I can see what other actions you are using besides the Create CSV table. This might give us a clue why your issue is happening.
Hi @lzh1991 ,
I have made a simple test but it seems works fine on my side.
1. Here is my SharePoint list.
2. Here is my Flow.
Result Screenshot:
Best Regards,
Charlie Choi
Hi @Expiscornovus ,
Thanks for your reply.
So here's the raw inputs for the 'Create CSV table step'
Hi @lzh1991,
The header value mapping looks alright. Can you post a screenshot of the rest of your flow? This will help us troubleshoot issue 1.
For the date time values you could use an expression with a formatdatetime function in your Create CSV table action.
formatDateTime('<timestamp>', '<format>'?, '<locale>'?)
Try for example this instead of the Visit End Value. You can copy paste that into the expression editor.
formatdatetime(item()?['VisitEnd'], 'yyyy-MM-dd')