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?
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.
@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
Thanks, this works perfect!
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.
stampcoin
15
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1