For QR Codes in Gallery items use: “https://api.qrserver.com/v1/create-qr-code/?size=10×10&data=” & ThisItem.ItemNumber &”
For Dropdown Controls: Again insert an Image Control and set the Image property to: For Code 128 use “http://bwipjs-api.metafloor.com/?bcid=code128&text=” & SiteDD.Selected.ID &”.png”
Or For a QR Code use
“https://api.qrserver.com/v1/create-qr-code/?size=10×10&data=” &SiteDD.Selected.ID
Reporting of near misses reduces accidents and improves safety. They help you to find out what went wrong, fix problems, and learn lessons. Let Power Apps help.
I will show you how, using Power Platform and SharePoint, you can build your own in-house Near Miss Reporting App.
For Near Miss Reporting with Power Apps, you will need:
An Office 365 Subscription
A SharePoint List
A Canvas Power App
A Power Automate Workflow
Step 1 – First, we need to create the SharePoint List
In a New List named NearMissReports create the following columns:
Location: (Single line of text)
Description: (Multiple lines of text)
Date: (Short date)
Allow Attachments: (This should be enabled by default)
Step 2 – Create the Canvas Power App
From within Power Apps
Click > Create, Choose > Canvas app from blank
Name the App Near Miss Reporting
Choose Phone Format
Click Create
Step 3 – Connect the SharePoint list to your new App
Data > Add Data > Connectors > SharePoint
Navigate to your SharePoint List
Step 4 – Insert a Form into Your App
Insert > Form > Edit Type
Link your form to the Data Source
Step 5 – Add a Button
Add a button at the foot of the screen. Select the OnSelect action of the Button
Type: SubmitForm(FormName)
Your Power App Screen should look something like the image on the right.
Some Changes
I have changed the default date to Now() as opposed to the default Hint Text. To do that you need to unlock the Date Picker Control and replace the Default of “Parent.Default” with Now( ) or Today( ). Next change the Button text Property to “Submit” or “Save” Unlock the Description control and enlarge the Text input box. You can also change the title of the Control to something more user friendly like ” Describe what happened”. Similarly you can change the “Location” Control. if you have a limited set of locations you could change the Text Input of the control to a dropdown list of choices. The format of the items property of the dropdown would be [“Area 1″,”Area 2″,”Area3”]