web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Scan QR Code - LookUp ...
Power Apps
Unanswered

Scan QR Code - LookUp from other Sharepoint List - put Signature

(1) ShareShare
ReportReport
Posted on by 11

Hi Community,

 

I am very new to powerapps and really want to learn

I am in a middle of create an apps for Event Check-in

 

I have successfully create a scan QR code (contain only email) feature and store it in the sharepointList (A)

my question is, when I successfully scan the barcode, it is possible to have another screen that show the name and company which is a lookup to another sharepointList (B), look up by email, and then show a signature field so the user can put sign in it, then submit the data to sharepointList (A)

 

Thanks a lot

really appreciate for the help

Categories:
I have the same question (0)
  • poweractivate Profile Picture
    11,078 Most Valuable Professional on at

    @Russpe01 


    You may want to try the following

     

    1. Scan QR Code and Navigate to a New Screen:

    Once you've successfully scanned the QR code and have the email, use Navigate(Screen2, None) to go to a new screen (replace Screen2 with your desired screen name).

     

    2. Look Up Data from SharePoint List B:

    On Screen2, for the labels where you want to display the name and company, use a LookUp function to retrieve this data. Assume the columns in SharePoint List B are 'Email', 'Name', and 'Company'.

    For Name, use this formula:

    LookUp(SharePointListB, Email = BarcodeScanner1.Value).Name

    For Company, use this formula:

    LookUp(SharePointListB, Email = BarcodeScanner1.Value).Company

    Replace BarcodeScanner1 with the name of your barcode scanner control.

     

    3. Signature Field:

    For the signature, you can use a Pen input control. Add a Pen input control to your app and rename it, for example to 'Signature'.

     

    4. Submit Data to SharePoint List A:

     

    Once the user signs, you can store this signature image in SharePoint List A.

    To save the signature image, it's better to save it as a URL.

     

    You might need to use the Power Fx JSON function to convert the signature image to a JSON format string and then save it to SharePoint.

     

    On the button used for submitting the form, you can use this function:

     

    Patch(SharePointListA, Defaults(SharePointListA), {Email: BarcodeScanner1.Value, Signature: JSON(Signature.Image, JSONFormat.IncludeBinaryData)})

     

    This should create a new item in SharePoint List A with the scanned email and the user's signature.

     

    Please note that this is a basic outline of how you could structure your app and you may want to adjust the above, based on the specifics of your setup.

     

    Also, keep in mind that Power Apps does have some limitations with image data, and storing images directly in SharePoint via PowerApps might not work as expected.


    The image data will be in a URL format and you may need to decode this URL to view the image.


    If this isn't suitable for your use case, you can consider to use a different method to store and retrieve images.

     

    See if it helps @Russpe01 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 377 Most Valuable Professional

#2
11manish Profile Picture

11manish 165 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 110 Super User 2026 Season 2

Last 30 days Overall leaderboard