Power Platform Community Forum Thread Details

Hi,

I am fairly new to PowerApps and building a Questionnaire App (includes 6-9 different scenarios) for my team where I source some data from few SharePoint lists. I have a text box - StoreID which may contain 1 or more values separated by a delimiter ",". I need to filter a gallery of Interface IDs based of the StoreID populated. I am able to do it for single StoreID but I am stuck for Multiple storeIDs.

Here is what I have so far:

For Single StoreID :

Filter(CustomerList, Customer_ID = StoreID .Text)

This formula works for 1 StoreID .

For Multiple Store ID:

1. First, created a collection to store multiple Store IDs when populated

ClearCollect(MultipleShopID,Split(StoreID .Text,","));

2. Second, below is the formula on the Gallery to display/filter Interface IDs for those multiple StoreID .

Filter(CustomerList, Customer_ID = MultipleShopID.Result)

FYI, StoreID and Customer_IDs are sourced from 2 different SharePoint list.

However, I am getting delegation error on the second formula.

"Delegation warning the filter part of this formula might not work correctly on large data sets."