Hi all,
I have a Dataverse table called 'Task Forces.' There is another table called 'Assets,' which contain assets to be assigned to task forces. The 'Assets' table has a lookup column relating to the 'Task Force' table, so that each asset can be assigned to only one 'Task Force.' This column is called 'TFA,' for 'Task Force Assignment.'
Within Power Apps, I have a Gallery that displays data from the 'Task Forces' table. This gallery has a ComboBox where I have listed assets from the 'Assets' table. I would like the ComboBox to have DefaultSelectedItems that is a Filtered list from 'Assets' where the 'TAF' (Task Force Assignment) column value matches ThisItem or ThisItem.Name, so that each ComboBox in the gallery has appropriately pre-selected assets that have been already been assigned to each individual task force.
I would believe the answer would be as simple as Filter(Assets, TFA in ThisItem.Name), or a similar variant (= instead of in, ThisItem instead of ThisItem.Name, etc.), but I haven't been able to figure out how to filter based on ThisItem matching the lookup field contents no matter what I do.
Thank you for your help. I've really been struggling with this one.
Edit: Corrected where I referenced the wrong table in my code example.


Report
All responses (
Answers (