Bug in formula formatting

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi ,

There is a bug in the formula formatting

if i have this in my formula

If(
UseBudget And ThisItem.ProductionValue/ThisItem.BudgetValue * 100-100 < (-100),
-100, (etc.)

and click format text, it turns it into

If(
UseBudget And ThisItem.ProductionValue/ThisItem.BudgetValue * 100-100-100,
-100, (etc.)

complete formula is

If(
UseBudget And ThisItem.ProductionValue/ThisItem.BudgetValue * 100-100 < (-100),
-100,
UseBudget And ThisItem.ProductionValue/ThisItem.BudgetValue * 100-100 > 200,
200,
UseBudget,
ThisItem.ProductionValue/ThisItem.BudgetValue * 100-100,
!UseBudget And ThisItem.ProductionValue/ThisItem.ForecastValue * 100-100 < -100,
-100,
!UseBudget And ThisItem.ProductionValue/ThisItem.ForecastValue * 100-100 > 200,
200,
ThisItem.ProductionValue/ThisItem.ForecastValue * 100-100
)

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

rc Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for reporting Russell, we'll jump on it.

+ @LanceDelano
Mike8 1,330 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Also the following expression
Concat(GroupedBy,AttributeFullPath,Concat(GroupedBy[@Properties],"A"))

after pressing format text, returns
Concat(
GroupedBy,
AttributeFullPath,
Concat(
GroupedBy[@[@Properties],
"A"
)
)

It adds this ---> [@ before the [@Properties]
Thank you
rc Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Update: we already have a fix in the pipleine to this formatting issue, it is working its way to production as we speak. Thanks again for reporting!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick response!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I think I found another. I have a boolean in my context called showResponses.

I am trying to set the AutoHeight property to be !showResponses.

When I try to set that in the editor as shown below:
If i click showResponses , it changes it to

If I type out the entire expression :

It takes it, and issues no warnings, but the autoheight is always on when I run the app , regardeless of whether showresponses is true or false.

All the controls are in a flexible height gallery.