Hi @AkshayManke ,
If you're using a Form, consider applying the below to the Default property of the Owner DataCard (not the DataCard Value)
If(
'Your Form'.Mode = FormMode.New,
LookUp(
Approvers,
Goal.Value = DataCardValue1.Selected.Value, //DataCardValue1 is your Goal dropdown
Owner
),
ThisItem.Owner
)
If you're not using a Form, ensure you have the following in the Items property of your Dropdown control:
Choices([@Approvers].Owner)
Then apply the below to the Default property of your Dropdown, or DefaultSelectedItems property if you're using a Combo Box control:
LookUp(
Approvers,
Goal.Value = 'Your Goal Dropdown'.Selected.Value,
Owner
)
------------------------------------------------------------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.
If you like my response, please give it a Thumbs Up.
Imran-Ami Khan
