Skip to main content

Notifications

Community site session details

Community site session details

Session Id : lqrzKTjTdt5u+7CMvtBPnd
Power Automate - Building Flows
Unanswered

About Filter Odata

Like (0) ShareShare
ReportReport
Posted on 4 Sep 2020 17:24:23 by

Hi Community.!!

 

Could you help me with the next?

 

I am receving an parameter, and the same can have 3 option

  • empty
  • single value for example = Buyer
  • Multiple values. Here each value is delimeted by coma. Example = Buyer, Approver, Basic User

 

After to receive the information I need to filter on Data Common shape.

As you now at the moment i am filtering by one field called proc_cai eq "" but i want to know if I cant create a "IF FUNCTION" similitar this:

 

  • Case Empty = proc_cai eq ""
  • One value = proc cai eq "" and proc_type eq parameter
  • Multiples Values = proc cai eq "" and parameter in proc_type

 

Its possible ? Case No, could you help me with this? I dont want to create if condition for each one.

 

 

ivpd_0-1599239792844.png

 

  • rimatos Profile Picture
    on 09 Sep 2020 at 16:04:51
    Re: About Filter Odata

    Hi @Anonymous ,

     

    If you want to filter in Power Automate using conditions, you can put your expressions by following this guide here.

     

    If the intent is to use this in the ODATA field of the CDS action it should work as well as ODATA filtering supports the usage of logical expressions such as "or", "and"..

    Let me know if this helps!

     

    Regards,

    Ricardo

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

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 179 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 161 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 149

Overall leaderboard