cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RussellGove
Level 10

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
PowerApps Staff rc
PowerApps Staff

Re: Bug in formula formatting

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

 

@LanceDelano

Mike8
Level 10

Re: Bug in formula formatting

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

PowerApps Staff rc
PowerApps Staff

Re: Bug in formula formatting

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!

RussellGove
Level 10

Re: Bug in formula formatting

Thanks for the quick response!

RussellGove
Level 10

Re: Bug in formula formatting

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,399)