web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Lookup column on View

Power Apps

Unanswered

Lookup column on View

(0) Share

Report

Report

Posted on by CrmUser101

180

I am creating view on Doc table , which has lookup column to doctype

In a view I am adding filters doctype eq to doc1,doc2,doc3 then show documents

Question is in current environment it is working as expected, but when I move solution in higher environments, where doc1,doc2,doc3 not present right, will be added later

will it still work?

on view when you check equals to doc1,doc2 , doc3, it matches with exact text or guid?

How can I resolve this issue?

Thanks,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

MarioRing 541 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
For queries like:
[Lookup column] equals [specific record]
the System searches using GUID of the chosen record(s).

That means the view may not work properly in different environments, because the chosen record may have a different GUID.

To solve this issue, you can either:
Change the filter operator from "equals" to "contains" or "begins with" and type a related record label (if it is unique)
Use XRMtoolbox plugin "Data Transporter" which allows you to copy records between environments preserving the same GUIDS on both.
Tip: This is also applicable to Business Rules.

Was this reply helpful? Yes No

Join the conversation