Hi;
We started using more of Microsoft 365 capability like Power Automate and Power Apps in our small office. At some point it was decided that we create a small form in Power Apps so that when a salesperson has a new request from a client, they have to fill out a form so that recruiting/accounting know all the details they need to proceed, rather than a back-and-forth email chain. The info gets saved on a MS List.
As part of that process, I created cascading dropdowns using a separate MS List (called “Client-Contract”), so that one the salesperson chooses a Client, they then need to select a Contract, but the dropdown options only bring up contracts related to that specific client.
I have zero programming knowledge outside of using Power Apps for the last month so I think I made a mistake somewhere and I’m too clueless to figure it out. The issue is that if you try to edit an existing entry, the dropdown menu resets instead of keeping the client and contract previously selected when it was originally made.
I’ve included some key aspects of the data cards and the Drop Down inputs below. Any help would be appreciated.
Client Data Card
Default: ThisItem.Client
Update:
{
Value: DD_Client.Selected.Result
}
DD_Client
Default: Parent.Default
Items: Distinct('Client-Contract', Client)
Associated Contract Data Card
Default: ThisItem.Associated Contract
Update: DD_Contract.SelectedText.Value
DD_Contract
Default: Parent.Default
Items: Filter('Client-Contract', Client = DD_Client.Selected.Result)
