Problem with check if lookup is blank

[Matiss]

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. 

Some other solutions?

[dpoggemann · Accepted solution]

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.

[Matiss]

Thanks, this works perfect!

[AhmedSalih]

@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

[dpoggemann]

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.