Dataverse Indirect relationship help, Collect, filter

[michaelpaul]

Hi All,

I am looking for a bit of help to get past a stuck point. I am building an asset tracking app to track assets on projects. I have 3 tables that I am working with:

• Project
  • Name
  • Number
• Equipment
  • Unit Number
  • Make
  • Model
  • etc
• Unit Project
  • Unit Number (lookup Equipment)
  • Project (Lookup Project)
  • Start Date
  • End Date

The issue that I'm running into is I want to be able to show all the units in the master (preferably in a data table but for now I can only get it to work in a gallery), show the current (active) project for the unit, and optionally filter those units by the current project based on a dropdown. Currently I can add the current active project into a gallery with:

First(Filter(ThisItem.'Equipment Projects',Status = 'Status (Equipment Projects)'.Active)).Project.'Project Number'

I am trying to sort the gallery based on a dropdown that pulls the items from the project table. I have tried several different things and I just can't seem to get it to filter. Any ideas or solutions would be greatly appreciated. 

Thanks

[Daniel_A]

Hello @michaelpaul ,

Could you please state where, what control, the above function is used?

Please include an exampel of the expected outcome in a table format. It's very hard to understand your requierment whithout it. What are the Units? What are the Master? Do you have a master Project. 

I can help you with this given a bit more background 🙂.

Thanks

[Daniel_A]

Hello @michaelpaul ,

Could you please state where, what control, the above function is used?

Please include an example of the expected outcome in a table format. It's very hard to understand your requirement without it. What are the Units? What are the Master? Do you have a master Project. 

I can help you with this given a bit more background 🙂.

Thanks