Send e-mail based on conditions related to sharepoint list's column

(0) Share

Report

Posted on by arseny_sandaar

Hello,

After several attempts to understand how to do it I came here to ask you a hint.

I have several sharepoint lists with the data updated daily. The lists's structure is identical.

I would like to analyze each sharepoint list column, e.g. if the maximum of the column values less then a week of the year, and if the condition is true send e-mail to the user:

IF condition is true THEN send e-mail to the user OTHERWISE do nothing

I was thinking to create parallel scheduled flows for each list, but I couldn't analyze even a column in the flow.

What would you suggest?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @arseny_sandaar

Could you please provide an example of your lists structure and columns with some sample data? Also explain bit more about less than a week of the year? Which column you want to compare against?

Was this reply helpful? Yes No

arseny_sandaar

12 on at

Like (0)

Report

Hi @abm

My sharepoint lists consists of several columns. The number of rows (in other wordsentries, items in the list) is increasing daily.

One of the columns I am interested in consists of integers. Integers show on what week of the year the row (entry, item) appeared in the list.

For example, let's assume 1 Jan is Monday and 7 Jan is Sunday, then week 1 is from Jan 1 to Jan 7; week 2 - from Jan 8 to Jan 14; week 3 - Jan 15 to Jan 21; and so on. In one year we have 52 weeks +1/2 days. This week is 44th.

Structure of my list:

col 1	col 2	week number	col 4	...	col N
some data	some data	41	some data	some data	some data
some data	some data	43	some data	some data	some data
some data	some data	44	some data	some data	some data
some data	some data	44	some data	some data	some data

I should compare in the flow the following thing for the above example:

IF max(41,43,44,44) < current week (which is 44) THEN send e-mail OTHERWISE do nothing

in 70% of the time there is no row with week N for the current week.

Was this reply helpful? Yes No

v-chenzhi on at

Like (0)

Report
Hi @arseny_sandaar ,

Do you want to Send e-mail based on conditions related to SharePoint list's column?
Could you please explain bit more about less than a week of the year?
I assume 1 Jan is Monday and you have a column named Week number in SharePoint.
I have a test for your reference, please try following workaround.
Here is the expression1:

int(outputs('Compose'))

Here is the expression2:

add(div(dayOfYear(utcNow()),7),1)

It will send email when Week number is greater than current week.

Best Regards,
Zhi Chen

Was this reply helpful? Yes No
Verified answer

v-chenzhi on at

Like (0)

Report

Hi @arseny_sandaar ,

Has your problem been solved?

If you need help, please feel free to contact me.

Best Regards,

Zhi Chen

Was this reply helpful? Yes No
arseny_sandaar 12 on at

Like (0)

Report
Hello,

thanks for the response, though the suggested solution compares each entry with the
add(div(dayOfYear(utcNow()),7),1)
instead I would like to compare the expression2 with the maximum of the column of SP list.
I see that the flow compares each entry with the week number by applying the logic to each entry.

Is it possible to:
1. get SP list
2. choose specific column of the list
3. find a maximum of the column items
4. compare the maximum with the week number (which can be identified as you proposed)

Was this reply helpful? Yes No