This Data type is unsuported For evaluation

(0) Share

Report

Posted on by ZR-13111546-0

I am very new to Powerapps and Dataverse, so far I had been doing good until i tried to build summary page,

the main deal is that I tried to do this

ClearCollect(
    UserMainRecords,
   Filter(AID_Tbl_RMains, Rm_Empl_IP_FK.Empl_IP_PK = "1234567")
)

to create a collection with records that meet this criteria, so that later on I could do some type of summary operation, the main problem is that i get a collection back that is filtered but without any data, and that one column I am filtering has that error displayed. what am I doing wrong

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hey

can u try this:

ClearCollect( UserMainRecords, Filter(AID_Tbl_RMains, Rm_Empl_IP_FK.'Empl_IP_PK' = "1234567") )

if it workes please mark my answer as verified,

thanks

Was this reply helpful? Yes No
ZR-13111546-0 8 on at

Like (0)

Report
Copy link

Link copied!

now I get The '.' operator cannot be used on Error values.

basically it refuses to see the column

Was this reply helpful? Yes No
ZR-13111546-0 8 on at

Like (0)

Report
Copy link

Link copied!

after much sweating and dotting, rewriting and experimenting we arrived at this

ClearCollect(

RMainsWithDetails,

ShowColumns(

AddColumns(

ShowColumns(

Filter(

AID_Tbl_RMains,

z1a8r_Rm_Empl_IP_FK.Empl_Email = "MPerez@pancanal.com" // Replace with specific email or use User().Email

),

z1a8r_rm_id_pk, // Only brings RM_ID_PK

z1a8r_rm_date, // Only brings Rm_Date

z1a8r_Rm_Empl_IP_FK

),

EmployeeEmail, z1a8r_Rm_Empl_IP_FK.Empl_Email // Adds EmployeeEmail from lookup field

),

EmployeeEmail,

z1a8r_rm_date,

z1a8r_rm_id_pk

)

);

I had to add the second show columns because on the first ShowColumns it was bringing this z1a8r_Rm_Empl_IP_FK column with a question mark in it, however since it was bringing the rest of the data I was happy and proceeded to filter that column out .

if someone con please explain to mw why this kind of sort of work i would really appreciate it

Was this reply helpful? Yes No
ronaldwalcott 3,866 Moderator on at

Like (0)

Report
Copy link

Link copied!

How did you link your tables?

Is Rm_Empl_IP_FK.Empl_IP_PK defined as lookup column or are you manually maintaining the relationships?

Was this reply helpful? Yes No
ZR-13111546-0 8 on at

Like (0)

Report
Copy link

Link copied!

they are not lookup columns, when I did that the first time it was giving me even more headaches, however they were defined as keys and relationships created

Was this reply helpful? Yes No