Hello Power Apps Community,
Can you help please... and I hope I can explain this correctly...
I am building a canvas app, using Dataverse for Teams.
I have two tables: "Employee" which is the parent table, and "Transaction" which is the child table.
So one "Employee" record to many "Transaction" records.
I have an Employee screen with a gallery showing all the Employee records.
I have two icons for each record, the icons are called "Open" and "Closed".
When I click the "Open" icon or the "Closed" icon, on the relevant "OnSelect" property, it takes me to another screen (Transaction) with another gallery for the child table: Transaction.
The expression is this:
Navigate(
ScreenEmployeeTransaction,
ScreenTransition.None,
{lclThisEmployee: galEmployeeSearch.Selected}
)
When I land on the child screen and gallery (Transaction) I want to see all related Transaction records of the parent (Employee) record I selected in the previous screen.
So on the gallery I filtered the Transaction "Items" property with the below expression:
Filter(
Transactions,
'Employee Name'.'Employee' = lclThisEmployee.'Employee'
)
Again, this is working great. So if I select John Smith on the Employee gallery I move to the Transaction screen and gallery and just see John Smith's Transactions.
My request: After all that, what I'm now looking to do is:
1. If on the Employee screen, image at the top, I click on "Open" then when I navigate to the Transaction screen and gallery I only want to see John's Smith's Transactions with the Status Reason of "Active".
2. If on the Employee screen, image at the top, I click on "Closed" then when I navigate to the Transaction screen and gallery I only want to see John's Smith's Transactions with the Status Reason of "Inactive".
Any thoughts would be greatly appreciated.
Garry
PS. Model-driven apps for Dataverse for Teams cannot come quick enough for me. Can't wait to leave these canvas apps behind! Haha.
