Skip to main content

Notifications

Community site session details

Community site session details

Session Id : tXbxc65kugDYehuyg7jT7W
Power Apps - Microsoft Dataverse
Answered

Problem with check if lookup is blank

Like (0) ShareShare
ReportReport
Posted on 4 Mar 2022 09:42:22 by 29

Hello guys!

 

I need to filter Gallery by two paramteres, the formula should look something like this : 

 

 

Filter(ddati_planotasvakances_nodrosinajums, 'Vakances ID '.ID = Gallery_data.Selected.ID && IsBlank(UserID)=true)

 

 

where ddati_planotasvakances_nodrosinajums is the table, 'Vakances ID '.ID is simple ID, and the UserID is lookup column. 

With this formula i got delegation error. 

Matiss_0-1646386911190.png

Some other solutions?

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 04 Mar 2022 at 13:27:50
    Re: Problem with check if lookup is blank

    Hi @AhmedSalih ,

     

    The view will provide you results for your filters, etc. and when you update the records you utilize a patch or form method that will have the unique id of the record you are updating so it will not matter that you pulled back through the view.  hopefully this makes sense.

  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on 04 Mar 2022 at 13:25:38
    Re: Problem with check if lookup is blank

    @dpoggemann , When I used SQL as my data source and used the SQL views, I could only read the data from that view. So I am just curious if we can edit data through the Dataverse view in PowerApps canvas apps? 

    Thank you

  • Matiss Profile Picture
    29 on 04 Mar 2022 at 13:19:35
    Re: Problem with check if lookup is blank

    Thanks, this works perfect!

  • Verified answer
    Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on 04 Mar 2022 at 11:39:40
    Re: Problem with check if lookup is blank

    Hi @Matiss ,

    One option would be to create a view in the Dataverse on your table that shows all records where the UserId does not contain a value. You can then filter based on that view and it should remove the delegation issue.

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.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics

Loading started