cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

if function

Hi All

I need help with this formula

 

If(CategoryLabel = "Expense" or "Transfer" ,Amount.Text)

 

I want that depending on any of that two Rate the result of the amount

Note: I'm not using the Part of the else function, only part true

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Responsive Resident
Responsive Resident

Syntax for Or in powerApps is you need to specify both the left and the right operand each time.  

If(CategoryLabel = "Expense" Or CategoryLabel = "Transfer" ,Amount.Text)

You can find more uses of the the Or() Here.

View solution in original post

2 REPLIES 2
Highlighted
Responsive Resident
Responsive Resident

Syntax for Or in powerApps is you need to specify both the left and the right operand each time.  

If(CategoryLabel = "Expense" Or CategoryLabel = "Transfer" ,Amount.Text)

You can find more uses of the the Or() Here.

View solution in original post

Highlighted
Anonymous
Not applicable

Thanks for your help @samuelJ

 

@Anonymous

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 (11,018)