cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User
Super User

Re: Collect to an excel file

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
Highlighted
Super User
Super User

Re: Collect to an excel file

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

Highlighted
Anonymous
Not applicable

Re: Collect to an excel file

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.

Community Champion
Community Champion

Re: Collect to an excel file

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

 

@TopShelf-MSFT

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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