Hi,
Hoping someone can assist with a problem I am having with a formula and filtering gallery results.
I have a lost property register within an app which works across multiple contracts. The data used in the app is stored in dataverse across multiple tables, as the app has other functions.
The main landing screen of the app allows the user to select their contract, and then all subsequent galleries, choices etc need to be managed from the first selection made in the dropdown, which is called ddContracts.
I currently have the Lost Properties gallery filtered to display the items relating to that contract, and it works displaying all items from that contract
Search(
Filter(
'Lost Properties',
'Contract ID'.'Contract Name' = ddContracts.Selected.Result
),
TextSearchBox5.Text,
"crXXX_description",
"crXXX_foundby"
)
I would like the gallery to also be able to be filtered by the result of a column in the table 'Lost Properties' which is called 'Claimed Time Stamp' (which is a date/time column). Ultimately, if 'Claimed Time Stamp' is empty, then the item should be visible and if there is an entry for 'Claimed Time Stamp', then the entry should be filtered out as the item is no longer 'active' as a lost property item.
I have tried with the Is Blank() but I am getting confused with the syntax due to the Search & Filter already being applied to ensure only the correct contract is on display.
Also, the text search box is currently only able to search by the columns "crXXX_description and "crXXX_foundby" to filter the results. I would like to be able to use other attributes (e.g. Site Location and Found at) but these are Look-Up columns in the 'Lost Properties' table and I get the delegation warning, even though I have increased the records setting, and there would not be over 2000 records.
Any help would be greatly appreciated.
