Send reminder email to case record owner if case not modified last 48 hrs using Power Automate flows

[Jharana]

Hi Experts,

I am stuck to do the above task , here my req is to get all case lists from dynamics crm online 9.2 which are not modified in last 48 hrs & send the reminder email to the owner of case record & in email it should list the table of case records so that owner will get an idea that all these cases are pending with him.

Where to start & how to do , anyone can help me on this ?

[v-LilyW-msft]

Hi @Jharana 

Does each owner have multiple records?

I set up a flow and please take a try with the following screenshots.

Assume my list like this and Title 1\3\5 don't modified for more than 48 hours. 

Flow in details:

Then save and test Flow.

After flow runs, Lilywang and test2 will receive an email as below:

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jharana]

Hi Lily,

Thanks for your response.I am trying to do the 1st step to get the lists of case but getting bad request error. its failing.

[v-LilyW-msft]

Hi @Jharana 

There is ‘lt’ between Modified and the formula which means less than.

Best Regards.

[Jharana]

Hi Lily,

Thank you now there's no error in flow i have selected like below & the next step what need to select in action like select variable or initialize or set variable ?

[v-LilyW-msft]

Hi @Jharana 

Search select,then you will find the action:

Best Regards.

[Jharana]

Hi Lily,

After select in search then in From section what need to select or expression & Map values what is the use of this step not able to understand .

Any step by step method ?

Thanks,

Jharana

[Jharana]

some how i managed to add value but email key value what need to provide ?

 

[Jharana]

 some how i managed to add value but email key value what need to provide ?

[v-LilyW-msft]

Hi @Jharana 

Sorry, because I don't have the license of Dynamics 365 (deprecated), so I can only use Sharepoint list to test.

Is there an email column in your list? If has, you can choose in the dynamic content.

Because my list has Email column,so I can select it from the dynamic content.

Best Regards.

[Jharana]

Hi Lily,

 As of now i am doing one by one following above yes on e field we have owner field which is a lookup its containing name not the email address. Is anyone available from dynamics crm 365 side so that it can be helpful ?