Announcements
Hi, I need to get "Result Exists " when Company column selected any value and Managerstatus is "Pending".
Here company is lookup column it will get values from 'MasterList' and Managerstatus is dropdown column not lookup column. Forms is in 'PWList'.
@Mattishven - Good day! I have moved your question here so that you will be able to get a resolution and assistance from the users in the community.
Thank you,
Heather
Community Manager
@Mattishven Put this code in the TEXT property of your label
!IsBlank(LookUp(MasterList, Title=DataCardValue5.Selected.Value And Managerstatus.Value="Pending")),"Result Exists")
---Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 333 Most Valuable Professional
11manish 184
MS.Ragavendar 86 Super User 2026 Season 1