Answered

Need a conditional "LIKE" formula

(1) Share

Report

Posted on by ChrisDMU

Hi, I hava a flow that scrapes my outlook calendar for bookings (made via MS Bookings) and returns the Service name as part of a populated export csv.

The Service names are:

America
Europe
Africa

For some reason, Outlook has changed the structure of itself and now instead of Service returning "Africa", it will return "Africa - Mr A Aaronson" (the name of the person who the meeting is with).

The formula I use to populate that field in my csv is:

"Service": "@{item()?['subject']}"

Is it possible to make this a simple LIKE formula... something along the lines of..

"Service": "@{item()? if(['subject'] like "America" then "America" else if(['subject'] like "Europe" then "Europe" else if(['subject'] like "Africa" then "Africa" else ""}"

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ChrisDMU

Try the below

Expression I used above is: first(split(outputs('Compose'),' - '))

Thanks

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @ChrisDMU ,

Please try the expression:

if(contains(item()?['subject'],'America'),'America', if(contains(item()?['subject'],'Europe'),'Europe', if(contains(item()?['subject'],'Africa'),'Africa','')))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
ChrisDMU 26 on at

Like (1)

Report
Copy link

Link copied!

Works beautifully (NB, there is a comma missing after 'Europe' )

Was this reply helpful? Yes No
v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @ChrisDMU ，

Thanks for reminding me that I've finished revising.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No