Filtering Gallery or Data Table

[dee6166]

I am creating a PowerApp in my list called 'Inventory'. I want to display a data table or gallery with items from another list called 'Results'. I want that gallery or data table to automatically filter based on a value of the actual item you are viewing from the Inventory list. I do not want a search bar or drop down menu. I just want my data table or gallery to display items from Results where the 'Activity ID' (Results) equals the 'Activity ID' (Inventory). Is this possible? 

[timl]

@dee6166 

Yes, you can do this by calling the filter function.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-filter-lookup

To show the results that are related to the selected item in an inventory gallery, you would set items property of your results gallery using syntax that looks like this:

Filter(
  Results,
  ActivityID=galleryInventory.Selected.ActivityID
)

[dee6166]

@timl This did not work for me. I get an error within the formula. When I am in PowerApps it does not show my column labeled Activity ID it shows it as title. Is that why?

[v-qiaqi-msft]

Hi @dee6166,

Could you please tell me that if you have a gallery populated with Inventory and another gallery to display Results items  based on the item you selected from the inventory gallery?

If so, I think @timl has provided the correct solution.

Here is the scenario where you could use this formula, you have a Gallery named galleryInventory populated with Inventory list, and both of your Inventory list  and Results list share the same column 'Activity ID'.

Check your control name and replace it with the real one in your scenario.

[dee6166]

Hi @v-qiaqi-msft I only have 1 gallery for results. My goal is for the user to to use the inventory list and when they click on a specific item to view within that list - it displays the results gallery. Do I need two galleries? I don't want my user to have to search or select. 

[v-qiaqi-msft]

Hi @dee6166,

Sorry for late reply.

You mean you just want to populate the result Gallery with the items sharing the same 'Activity ID' with the Inventory list, right?

If so, I think you could directly set the result gallery Items as below:

Filter(Result,'Activity ID'=Inventory.'Activity ID')

Then you could get the items with the same 'Activity ID' in the Inventory list.

[dee6166]

@v-qiaqi-msft Hi there, I tried this and still getting a formula error. It says the Activity ID isn't recognized. I tried replacing with Title and got the same error... any more ideas?