cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Caroline
Resolver I
Resolver I

table control 'expected text value' error on new columns

I have a form control which I have just added columns to from the data source. All the existing columns are fine, but the new ones are showing [object Object], and the text function is showing the 'expected text value' error. Previously added columns show correctly, regardless of the data type.

In the image below, the withdrawal reason was an existing column, and Age was added today. Any ideas on why this is happening?

 

Capture.JPG

17 REPLIES 17

Can you please share an image of the error you are getting (showing where specifically you are getting the error)? 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

Also since the error says that the type is not compatible with the collection, can you share any other formula that you are using to populate the collection prior to this formula?

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

@PowerAddict @v-siky-msft It's the part that is drawing from another data source:

 

CaptureFirst.JPGCaptureLookUp.JPG

And the controls you have for the values that you are trying to patch, are they the same data type?

 

Two more questions: 

 

1. Is this the only place in the app where you are collecting items into the Reports collection? If no, then please share the formula. 

2. Is there a specific reason you are using two collects and not combining both into one?

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

 

 

@PowerAddict yes, it's the only place where I'm collecting to Reports. I used two collects, just because they are two different data sources. I have just combined them and got the same error.

You should be able to use one collect though. Because this way, even if it works, it will add two rows, first with the names, and second with the email, phone and other details. 

 

Can you go to View->Collections->Report Collection and show me the column headers that are visible there?

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

So, I thought I'd take out the whole formula and add it one item at a time (again), to try and identify where the error is, and this time it was accepted without any errors. As the collection was looking good, I reloaded the data table (which was still showing [object Object] where the original data source column was an option set), and that is looking fine too.

Thanks for the assistance, @PowerAddict @v-siky-msft  

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,088)