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.
Solved! Go to Solution.
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")
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")
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.
Thanks for posting in the community @cmvanwingerden! Can you review the two replies and advise if it solves your issue?
@Anonymous
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
204 | |
180 | |
62 | |
32 | |
30 |
User | Count |
---|---|
324 | |
270 | |
104 | |
74 | |
56 |