Formula error

[dobroo]

Hi @ALL,

can someone explain to me where the error lies in this formula:

With({_longText:"bigText: iurhfuishdiughsudhgiufhsuhfughufdhgusdhgiufdhughugfhsguhsiu"};
If(_varBool;
    //True Functions
    Set(_VisibleVARBool; false );;
    ClearCollect(colLoopMaster;{Index:0})
    
    ;

    // Otherwise Function
    Set(_shortText;_longText)
    )
)

I thought it is possible that you can normally use ";;" for several true functions in an if()-Function.

[Drrickryp]

Hi @dobroo 

If() will operate on the conditions until it finds the first true condition and then stops and executes the remaining functions.  To get it to consider two conditions simultaneously, you will need to use an "or" or "and" operator depending on whether both conditions are true or one of the two are true.

[timl · Accepted solution]

Hi @dobroo 

It's possible that Power Apps expects a consistent return value from both the true and false branches of the if statement.

Therefore, if you reverse the function calls in your true branch so that ClearCollect comes first, does the error go away?

With({_longText:"bigText: iurhfuishdiughsudhgiufhsuhfughufdhgusdhgiufdhughugfhsguhsiu"};
If(_varBool;
    //True Functions
    ClearCollect(colLoopMaster;{Index:0});;
    Set(_VisibleVARBool; false )
    ;
    // Otherwise Function
    Set(_shortText;_longText)
    )
)

[dobroo]

this is really irritating, i swap the function and it works