Can you Filter Gallery by Detail Form DataCardValues

[enlitzinger]

Using the PowerApps default option within Sharepoint Online. 

Backstory:

• Leveraging Sharepoint Online, I have created Site Level Columns that 3 lists will be using as Lookup Values. 
• List 1 is a submission list, where the user submits general information (category) about a Project.  The values submitted are lookups to the various Site Level Columns, and the user can submit multiple selections related to each category for a single project.
• List 2 & 3 are results lists.  List 2 contains information for Project Resources, related to how their expertise matches to those Site Level Columns (categories).  List 3 contains information for Project Considerations, related to how considerations and parameters match to those Site Level Column (categories).  

Scenario: I'm building an app off of the Submission List, starting it from the 'Create an App' option from the PowerApps drop down.  The standard functionality is exactly what I want, but is lacking pieces I need to build out.  Once a Project is submitted (which can contains multiple selections within each category (or column), I want the app to go to a screen that uses a Gallery to filter results from List 2 - based on List 1 submission criteria.  I know how to navigate between screens, but cannot figure out how to get a gallery to be filtered from the datacard values within the standard DetailForm1 that the App provides.  Once I can get this to work I'll then need to create an additional screen to filter results from List 3 - based on List 1 submission criteria.

I've watched several youtube tutorials and have browsed this forum seeking insight to no avail.  Any assistance or insight is greatly appreciated.  Regrettably I am on a company computer and cannot attach screen shots.

[v-xida-msft · Accepted solution]

Hi @enlitzinger ,

Could you please share a bit more about your scenario?

Could you please share a screenshot about the data card value in your DetailForm?

Do you add one LookUp Type column within each of your three SP Lists? Do you relate the List 1 and List2 based on the LookUp Type columns (Categories)?

Based on the needs that you mentioned, I think you need to filter your Gallery Items based on the Categories LookUp column (enable "Allow Multiple Options").

The Categories LookUp column would be decorated as ComboBox within your DetailForm1, if you want to get the values (selected options) from the Categories ComboBox, you should type the following formula:

Concat(DataCardValue3.SelectedItems, Value & ";")

On your side, you may need to use the following formula:

Concat(CategoriesComboBox.SelectedItems, Value & ";") // Replace the CategoriesComboBox with actual control name within your DetailForm1

Then go to the Gallery screen where you want to list your List2 records, set the Items property of the Gallery to following:

Filter(
       'List 2',
        CategoryColumn.Value in Concat(CategoriesComboBox.SelectedItems, Value & ";")
)

Note: I assume that CategoryColumn in your List 2 is LookUp column, which only support single value option. In other words, one Product Resource record only match single one category value in your SP List2.

If the CategoryColumn in your SP List2 is also a LookUp type column, which enable "Allow Multiple Options", please consider modify above Filter formula as below:

Filter(
       'List 2',
        Concat(CategoryColumn, Value & ";") in Concat(CategoriesComboBox.SelectedItems, Value & ";")
)

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

[enlitzinger]

@v-xida-msft  yes, works great!  I'll accept as solution.  But, curious how I would write the formula if there are 3 search categories all with multi select options.  I assume I would need to add in an AND feature somewhere...but there could also be the possibility that only 2 categories would be submitted, thus category 3 would be blank.   Could you provide a snippet of how that may look or am I just getting crazy with what I;m thinking? 

All 3 categories from the submission list are multi-select, and I'd like the Gallery 2 results to filter based on all 3 category multi-selected values.   

[enlitzinger]

@v-xida-msft are you able to assist with the additional bit of insight?