QR Code to Pull Microsoft Form Responses?

Question

Hello!

I've created a Microsoft Form to perform audits each day for every truck in our facility. I would like to have a QR code that stays on the truck which, when scanned, will pull up the most recent form submission for that specific truck. This will let the first shift truck drivers see what the second shift auditors entered the night before. Is there a way to do this between microsoft forms and power automate?

Answer 1

Dear Rachel,

May I know whether you need further help on this issue?

Sincerely

Cliff | Microsoft Community Moderator

Answer 2

Dear Rachel,

As it is a API call output, you need to manually type outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['value'] in Expressions in Compose like the following.

In some situations, what you type may be converted to body.value in the flow automatically.

.

Welcome to share any updates at your convenience if you need further help on this issue.

Sincerely

Cliff | Microsoft Community Moderator

Answer 3

Hello!

Thank you so much for your response. I'm attempting to test it out, but I'm getting stuck on the 4th "Compose" step. I'm not getting the option to put in the "body.value" linking it to sharepoint - I can only type in the input. What am I missing?

Answer 4

Dear Rachel,

Have you tried the suggestions above? Welcome to share any updates at your convenience if you need further help on this issue.

Sincerely

Cliff | Microsoft Community Moderator

Answer 5

Dear Rachel,

Yes, you can do that with Power Automate. However, to use the QR code API, you may use the premium license connector HTTP or other third-party connectors.

Based on the description, you needs to pull the most recent submission from the specific truck. If yes, my demo flow is to show the response of only today from the truck 2.

The demo form is like the following and as a test, I submit 4 responses and the qualified responses are only 2.

.

In the demo flow, you can filter the responses, write the data to a .csv file, create an Anyone link for the file and then create a QR code to access the file automatically.

The file and the QR code is shared in a folder in SharePoint Online.

The flow details are the following.

.

Get all responses of the form by using Rest API. For the details, you can refer to Power Automate: MS Forms responses to Sharepoint - Microsoft Community.

Compose: outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['value']

Filter Array:

From: output of Compose

@and(equals(json(item()['answers'])[0]['answer1'], '11/22/2023'), equals(json(item()['answers'])[1]['answer1'], 'Truck 2'))

Compose2:  json(item()['answers'])[0]['answer1']

Compose3: json(item()['answers'])[1]['answer1']

Compose4: json(item()['answers'])[2]['answer1']

Append to array variable:

{

"Submission Date": "output of Compose2",

"What Truck": "output of Compose3",

"Next Shift": "output of Compose4"

}

Get the premium license HTTP connector. For the details, you can refer to Overview of HTTP connectors in Power Automate - Training | Microsoft Learn

HTTP:

Method: GET

Uri: https://api.qrserver.com/v1/create-qr-code/?size=150x150&data=out put of Compose5.

Create the QR code file with the Create file connector and save it in a shared folder in SharePoint Online.

File Content: base64ToBinary(output of Compose6['$content'])

All process are done by the flow and you can finally share the QR code file with the drivers.

Thank you for your time and effort.

Sincerely

Cliff | Microsoft Community Moderator