send reminder as per shift details

[Anonymous]

Hi

I have SP list with resources & there shift timing,  i want to send reminder as per there shift timing everyday.

any suggestions?

Shift timing is in the form of text.

thank you in advance

Sumeet Rajan

[AnthonyAmador]

Hi @Anonymous 

Have you tried using a schedule cloud flow?
In this link you can find more information, hope this helps you.

Run flows on a schedule - Power Automate | Microsoft Docs

Regards.

[Anonymous]

Hi @AnthonyAmador,

yes, the current scenario is bit complex, the reminder should be as shift detail. so for resource A , the shift timing is 05.30 AM - he should receive reminder at 5.30 AM but for resource B if he shift timing is 11.00 AM - he should receive reminder at 11.00 AM.

Logic i thinks should work

1.Run schedule flow at reminder timing(05.30AM,11.00AM & so on)

2.The flow reads data from shift timing column

3. use if statement-  if shift timing column is equal then notification is sent to resources.

Problem 

1- how can we make flow to check individual line item in one column (shift timing)

[AnthonyAmador]

Hi @Anonymous 

Are you using single line of text in the shifts timing column or are you using another column format?

Cheers

[Anonymous]

single line text

[AnthonyAmador]

Hi @Anonymous 

It should be better if you change the column format, you need to create a Date and Time column first and then extract the time part using a calculated column, applying =TEXT([first column name],"hh:mm AM/PM", check this link for more information. Time only Column in Custom List 

That done, this is my solution. 

This is just an example, its not tested because I have some problems with the emails notifications in my test account at the moment, but I think should work, you have to select what type of notification you want.

Hope this can helps you to achieve your objective, let me know what you think. 

Regards.