Collect to an excel file

[cmvanwingerden]

I am trying to add data from my CDS to an excel file for printing purposes and I am running into an error. I have button that collects from my excel table and the items are from a table in my CDS but the error i am getting is "Incompatible Type. ""The "Complete_Status_TR" column in the datasource you're updating expects a "Text" type and you're using a "Boolean" Type. "" From my research i know excel doesnt have a boolean format so is that a work around of is there a way to eliminate that column from the collect function because i dont need it in the excel file. My current formula looks like this.

Collect(AxTable1,'Treatment Records')

Worse case I know i can collect each column individally but would like to avoid if possible. 

[timl · Accepted solution]

Hi @cmvanwingerden

You should be able to exclude your "Complete_Status_TR"  column by calling the DropColumns function like so:

Collect(AxTable1, DropColumns('Treatment Records'), "Complete_Status_TR")

[Anonymous]

Excel does have a Boolean type but it may be stored as 0 and 1 in the xlsx file. it sbeen a while since I ripped one apart.

have you thought of using a Flow to achieve this as there are better tools for mucking around with tables and such. Its also a lot easier to code it in Flow too.

[TopShelf-MSFT]

Thanks for posting in the community @cmvanwingerden! Can you review the two replies and advise if it solves your issue?

@TopShelf-MSFT