You’re offline. This is a read only version of the page.
Hi,
I am wondering how I can filter based on a lookup column?
So I have a table with student certificates which has a lookup to the student table, at the moment I have added my own foreign key to the certficatesd table as the lookup is not working.
So, if I try to filter student table:
Filter(Students, studentguid in (Filter(certficates, certifacte = "Cisco").[lookupcolumnnameforstudent]
But it says cannot compare guid to a record...and when I try to add another dot it doesn;t offer me the name of guidcolum to student so i cannot compare guid against guid...any ideas very welcome! I don't want to use my own foreign key as it needs to be manually inputted which may lead to errors.
Thanks
Hi, Thanks.
I have tried this and it for the LookUp where I put my second table name it says this column is not accessible in this context...is there some setting I need to make for it to be accessible?
Thanks
Hello @MichelleH,
Not Sure if i understand your requirement clearly, you can try below
Share
Report
All responses (
Answers (Filter(Students, studentguid in (Lookup(Certficates, certifacte = "Cisco").StudentGuid))
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
Hello,
I have nerver test it but it worth a try to do something like
Filter(Students, studentguid in Concat((Filter(certficates, certifacte = "Cisco").[lookupcolumnnameforstudent],";")
The idea here is to create a string of [lookupcolumnnameforstudent] concat with a ; and get the ones that contains the studentguid
Not the most elegant solution but it could work 🙂
Best regards,
Alaa
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
