Power Automate Function with multiple cases

(2) Share

Report

Posted on by IK-09041829-0

I have a Power Automate use case where incoming emails are assigned a category based on the from, name of and # of attachments, and certain keywords in the email body/subject. I would like to store all the categorization logic in a single action/expression. The action would have its output a single string category value. For example, something like below (this would work in Power BI/DAX). There can be potentially hundreds of categories, each with their own unique logic . Is something like this possible? Or would I need to nest an insane amount of ifelse calls?

    SWITCH(TRUE,
or(and(contains(body,'abc'),contains(subject,'def')),hasattachment=True),
"Category 1",
and(contains(body,'def'),contains(subject,'def')),
"Category 2",
"Unknown"
)

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @IK-09041829-0

Yes, you can there is a switch statement in power apps but that is in the App side.

In Power Automate there is a Case Statement.. but it doesn't work exactly like what you want.

That being said, you absolutely could build a compound If statement that would give you want you want.

So yes, it's possible, fun... no. possibly yes.

If this answers your question I'd be grateful if you marked it as such and maybe a like :-)

Cheers

Was this reply helpful? Yes No
Suggested answer

ronaldwalcott 3,862 Moderator on at

Like (0)

Report
Copy link

Link copied!

Create a table in SharePoint or Dataverse with columns containing the configuration that you are checking for and the necessary values to facilitate any instructions.

You would just lookup the values in the table (if the category is set based on from, name and number of attachments) or loop through the table (if the category is set on checking things like the body contains 'abc' and the subject contains 'def').

No need to create a complex If statement.

Was this reply helpful? Yes No
Michael E. Gernaey 53,969 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hii@ronaldwalcott

Please share an example so they can do it so they can mimic it. They gave an example of exactly what they need so share an example please so they can get it going :)

Was this reply helpful? Yes No