Hi All,
I have seen examples online but none meets my requirements. I want to use multiple filters to filter out items in a datasource used to populate the items in a gallery, I have something like;
If(ExcludeInput.Text<>"",Filter(newResults, Not(ExcludeInput.Text in metadata_storage_name)),newResults)
If(!IsEmpty(DeletedRecords),Filter(newResults, Not(metadata_storage_path in DeletedRecords.metadata_storage_path)),newResults)
How do I merge both filters to make it work, I want to remove items typed in the "excludeInput" text box and as well items in the "DeletedRecords" data source.
Thank you.
@RezaDorrani can you help pls?