New to Microsoft Forms & Power Automate – Need Help Automating QR Code Email for Event Attendance

(0) Share

Report

Posted on by DJ-28091135-0

Hi everyone,

I’m completely new to Microsoft Forms and Power Automate, and this is my first time trying to link the two together.

I’ve created a Microsoft Form to invite guests to our annual carol service. One of the questions asks whether they are able to attend. I’d like to automate the following process using Power Automate:

When someone submits the form and selects “Yes” to attending,
An email is sent to them confirming their attendance,
The email includes a unique QR code that can be scanned on the day of the event,
The QR code should help us track who actually attends.

I’ve tested the form and used it successfully for a Gift Aid declaration form, and it appears to work well up to that point. Now I’d like to build on that by linking it to Power Automate to handle the email and QR code part.

I’m not sure how best to generate and send the QR code, or how to store the data for scanning later. I’d really appreciate any guidance, tutorials, or examples from the community to help me get asap :( .

Thanks so much in advance!

Dorothy

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Vejai SH 555 on at

Like (0)

Report
Copy link

Link copied!

Hi @DJ-28091135-0,

End to end flow will be

1. Trigger: when a new response is submitted in Forms

2. Check answer: use "Get response details" -> condition : attending = Yes

3. Generate Unique ID: (like Guid or Email + timestampe

4. Create QR Code

5. Send confirmation email : Attach or embed QR Code

6. Store information: Save to sharepoint / Dataverse, so you have to lookup table for scanning day

for QR code check : Generate QR Code/ Bar Code using Power Automate with Dataverse

Thanks,

Vejai SH

Please mark as answer if my suggestion helps you.

Was this reply helpful? Yes No
Verified answer

RobElliott 10,391 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Dorothy, Power Automate works beautifully to link up Forms and SharePoint - at my company it is a requirement that any live form has an associated SharePoint list to store responses for backup & audit reasons.

For your requirement there is a detailed walkthrough of how to do this at https://www.spguides.com/generate-qr-code-power-automate/ which I've just tested and it works fine. The only (somewhat important) piece of information that the blogger missed out was that in the send an email action you need to turn on code view before you paste in the email details - code view is turned on by clicking the </> icon:

This is the full flow result I've just run:

This is the form response saved into the SharePoint list:

And this is the email confirmation with the QR code:

This was the information that was captured when the QR code from the email was scanned using my smartphone:

If you need to talk through it in detail then send an email to me at rob.d.elliott at wsp.com and I'll setup a Teams meeting (if you have Teams, otherwise it will have to be on Zoom).

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, Power Platform, WSP Global (and classic 1967 Morris Traveller driver)

Was this reply helpful? Yes No