How to make this logic in IF statement work

(0) Share

Report

Posted on by TelmoERF96

170

Hello everyone,

This is more of a logic question instead of a PAD question but I have been trying and am not being able to make this work.

I have two different types of dates that are stored as text, the dates either look like this

"14-16 June 2022"

"11-12 May 2022"

Or they look like this

"25 January-16 April 2022"

"15 September-17 July 2020"

The dates are written in different formats so they require different manipulation to turn them into the desired format, I already have the actions I want to make on each set of dates. What I am not being able to do is write the correct IF condition to differentiate between the type of date passed from the two above.

If anyone could help that would be really great.

Thanks in advance everyone

Telmo Ferreira

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I think
first split the above dates using -
for
"14-16 June 2022"
"11-12 May 2022"
use regex and separate month and year then join with the date 14 and 11
25 January-16 April 2022"
"15 September-17 July 2020"
for the above the dates also split with - and take year separately and join again

Was this reply helpful? Yes No
TelmoERF96 170 on at

Like
a
(0)

Report
Copy link

Link copied!

I already have that logic working, maybe I didn't make myself clear I am sorry.
I want someone to help me write the IF statement so when I pass it the date, the logic of the if checks if it is the first type of date or the second one.

Was this reply helpful? Yes No
UshaJyothiKasibhotla 225 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hope this helps
Usha

Was this reply helpful? Yes No
Verified answer

Agnius Bartninkas Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
There are essentially a few ways in which you can do this:

You can just try to convert it via one approach and then have error handling in place to attempt the other approach if the first one fails.

You can also use Parse text with regex to check for \d+-\d+. This will return a match for the dates that are formatted as "14-16 June 2022". If the match is not empty, you know you need to use the approach for this format. If it is empty, you use the other approach.

You can also check the length of the string, but this might be risky with the varying lengths of the month names.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
TelmoERF96 170 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you Agnius,

I made it work with your second option. I used Parse Text on whatever type of date I had to check not exactly for what you said but instead for \d+[a-zA-z]-\d+ to look specifically for the second type of date I showed.
And then used an IF to check if the variable created by the Parse Text action was empty to run the process I had created previously.

Thank you once again for your help

Telmo Ferreira

Was this reply helpful? Yes No