Power Platform Community Forum Thread Details

automatically create/add url to email -- when clicked trigger a flow

I have a excel file which contains a list of items that employees have borrowed (table contains: name, email address, item, due date). I created a flow that goes through this file everyday and sends an email to employees who are borrowing an item that is due.

I would like to include a link in this email that the employee can click if they wants to renew the due date by 30 days. When this link is clicked I would like to trigger a flow that can go into the excel file and update the due date for the employee.

I have already considered Adaptive-cards/Actionable-messages but these wont work because some of the emails are not outlook.

I have also considered using email with options but i cant use that because that makes the flow pause until a response is received, some people suggested use the parallelism feature but i can only have 50 parallel threads, my client will have hundreds of people in this excel file so that wont work either.

Is there a way for a flow to create a link that can be added to an email and then another flow can be triggered when this link is opened and update the excel file?

Thanks

Categories:

Recommendations

Quick Links