I have a PowerApp that submits items to a SharePoint list (Let's call it ListA), I have a dropdown in the app ('FieldA1Dropdown') where the available selections need to come the 'MyItemNames' column from another SharePoint list (ListB), but I only want to see the items from ListB whose values in two other columns in match my conditions. Specifically I only want to show the MyItemNames from ListB that are both active and transferrable.
I'm having a heck of a time sorting it out.
So the FieldA1Dropdown.Items property needs to be something like:
Filter(ListB.MyItemNames, ListB.Active.Value="Y", ListB.Transferrable.Value="Y")
But of course, this doesn't work.
I've already tried pulling in ListB's MyItems column by configuring FieldA1 as a Lookup field in Sharepoint, but you can't filter items based on other columns like I need to here.
Sidenote: Both ListA and ListB are already set up as data sources in this PowerApp.
Please advise.