News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows About Filter Odata

Power Automate - Building Flows

Unanswered

About Filter Odata

Like (0) Share

Report

Report

Posted on 4 Sep 2020 17:24:23 by Community Power Pla...

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.

All responses Img

All responses (1)

Answers Img

Answers (0)

rimatos on 09 Sep 2020 at 16:04:51

Like (0)

Report

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

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,722 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 66,067 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans