cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Moosh
Regular Visitor

Periodic validation

Note I speak french, So I try to be clear in english.


I have a lot of list in Sharepoint List.
In these lists, I've a always a column "person" as "owner of the line".

I want to send a periodic reminder to each owner with something like 
"Please, can you check (approbation) the data of these lines where you're identified as responsible for data"

The most basic algo is "if [last_validation] + 6 months < now" => need to be revalidated.

I want to learn to use Microsoft Power Automate to be free to have a more complex algo (based on Boolean column or many dates)

I think approbation tool is good, even first idea was to send a mail and ask to check a "validate this line" column which is flush every 6 months.



Thanks for  any  idea, tips, "flow template" ... 


1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

Hi @Moosh ,

 

I have made a simple test for your reference.

 

1. Here is my list.

vyujincuimsft_0-1655280181175.png

2. Here is my flow.

last_validation lt '@{addDays(utcNow(),-180)}'
union(variables('emailarray'),variables('emailarray'))
items('Apply_to_each_2')
item()?['field name']

vyujincuimsft_1-1655281301545.png

vyujincuimsft_2-1655281474864.pngvyujincuimsft_3-1655281922674.pngvyujincuimsft_4-1655282044178.png

Result Screenshot:

vyujincuimsft_5-1655282257838.png

 

 

 

Best Regards,
Charlie Choi

View solution in original post

7 REPLIES 7
v-yujincui-msft
Community Support
Community Support

Hi @Moosh ,

 

I have made a simple test for your reference.

 

1. Here is my list.

vyujincuimsft_0-1655280181175.png

2. Here is my flow.

last_validation lt '@{addDays(utcNow(),-180)}'
union(variables('emailarray'),variables('emailarray'))
items('Apply_to_each_2')
item()?['field name']

vyujincuimsft_1-1655281301545.png

vyujincuimsft_2-1655281474864.pngvyujincuimsft_3-1655281922674.pngvyujincuimsft_4-1655282044178.png

Result Screenshot:

vyujincuimsft_5-1655282257838.png

 

 

 

Best Regards,
Charlie Choi

Whaou  it's really good. You can't imagine how it can help me to learn.

I would try all of this.

Moosh
Regular Visitor

in this step I've an error because last_verification  isn't know.

Moosh_1-1655626339168.png

 

Moosh_2-1655626865186.png

 

v-yujincui-msft
Community Support
Community Support

Hi @Moosh ,

 

last_verification is the column name. In addition, we need to use the internal column name in Filter Query.

Maybe you could check if the internal column name you are using is correct.

 

https://powerusers.microsoft.com/t5/Building-Flows/If-value-contain-similar-value-then-start-to-coun...

 

 

Best Regards,
Charlie Choi

Aaah  I had created field in french  (Dernière vérification) so the "real name" was Derni_x00e8_re_x0020_v_x00e9_rif

v-yujincui-msft
Community Support
Community Support

Hi @Moosh ,

 

Since you found the real column names, is your problem solved?

 

Best Regards,
Charlie Choi

Indeed, this problem is solved. Thanks. I can continue to implement the complete flow described in your first answer when I've time. (I'm not fast because, "explore" 😉 )

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (7,344)