Answered

Approval flow based on number of selected dates in a particular month

(0) Share

Report

Posted on by ElectroWiz

Hi,
I am new to Power Automate. I have a multiline Of text column in a sharepoint list which stores dates(Converted to strings) in this format "09/03/2023; 23/03/2023; 30/03/2023". I want to setup a condition which will route the flow to a different approver if more than 3 dates in a particular calendar month is contained in the multi line of text column.

Example

14/03/2023; 17/03/2023; 21/03/2023; 28/03/2023; 04/04/2023; 11/04/2023; 18/05/2023

The dates above are values of the multiline column, since the dates in March are more than 3, I want my flow to take a different approval route. How do I achieve this please?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @ElectroWiz ,

I have made a flow for your reference:

Related expressions:

split(outputs('Compose'),'; ')
int(formatDateTime(parseDateTime(items('Apply_to_each'),'de-DE','dd/MM/yyyy'),'MMyyyy'))
union(variables('Months'),variables('Months'))
@equals(item(), items('Apply_to_each_2'))
length(body('Filter_array'))

The logic is:

1. Get MMyyyy format month values from those dates.

2. Use union to get the distinguish values from the Months array, filter months by each value.

3. Count the rows of duplicate values in months array and if it's more than 3, there are more than 3 same month values and do what you want in true branch, otherwise in false branch.

Best regards,

Was this reply helpful? Yes No
ElectroWiz 25 on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni Thank you so much it works but i forgot to mention that occassionaly, that column would have to be blank so i got this error when i tried testing that option
How do i handle this please?

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @ElectroWiz ,

In that case you can use a Condition control to check the column value first, if it isn't blank actions are all mentioned, but when it's blank do something else.

Best regards,

Was this reply helpful? Yes No