Send Reminder Flow to Person Responsible

[--EKM]

Hi All, 

What I am currently trying to do is modify the already existing send reminder function, to not send me a notification of an item whose due date is upcoming, but rather the person responsible. I have tested everything and it sends me the reminder for the correct item within the specified days but I just need to change it to send it to the appropriate person responsible for that item. I am assuming something needs to be changed in the "Get my profile(V2)" step but I am not sure how to code that. circled the step that needs changedshould I put the email of the person responsible in this column or can their email be searched by providing their full name

Best, 

-Eric 

[v-bacao-msft · Accepted solution]

Hi @--EKM ,

Please consider using following method to configure Flow instead of existing send reminder feature.

• Initialize two variables, one type is array to store ResponsibleUser’s email, another one is string to store link to item.
• Configure Apply to each to get all ResponsibleUser’s email and append then to array variable.
• Use union() function to remove duplicate element and generate new array.
• Iterate value of Get items action and use condition to filter current ResponsibleUser’s item, append link to item to string variable.
• After sending an email, we need to empty the string variable.

Expression reference:

union(variables('ResponsibleUser'),variables('ResponsibleUser'))

utcNow('yyyy-MM-dd')

Image reference:

Hope it helps.

Best Regards,

[--EKM]

@v-bacao-msft You have been very helpful! I think I can follow what is going on! My only question is if I wanted to build in a hard coded reminder to send a reminder 60 days before the due date how would that be done? would I change :

utcNow('yyyy-MM-dd')

to look like:

addDays(utcnow(), 60, 'yyyy-MM-dd')

Once again, Thanks so much!

Best, 

-Eric