Switch and using nested IF

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to navigate to a correct form based on Category(lbl_AllRequestsCategory.Text)

Then based upon another variable "Status" decide which form to go to ?

This is not working below

Switch(lbl_AllRequestsCategory.Text
,"NEW PRICING OPPORTUNITY"
,
If(dtbl_AllRequests_NoFilter.Selected.Status = "Submitted" Or dtbl_AllRequests_NoFilter.Selected.Status = "Pending",
Navigate(scrn_PREX_Reserve_NCPricingOrig_PR2)
Or
If(dtbl_AllRequests_NoFilter.Selected.Status = "Completed",
Navigate(scrn_Prex_NCPricingOrig_DeadView_PR2)
Or
If(dtbl_MyRequests_qs.Selected.Status = "Pending - On Hold for Clarification",
Navigate(scrn_PREX_Reserve_NCPricingOrig_PR2)
Or
If(dtbl_MyRequests_qs.Selected.Status = "Pending - Escalation in Progress",
Navigate(scrn_PREX_Reserve_NCPricingOrig_PR2)
Or
If(dtbl_MyRequests_qs.Selected.Status = "Pending - Cost Support Request with Supplier",
Navigate(scrn_PREX_Reserve_NCPricingOrig_PR2)
Or
If(dtbl_MyRequests_qs.Selected.Status = "Rejected",
Navigate(scrn_PrexSeller_RejectedView)
,"")

,""),""),""),""),"")
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Shaheer Ahmad 2,194 Moderator on at

Like (1)

Report
Copy link

Link copied!
Try This:
Switch( lbl_AllRequestsCategory.Text, "NEW PRICING OPPORTUNITY", Switch( dtbl_AllRequests_NoFilter.Selected.Status, "Submitted", Navigate(scrn_PREX_Reserve_NCPricingOrig_PR2), "Pending", Navigate(scrn_PREX_Reserve_NCPricingOrig_PR2), "Completed", Navigate(scrn_Prex_NCPricingOrig_DeadView_PR2) ), "OtherCategory", // Add more categories and form navigations as needed Switch( dtbl_MyRequests_qs.Selected.Status, "Pending - On Hold for Clarification", Navigate(scrn_PREX_Reserve_NCPricingOrig_PR2), "Pending - Escalation in Progress", Navigate(scrn_PREX_Reserve_NCPricingOrig_PR2), "Pending - Cost Support Request with Supplier", Navigate(scrn_PREX_Reserve_NCPricingOrig_PR2), "Rejected", Navigate(scrn_PrexSeller_RejectedView) ), // Default case, you can add more categories as needed "" )

Mark as solution if this solves your issue. Give this reply a thumbs up. Reply to this thread if you need further assistance. Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you so very much...Testing now.

Was this reply helpful? Yes No