Exctract two Dates from email body

(0) Share

Report

Posted on by FlorianWagner

Hi all!

i receive a mail with the following Body:

firstname lastname Ihr Antrag 'Urlaub': 09.07.2021 bis 09.07.2021 wurde genehmigt.

It's the information that my vacation was approved.

I try to extract the first and secound date out of the text to create an event (to block my calendar) but something is not working...

I split the string after "'Urlaub':" so i receive "09.07.2021 bis 09.07.2021 wurde genehmigt." as an output.

Afterwards i want to split again at " bis " but it says:

Unable to process template language expressions in action 'Compose_3' inputs at line '0' and column '0': 'The template language function 'split' expects its first parameter to be of type string. The provided value is of type 'Array'. Please see https://aka.ms/logicexpressions#split for usage details.'.

I do not find the solution to this... may somebody give me a hint? 🙂

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FlorianWagner,

Can you try and use this expression:

split(split(split(outputs('Compose'), '''Urlaub'': ')[1], ' wurde genehmigt')[0], ' bis ')
Verified answer

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FlorianWagner,

Probably a cleaner approach would be to just split on bis and use skip and take functions. Assuming that the date is always in 10 character format (dd.MM.yyyy) 😁

First date

skip(split(outputs('Compose'), ' bis ')[0], sub(length(split(outputs('Compose'), ' bis ')[0]),11))

Second date

take(split(outputs('Compose'), ' bis ')[1], 10)
FlorianWagner 4 on at

Like
a
(0)

Report
Copy link

Link copied!

This Works!
Thank you a lot!