Power Platform Community Forum Thread Details

CSV table column not showing on Excel sheet

Hello,

I created a recurrence flow that runs every Friday. The flow export my sharepoint list into an Excel sheet. In my sharepoint list I have some complex columns that were the “choice” type. Therefore when I ran the flow it gave me the string of those columns which made the data hard to read. In order to resolve the issue on the “Create CSV table” I mapped out each column and for the “choice” type I used the following expression:

join(xpath(xml(json(concat('{"body":{"value":', item()?['COLUMN NAME'] , '}}'))), '/body/value/Value/text()'), ', ')

the expression kind of worked since it gave me just the value of the string but not all the fields I mapped on the “Create CSV table” step show on the excel sheet. The worse part is that it doesn’t matter if I add or delete fields on the Create CSV table step the Excel sheet still shows the same field that went I first ran the flow. it’s like of the Excel sheet froze however the flow runs successfully.

what I need: how can I make sure I can see the new fields I mapped on the Create CSV table step shows on the excel sheet.

for reference I have a total of 19 fields mapped out (8 are of choice type) and only 11 are showing on the Excel sheet. And only one of them is of type “choice”

*see the picture to see the