Answered

Issue: can't be compared: Text, Record

(0) Share

Report

Posted on by caligame

I am trying to build a dependent drop-down based on the other dropdown selection.

For example, my first selection will be "Game Title" drop-down and second one will be "Game Content" drop-down based on the "Game Title"

Game Title drop down (Items) = Distinct('Product Details',Game).Result

Game Content drop down (Items) = Filter('Product Details', Game.Value = DataCardValue1.Selected.Result)

But I am having issue as below:

"Incompatible types for comparison. These types can't be compared: Text, Record."

Would anyone can help to resolve this issue?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

WarrenBelz 154,795 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @caligame ,

Do this on the first item

Distinct( AddColumns( 'Product Details', "GameValue", Game.Value ), GameValue ).Result

and the second one should work - NOTE due to a recent change, you may have to use .Value instead of .Result in both places.

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
caligame 38 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelzThanks for the comment! Columns already existed on Sharepoint List. I have connected those data to my power apps.

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

Like (1)

Report
Copy link

Link copied!

@caligame ,

Sorry confused here - what exactly do you mean by that ? GameValue would not exist presently.

Was this reply helpful? Yes No
caligame 38 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
I am not trying to add GameValue on the existing sharepoint list but trying to use the existing column data from the Sharepoint list (which is Game Title and Content).
For "Game Content", it should be filter out and able to select the available value only based on the "Game Title" selection (like cascading combo-box dropdown based on previous combo-box selection)

I have set Game Title as this (Distinct('Product Details',Game).Result)
and Game Content as this (Filter('Product Details', Game.Value = DataCardValue1.Selected.Result))

But having this error:

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

Like (1)

Report
Copy link

Link copied!

@caligame ,

The whole point is that Game is a Complex field type and it you want a Distinct value that is Text (to compare with second output, which is also Text), you need to use AddColumns in the Distinct Filter to produce a Text result.

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
caligame 38 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
Thanks! Seems it resolve the issue on error but I don't see any available selection although data is available on the list.

"Game Title" is a choice column and "Game Content" is Text Column on the SharePoint List. Do you know why I don't see any value here?

Was this reply helpful? Yes No
caligame 38 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
I have updated receiving data column as a "Text" value from another Sharepoint list and looks like now I am able to see the value. But facing another issue..Do you have any idea on this issue?

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

Like (0)

Report
Copy link

Link copied!

@caligame ,

What is the code that is producing that error ?

Was this reply helpful? Yes No