Unanswered

Form Default Mode - Nested Ifs not working

(0) Share

Report

Posted on by mjackson122

I have a dynamic link in an email to open a Powerapps form. Based on the status field in SP when the dynamic link is used Powerapps should see the status field is "X" open the form in "Y" mode. It works if I have a simple formula like:

If(!IsBlank(variableIDforDeepLink), FormMode.Edit,FormMode.New)But this does not address my need

But this is what I need to work:

If(!IsBlank(variableIDforDeepLink) && status.text= "Need More Info" || status.text="Pending" && !IsBlank(office),FormMode.Edit, If(status.text="Approved" || status.text="Rejected",FormMode.View,FormMode.New))

When I use the complicated logic it keeps showing a new form when I open the link even though it should be opening in other modes.

P.S. I also tried using the Switch functionality

Switch(Status.Text,"Need More Info",FormMode.Edit,"Approved",FormMode.View,etc.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@mjackson122

You need to use parentheses to distinguish the priority of your AND's and OR's.

For example, is it !IsBlank(variableIDforDeepLink) && status.text= "Need More Info" that needs to be evaluated to true or false and then OR'ed with status.text="Pending" or is it status.text= "Need More Info" || status.text="Pending" that needs to be evaluated to true or false and then AND'ed with !IsBlank(variableIDforDeepLink)?

PowerApps is just going to guess...and it will be wrong!

So, since I am not able to decipher it either, I will guess as well and suggest the following formula:

If( !IsBlank(variableIDforDeepLink) && (status.text= "Need More Info" || status.text="Pending") && !IsBlank(office), FormMode.Edit, status.text="Approved" || status.text="Rejected", FormMode.View, FormMode.New )

I hope this is helpful for you.

Was this reply helpful? Yes No
mjackson122 on at

Like (0)

Report
Copy link

Link copied!

It is IsBlank(variableIDforDeepLink) needs to be true AND then status.text= "Need More Info" || status.text="Pending" AND !Isblank(office) that needs to be evaluated to true. The pending and office go together and both need to be true for the form to be in edit mode

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@mjackson122

Yes, so put parens around the priorities of your logic.

If I am reading what you are saying right, then it would be:

If( !IsBlank(variableIDforDeepLink) && (status.text= "Need More Info" || (status.text="Pending" && !IsBlank(office)), FormMode.Edit, status.text="Approved" || status.text="Rejected", FormMode.View, FormMode.New )

Was this reply helpful? Yes No