Filter a Gallery - Source SharePoint List based on a Collection value

(0) Share

Report

Posted on by indhaa

Hi,

How to filter SharePoint List based on Collection Value. Only one record will be in the collection.

I just want to test something. Don't want to use combo box for the filter.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

zuurg 535 Super User 2024 Season 1 on at

Like (0)

Report

If there will only be 1 record in the collection, you can just use First(collectionname).SourceDestName.

So it would be Filter('Firewall - ...',SourceDestName = First(colFirewallAddressSelected).SourceDestName)

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report

There is a delegation warning. Since the SharePoint list have more records this is not a solution.

Is there a way I can Filter a SharePoint list with a collection record without a delegation warning.

Was this reply helpful? Yes No
zuurg 535 Super User 2024 Season 1 on at

Like (0)

Report

The delegation warning is from using the First function. In your original question, you said there would only be 1 record in the collection, so the filtering will work properly. If there will be more than 1 record in the collection, instead of First, you'll need to use Filter to find the collection's record.

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report

Hi,

There is only one record in the collection but the Filter is used on the SharePoint list and based on the one record in the collection it is retrieving the record from the SharePoint list.

Is there a way I can change the formulae to filter from the SharePoint List for this one record in the collection without getting the delegation error.

Was this reply helpful? Yes No
zuurg 535 Super User 2024 Season 1 on at

Like (0)

Report

Can you provide the final filtering code that you ended up using? Note that the delegation warning (not error) that you're getting is more than likely only applicable to the "first" portion of your query, which again, if the collection only contains the one record, will never be an issue. For Sharepoint data sources, Filter can be delegated. First() cannot, but first is being applied to your collection, not the SP list.

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Filter( 'Firewall - Add List', SourceDestName = First(colFirewallAddressSelected).SourceDestName)

I need to use a collection for this filter.

Was this reply helpful? Yes No
Verified answer

zuurg 535 Super User 2024 Season 1 on at

Like (0)

Report

If you absolutely don't want the warning there (again, it won't be an issue with a 1 record Collection), you can always assign your Collection value that you're filtering on to a variable (either local or global) and use that as the filtering value for the SP List.

So for the screen that your filtering on, for the OnVisible property, add UpdateContext({locSourceDestName: First(colFirewallAddressSelected).SourceDestName })

Then for your filtering, Filter('Firewall - Add List',SourceDestName = locSourceDestName)

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report

Hi,

I'm testing on how I can make SharePoint list available as a drop down on a Combo Box without a delegation.
That was the code that I was having issue.

Now work as a charm.

Was this reply helpful? Yes No