cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RussellGove
Kudo Kingpin
Kudo Kingpin

Bug in formula formatting

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
)

 

5 REPLIES 5
rc
Power Apps
Power Apps

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

 

@LanceDelano

Mike8
Solution Sage
Solution Sage

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
Power Apps
Power Apps

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!

Thanks for the quick response!

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:

Capture.PNG

If i  click showResponses ,  it changes it to Capture.PNG

 

If I type out the entire expression :

Capture.PNG

 

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. 

 

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (59,445)