web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Agent Academy Hackathon is happening now!
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / I need make a OR funct...
Power Apps
Unanswered

I need make a OR function on this formula....

(0) ShareShare
ReportReport
Posted on by Gorilla_8

I need to add a funciton "or", can someone help me out?

 

If(Checkbox_MaiorPorcentagem_1.Value= true ;Sort(collTaskListForGallery;TrabalhoPercentualdaTarefaConcluído;Descending);If(Checkbox_MenorPorcentagem_1.Value= true ;Sort(collTaskListForGallery;TrabalhoPercentualdaTarefaConcluído;Ascending);If(Checkbox_Ordemdemanutenção.Value=true;Sort(collTaskListForGallery;OrdemdeManutenção;Descending);If(CheckboOrdemdemanutençãomenor.Value=true;Sort(collTaskListForGallery;OrdemdeManutenção;Ascending);If(toggle_porcentagem.Value= true ;Filter(collTaskListForGallery;TrabalhoPercentualdaTarefaConcluído<100);If(toggle_porcentagem.Value= false ;collTaskListForGallery))))))
Categories:
Building Power Apps
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 155,463 Most Valuable Professional on at

    Hi @Gorilla_8 ,

    Where to you want to put the Or and can you please use Format Text on the code and re-post it.

  • Gorilla_8 Profile Picture
    Gorilla_8 on at 
    If(
 Checkbox_MaiorPorcentagem_1.Value = true;
 Sort(
 collTaskListForGallery;
 TrabalhoPercentualdaTarefaConcluído;
 Descending
 ); (here if is possible)
 If(
 Checkbox_MenorPorcentagem_1.Value = true;
 Sort(
 collTaskListForGallery;
 TrabalhoPercentualdaTarefaConcluído;
 Ascending
 ); (here if is possible)
 If(
 Checkbox_Ordemdemanutenção.Value = true;
 Sort(
 collTaskListForGallery;
 OrdemdeManutenção;
 Descending
 ); (here if is possible)
 If(
 CheckboOrdemdemanutençãomenor.Value = true;
 Sort(
 collTaskListForGallery;
 OrdemdeManutenção;
 Ascending
 ); (here if is possible)
 If(
 toggle_porcentagem.Value = true;
 Filter(
 collTaskListForGallery;
 TrabalhoPercentualdaTarefaConcluído < 100
 ); (here if is possible)
 If(
 toggle_porcentagem.Value = false;
 collTaskListForGallery
 )
 )
 )
 )
 )
)
  • WarrenBelz Profile Picture
    WarrenBelz 155,463 Most Valuable Professional on at

    Thanks @Gorilla_8 ,

    What is the Or function you want to put in?

  • Gorilla_8 Profile Picture
    Gorilla_8 on at

    This "||" or "OR", I just need to execute many filter all the time, or one one by time, or two, three...

  • WarrenBelz Profile Picture
    WarrenBelz 155,463 Most Valuable Professional on at

    Sorry @Gorilla_8 , I will be more specific. 
    Is the an alternate filter or an alternate value on the checkbox or something else?

    This will determine where the code needs to go.

    Can you please supply an example of code you want to put in.

  • Gorilla_8 Profile Picture
    Gorilla_8 on at

    No, isnt....

    this are the filters

     

     

    filteres.png

  • WarrenBelz Profile Picture
    WarrenBelz 155,463 Most Valuable Professional on at

    Ok @Gorilla_8 ,

    I am trying to help you with code can you please give me an example of the Or code you want to use - that way I can show you where and how it fits. As an example - it you are looking for two different possibilities on control values

    If(
 Checkbox_MaiorPorcentagem_1.Value = true ||
 SomeOtherControlValue = whatever;
 Sort(
 collTaskListForGallery;
 TrabalhoPercentualdaTarefaConcluído;
 Descending
 )

    If you are asking about Sort alternatives, you can do an If / Else alternative

    If(
 Checkbox_MaiorPorcentagem_1.Value = true
 Sort(
 collTaskListForGallery;
 TrabalhoPercentualdaTarefaConcluído;
 Descending
 );
 Sort(
 collTaskListForGallery;
 SomeOtherField
 Descending/Ascending
 )

    but you cannot make an Or on Sort as it is a result, not a condition to get the result.

    Is this what you are asking?

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

  • WarrenBelz Profile Picture
    WarrenBelz 155,463 Most Valuable Professional on at

    Hi @Gorilla_8 ,

    Thanks for the kudo

    Are you saying this solved your issue, if so, please consider Accepting as Solution.

    If not, so you have more questions?

  • Gorilla_8 Profile Picture
    Gorilla_8 on at

    I appreciate it your help, but didn't work out! 😞

     

    However, I am trying figure out here...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Agent Academy Hackathon is happening now!
Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 610

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans