Hi @Sheff ,
Do you want to navigate to different screens based on the corresponding Status Column value?
Based on the formula you provided, I think there is something wrong with it. The result the StatusCol.Text formula returns is always blank.
As an alternative solution, please consider take a try with the following workaround:
Please modify your formula as below (I assume that your data source is a SP List😞
If(
DataTable1.Selected.Status.Value = "Needed", /* <-- Status is a Choice type column in your SP list, which used to store the "Needed" value and "Completed" */
Navigate(Screen1),
Navigate(screen2)
)
If your data source is not a SP list, and the Status column is a Text type column, please modify above formula as below:
If(
DataTable1.Selected.Status = "Needed"
Navigate(screen2)
)
Please consider take a try with above solution, then check if the issue is solved.
Best regards,
