PowerBIIntegration alternatives for First()?

Hi All,

I have writeback PowerApp integrated into a PowerBI report and in my PowerApp there is a gallery that is connected to a SharePoint. In my Power BI report, the user can control-select options within slicers (Company Code and Company Category) to select multiple values within that slicer - this information is being passed to my Power App.

Then in my gallery, I am filtering my SharePoint list based on the selected filters in Power BI. This is what I have in the Items section:

Filter('My List', 'Company Code' = First(PowerBIIntegration.Data).'Company Code' && 'Company Category' = First(PowerBIIntegration.Data).'Company Category'

The issue that I am having is that even if I multi-select different Company Codes or Company Categories in Power BI, it only filters the first item within each slicer in my gallery (which makes sense since I am using a First() function). How do I modify this so that I can see all of the selected filters instead of just the first one?

Categories:

Using Apps Using Formulas

General Questions