Unanswered

Filter function error Incompatible Types cannot be compared: GUID, Table

(0) Share

Report

Posted on by Tushya_Trivedi

I have a Knowledge Assesments Table in Dataverse where 'Knowledge Assessment' is an automatically generated GUID, when I am trying to get rows from this table that match from a item selected in 'Knowledge Assesment Lists Gallery' (as shown in the formula I select the GUID from the gallery item) I am getting this error. I am trying to display the record that was selected on Take Assessment Screen's Gallery2. How to resolve this?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Filter('Knowledge Questions', 'Knowledge Assessments'.'Knowledge Assessment' = 'Knowledge Assessment List'.Selected.'Knowledge Assessment')

First you put the list
Than you put the name of the field in that list, that I assume it is: 'Knowledge Assessments'.'Knowledge Assessment'

And, after that, you put the thing to compare, that I assume it is:
'Knowledge Assessment List'.Selected.'Knowledge Assessment'

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Tushya_Trivedi 52 on at

Like (0)

Report

like this? still getting the same error

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (0)

Report

Knowledge Assessments'.'Knowledge Assessment' if you put a "."

Does not appear nothing?

Like:

Knowledge Assessments'.'Knowledge Assessment'.Value or somethnig?

Was this reply helpful? Yes No
Tushya_Trivedi 52 on at

Like (0)

Report

No nothing appears , also can't understand why it return table data when I want GUID, since Knowledge Assessment is a GUID.

Was this reply helpful? Yes No
Tushya_Trivedi 52 on at

Like (0)

Report

here Knowledge Assessments.Knowledge Assessment should return GUID but instead it says type table

Was this reply helpful? Yes No
Verified answer

Bipin D365 971 on at

Like (1)

Report
Hi @Tushya_Trivedi ,

Try below code and it works on my canvas app -
Filter( 'Knowledge Questions', 'Knowledge Assessment'.'Knowledge Assessment'='Knowledge Assessment List'.Selected.'Knowledge Assessment' )

You have added extra 'S' in your formula for knowledge assessment and that is why it did not worked.

Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/
Kudos and Accept my answer if helpful!

Was this reply helpful? Yes No
Tushya_Trivedi 52 on at

Like (0)

Report
Filter( 'Knowledge Questions', 'Knowledge Assessment'.'Knowledge Assessment'='Knowledge Assessment List'.Selected.'Knowledge Assessment' )

Here GUID value is extracted from Knowledge Assessment.Knowledge Assessment , that's how it works for GUID?

Was this reply helpful? Yes No
Bipin D365 971 on at

Like (0)

Report

Hi @Tushya_Trivedi ,

You are correct.
We rely on GUID because it's unique and can not be duplicate.

Regards,
Bipin Kumar
Follow my Blog: https://xrmdynamicscrm.wordpress.com/
Kudos and Accept my answer if helpful!

Was this reply helpful? Yes No