How to use if the number = X then replace it with a string in Power Automate?

[Frank67]

This sounds like an easy question but my actual question is more complicated.

Let's say I extracted a number from the email. I already have a running flow that extracts information from email's body and subject and emails to the person as processed document. The question is let's say the order category is '2' and that corresponds to appliances. Here is a list with people in charge:

1-Toys -Mark and Jason

2-Appliances -Alex and Sophia

3-Grocery -Ali and Josh

4-Tires -John and Doe

5-Plants -Mark and Rick

So if I extract 2 from the email I want to pass this information to the user as 'Appliances' instead of 2.  Additionally I want to pass who is in charge, for example Alex and Sophia, just using the '2' extracted from the email.

I tried with condition statement, I could use equal to or not equal to but then I have to compare number 2 with all 1,2,3,4,5 and then say if yes do what I asked but if no go compare again.

These categories are saved in shared excel file, in drive/ cloud.

I thought about switch case statement but I could not see any examples.

This is just an example, the original project I am trying to apply this logic has 40 different categories, otherwise I would not mind comparing 5 numbers.

Thanks in advance!

[Matthy79 · Accepted solution]

You could create an object on top of your flow.

{
  "1": {
    "name": "Toys",
    "user": "Mark and Jason"
  },
  "2": {
    "name": "Appliances",
    "user": "Alex and Sophia"
  },
  "3": {
    "name": "Grocery",
    "user": "Ali and Josh"
  },
  "4": {
    "name": "Tires",
    "user": "John and Doe"
  },
  "5": {
    "name": "Plants",
    "user": "Mark and Rick"
  }
}

And after that you simple reference to it.

Output for category 2:
name: @{outputs('Compose_object')['2']['name']}
user: @{outputs('Compose_object')['2']['user']}

Of course instead of 2 you have to use your variable.

[Frank67]

Not directly related to this topic but do you know how could I solve this problem?:

The subject of the email I receive is being analyzed by my flow to give the user office number info. I want to pass the first number(26 in this case) as office number and second one(349 in this case) as room number to the user. I already have a running flow. It searches for new order keyword in subject and analyzes the info. What I could not figure out is sometimes the email we receive has slash(/) in office number area. My flow is running to split from slash/ but when another user emails us without slash and just uses space( ) instead flow fails. How can I generalize this?

Thanks in advance!

sample 1:

New Order - Accountt 01313120771472 Office 26 349

sample 2:

New Order - Accountt 01313120771472 Office 26/349

[Matthy79]

Hello,

you could replace alle / with “ “ and do your split on space or the other way around.

[Frank67]

Well I tried that. But for some reason it did not work.

Also I forgot to edit the question above but sample 1 does not use (:) after office while sample 2 uses it.

sample 1:

New Order - Accountt 01313120771472 Office 26 349 [internal]

sample 2:

New Order - Accountt 01313120771472 Office: 26/349

What I currently have is:

trim(split(split(triggerOutputs()?['body/subject'],'Office')[1],'')[0])

The output:

26 349 [internal]

This works but gives me everything after Office in this case the output is 26 439 [internal] but I would like to get 26 only and get the 439 in next step.

[Matthy79]

split(trim(replace(replace(last(split(SUBJECT, 'Office')), ':', ''), '/', ' ')), ' ')

After that:

outputs('Compose_split')[0]

outputs('Compose_split')[1]

[Frank67]

That worked. Thank you!