Answered

create/add url to email, when clicked trigger a flow

(0) Share

Report

Posted on by flyinglaptop

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:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @flyinglaptop

The best option might be is Microsoft Forms. Present the link of the email which contains the URL of MS Forms. Ask the user about renewal Yes/No via forms. MS Forms response trigger can get the response and update the excel sheet.

Was this reply helpful? Yes No
flyinglaptop 9 on at

Like (0)

Report
Copy link

Link copied!

Hi @abm ,

Thank you for responding, one issue with using Microsoft Forms is that the user is expected to enter their email when submitting the Form. This does not meet our requirements since an incorrect email can be entered.

I would like a solution that only takes yes/no input from the user.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @flyinglaptop

Yes I agree that you need to collect the email address. The other option is reply email as Yes/No from the users. Capture the email replies as trigger.

Thanks

Was this reply helpful? Yes No
Verified answer

Paulie78 8,424 Moderator on at

Like (1)

Report
Copy link

Link copied!

You could do this quite easily with the "When a HTTP Request is received" trigger. It is a premium action so you will need to have at least one licensed premium account.

Was this reply helpful? Yes No