Incompatible types of comparison: Table and text cannot be compared

(0) Share

Report

Posted on by Chanman1998

Web capture_24-7-2023_123450_make.powerapps.com.jpeg

Web capture_24-7-2023_12385_make.powerapps.com.jpeg

Hi there, I am trying to use Index Function within the filter function. If the combo Box is blank or empty, then it will either return all icon or use search box to find the according icon. Otherwise, it will return the icon that you want.

However, for some reason it appears with the error of incompatible datatype. Could anyone tell me as to why it happened? (For the combo Box, my code is Choices(LandingPageList.DescriptionList))

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

WarrenBelz 154,928 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Chanman1998 ,

I am assuming here that your field DescriptionList is also multiple value, in which case you have a many-to-many relationship, so try this

With( { wData: Filter( 'LandingPageList', StartsWith( Title, SearchlnputBox.Text ) ) }, If( IsEmpty(ComboBox.Selectedltems), wData, Ungroup( ForAll( ComboBox.SelectedItems as aSel, Filter( wData, aSel.Value in DescriptionList.Value ) ), "Value" ) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
v-hanytian-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Chanman1998 ,

May I ask what data source you have used?
Is the type of field DescriptionList is Choice?

I am confusing about it will return the icon that you want. Can you give a simple example?

According to the error message we suggest you replace "=" into "in".

If you need any further assistance about this issue, please do not hesitate to reply to me.

Hope this will help you,
Best Regards,
Tina

Was this reply helpful? Yes No
Chanman1998 9 on at

Like (0)

Report
Copy link

Link copied!

I will check, see if that is possible. Many thx

Was this reply helpful? Yes No
Chanman1998 9 on at

Like (0)

Report
Copy link

Link copied!

1. I am using SharePoint list as my data source and yes my descriptionlist is Choice.
2. What I mean, was that if I select my preferred choice such as Human Resources for instance, then it will return those pages that are categorized of this category Human Resources.
3.I have tried to use "in" but it does not work.

Was this reply helpful? Yes No
WarrenBelz 154,928 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Chanman1998 ,

You might confirm whether DescriptionList is a single or multiple value choice field.

Was this reply helpful? Yes No
Chanman1998 9 on at

Like (0)

Report
Copy link

Link copied!

I think I select yes for allowing multiple selections hence the error occured. I have fixed it now, many thx

Was this reply helpful? Yes No
WarrenBelz 154,928 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Chanman1998 ,

So it is working now with a single selection ?

Was this reply helpful? Yes No
Chanman1998 9 on at

Like (0)

Report
Copy link

Link copied!

yes I think many to many operators does not work when using index function. Anyway fixed it , many thanks

Was this reply helpful? Yes No