cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Power Apps
Power Apps

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

 

@LanceDelano

Highlighted
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

Highlighted

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!

Highlighted

Thanks for the quick response!

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,769)