You’re offline. This is a read only version of the page.
Announcements
2
Hi everyone,
I am struggling with conceptualising something that feel into my lap today, would appreciate if some of the PA gods here could recommend me a way of tackling the following use case:
The Problem:
I need to provide a series of QR codes to users whereas each QR code is unique to an employee, meaning it contains a URL along with a variable that identifies the user.
Example: http://www.somesite.com/index.php?user=Tom&id=123456&office=ABCDE
Once the user opens this link (or rather, scans the QR code) in his/her device, I would like to be able to read the values and write them in a centralised excel file located on a Sharepoint. Once the writing is done, I would like to redirect the user to another URL that contains a part of the variable.
Example: http://www.anothersite.com/office/ABCDE.php
Long story short, this is something akin to a link / usage tracker where I want to be able to understand how many times the URL was viewed, and what user (based on the user variable) opened the link.
Generally, I would write this relatively easily in PHP with a bit of MySQL and JS, but due to the lack of webserver I am literally stuck with the M3656 suite of tools. Is there anyway something like this can be realised by using only M365 tools?
Thank you very much!
You could achieve it easily using a Power App.
A Power App generates a unique URL and supports query string parameters. These parameters can be accessed using the Params function within the On Start event of the App.
Subsequently, you can incorporate conditional logic to redirect users using the Launch function based on specific criteria.
Share
Report
All responses (
Answers (
