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 / Difficulty saving PenI...
Power Apps
Answered

Difficulty saving PenInput Image in One Drive for Business & Excel

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Good Day,

I want to save signatures recorded from a Pen Input into an excel table for archival that includes Columns like AssetId, ProductId, ReservedByName, NameSignature,Remarks,ApprovedByName, ApprovingSignature. The two bolded columns are meant to store the image blob URL. I have tried referring to this blog for help: PowerApps - Saving Digital Signatures to OneDrive - RSM Technology (rsmus.com)

However, the difference is that instead of using Defaults(<<Table name>>), I am using Patch and LookUp to update an existing record.

I have a button which submits the form, and there are two additional lines of code to help me store the image into the excel record which was just submitted. For e.g  SubmitForm(ReserveForm); Patch(Assets, LookUp(Assets,AssetId = ReserveForm.LastSubmit.AssetId), {NameSignature: SignatureRequester.Image}); Patch(Assets, LookUp(Assets,AssetId = ReserveForm.LastSubmit.AssetId), {ApprovingSignature: SignatureApproving.Image}). However, everytime I select the button, the blob URLs are not saved to the excel. The column remains empty. Also there isn't a folder automatically created called Assets_images like the blog mentioned above said would happen.  I already double checked to ensure the LookUp function works as well. 

If I follow the blog and use Defaults(Assets), it works however, it creates a record with all the fields left empty except for NameSignature or ApprovingSignature. 

Below are screenshots of my test case. 

Focus on AssetId 38, showcasing the event where I patch with the base record being Defaults(Assets)

Kieron_0-1711260809480.png

Showcasing the event where I patch with the base record using LookUp

Kieron_1-1711260891954.png

 

Categories:
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Kieron ,

     

    Please try and follow below steps:

    1. OnSelect of Submit button:

    SubmitForm(ReserveForm); 

    2. OnSuccess of the Form:

    Patch(Assets, LookUp(Assets,AssetId = ReserveForm.LastSubmit.AssetId), {NameSignature: SignatureRequester.Image, ApprovingSignature: SignatureApproving.Image})

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    It works! May I know why the code doesn't work when it is put into OnSelect of the button but works when you put it into OnSuccess of the form? 

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Kieron ,

     

    It's a limitation by design, in formula bar it can have up to two Patch methods, which includes SubmitForm, Patch, Update, UpdateIf functions.

     

    Best regards,

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

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 405 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 368

#3
WarrenBelz Profile Picture

WarrenBelz 244 Most Valuable Professional

Last 30 days Overall leaderboard