cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jeretangwk
Frequent Visitor

Sharepoint list reminders before due date

Hi,

 

I'm new to power automate and flow. Been quite frustrated desperate learning about modern sharepoint and trying to get help. 

I have the following issues/requirements not sure if anyone can help (you may refer to screenshot below for purpose of this discussion).

jeretangwk_2-1612488478708.png

Intention as follows:

1. Entry of intended date/time for a process (A, B, c or D) to undergo audit

2. Auto trigger/reminders to 'person in charge' 30 days prior to the planned date/time

3. Able to 'group' the process assigned under the same Person in charge and send a single email depicting the reminder instead of 1 email per process (there are more than 100 processes)

4. Notification of status (i.e. completed or in in progress) to respective person in charge

 

Many thanks!

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-duann-msft
Community Support
Community Support

Hi @jeretangwk 

 

Thank you for posting.

 

Based on your description, we can configure flow combining two conditions with apply to each action to achieve your purpose.

 

This is my SharePoint list as you described:

v-duann-msft_0-1612772179853.png

 

 

The first condition is used to check the 30days prior to the planned date/time. The second one is to filter status equals ‘in progress’ or ‘completed’.

Related expression:

1.formatdatetime(addhours(items('Apply_to_each')?['PlannedDate_x002f_Time'],-8),'yyyy-MM-ddTHH:mm:ss')
2.formatDateTime(addhours(formatDateTime(adddays(utcNow(),-30),'yyyy-MM-dd'),9),'yyyy-MM-ddTHH:mm:ss')

v-duann-msft_1-1612772179856.png

 

 

Here is the detailed flow reference:

v-duann-msft_2-1612772179861.png

 

 

v-duann-msft_3-1612772179864.png

 

 

Hope the content above may help you.

 

Thanks

Anna

 

View solution in original post

Hi @jeretangwk 

 

Thank you for your update and sorry for that. 

 

Here is the capture of the first two actions:

v-duann-msft_0-1612854769271.png

 

The trigger action is used to start flow and test easily.

The 'get items' action you need to navigate to your own site address and the specific list. Please feel free to configure as required.

 

Thanks

Anna

View solution in original post

3 REPLIES 3
v-duann-msft
Community Support
Community Support

Hi @jeretangwk 

 

Thank you for posting.

 

Based on your description, we can configure flow combining two conditions with apply to each action to achieve your purpose.

 

This is my SharePoint list as you described:

v-duann-msft_0-1612772179853.png

 

 

The first condition is used to check the 30days prior to the planned date/time. The second one is to filter status equals ‘in progress’ or ‘completed’.

Related expression:

1.formatdatetime(addhours(items('Apply_to_each')?['PlannedDate_x002f_Time'],-8),'yyyy-MM-ddTHH:mm:ss')
2.formatDateTime(addhours(formatDateTime(adddays(utcNow(),-30),'yyyy-MM-dd'),9),'yyyy-MM-ddTHH:mm:ss')

v-duann-msft_1-1612772179856.png

 

 

Here is the detailed flow reference:

v-duann-msft_2-1612772179861.png

 

 

v-duann-msft_3-1612772179864.png

 

 

Hope the content above may help you.

 

Thanks

Anna

 

View solution in original post

Hi Anna,

 

Thanks for the help rendered. As i've mentioned i am really a newbie at this. Apologies i can't make sense of all these...

There are other rows that needs to be filled such as:

1. Manually trigger a flow (input)

2. Get items (ODATA?)

Hi @jeretangwk 

 

Thank you for your update and sorry for that. 

 

Here is the capture of the first two actions:

v-duann-msft_0-1612854769271.png

 

The trigger action is used to start flow and test easily.

The 'get items' action you need to navigate to your own site address and the specific list. Please feel free to configure as required.

 

Thanks

Anna

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,925)