cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Collect to an excel file

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

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")

 

View solution in original post

3 REPLIES 3
Super User III
Super User III

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")

 

View solution in original post

Anonymous
Not applicable

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.

Anonymous
Not applicable

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

 

@Anonymous

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,567)