How to use multiple filter to filter a datsource for gallery items

(0) Share

Report

Posted on by onyebuchiboss

143

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@onyebuchiboss

Please consider changing your Formula to the following:

Filter(newResults, (IsBlank(ExcludeInput.Text) || !(ExcludeInput.Text in metadata_storage_name) && ((CountRows(DeletedRecords)=0) || !(metadata_storage_path in DeletedRecords.metadata_storage_path)) )

I hope this is helpful for you.

Was this reply helpful? Yes No
onyebuchiboss 143 on at

Like (0)

Report
Copy link

Link copied!

Thanks for responding Randy, but the system wouldn't recognise the DeletedRecods.metedata_storage_path, even though it obviously in the collection properties.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@onyebuchiboss

How are you defining that DeletedRecords table?

Was this reply helpful? Yes No
onyebuchiboss 143 on at

Like (0)

Report
Copy link

Link copied!

Sorry, but this ddnt work.

Was this reply helpful? Yes No
onyebuchiboss 143 on at

Like (0)

Report
Copy link

Link copied!

It is a collection of items from the gallery, since it is deleted, I do not want users seeing it.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@onyebuchiboss

How are you defining that DeletedRecords table? What is the formula?

Was this reply helpful? Yes No
onyebuchiboss 143 on at

Like (0)

Report
Copy link

Link copied!
I was able to finally use your suggestion, your formula just only needed an extra bracket, just still not working. this is how I collect the DeletedRecords;
Collect( DeletedRecords, { id: "1", metadata_storage_path: galleryResults.Selected.metadata_storage_path, decoded_path: decoded_path2, deletion_scheduled_date: Text(Now(),"[$-en-US]yyyy-mm-dd"), deletion_scheduled: true, who_deleted: User().FullName, who_marked_deleted: User().FullName });

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@onyebuchiboss

Ah yes, I see there was a paren missing. Should have been:

Filter(newResults, (IsBlank(ExcludeInput.Text) || !(ExcludeInput.Text in metadata_storage_name)) && ((CountRows(DeletedRecords)=0) || !(metadata_storage_path in DeletedRecords.metadata_storage_path)) )

So what part is not working and elaborate on what is happening and expected.

Was this reply helpful? Yes No
onyebuchiboss 143 on at

Like (0)

Report
Copy link

Link copied!

I can see the records in the DeleteRecords collection, and can still see the records in the gallery, so the filter isn't working.

Was this reply helpful? Yes No
onyebuchiboss 143 on at

Like (1)

Report
Copy link

Link copied!

My bad, I have just put the Paren in the right place and it worked. Thanks a lot! I will mark as solution.

Was this reply helpful? Yes No