Power Platform Community Forum Thread Details

I'm not sure where to begin on this one. I have an Entity "Opportunity Status," which populates a lookup field within a second entity, "Projects." The records from "Projects" are displayed in a form, i.e. that lookup field displays as a Combo Box within its Data Card.

Is there a way to have an action triggered when the user navigates from the 2nd to the 3rd opportunity status, but not otherwise (there are 7 options)? I'm guessing the OnChange property would be where I began, but how would I trigger the action only on the change 2 -> 3?

Here's the "Opportunity Status" records for reference:

Forecasting	order
Lead	1
Estimating	2
Auditing/Budget	3
Certifying	4
Delivered	5
Sold	6
Closed	7

Categories:

Building Power Apps

Hi @Madumi ,

Could you please share a bit more about your scenario?

Do you want to trigger a action from your "Opportunity Status" ComboBox only when the Status value is changed from "Estimating" to "Auditing/Budget"?

Based on the needs that you mentioned, I think the OnSelect property and OnChange property of the ComboBox could achieve your needs.

I have made a test on my side, please consider take a try with the following workaround:

Set the OnSelect property of the "Opportunity Status" ComboBox to following:

Set(PreviousValue, ComboBox1.Selected.Value)

Set the OnChange property of the "Opportunity Status" ComboBox to following:

Set(CurrentValue, ComboBox1.Selected.Value);
If(
 PreviousValue = "Estimating" && CurrentValue = "Auditing/Budget", // Check if the value is changed from Order 2 to Order 3
 "Do the action here ...."
)

Please consider take a try with the above solution, check if the issue is solved.

Best regards,