cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Patch function not working the way it is suppose to

I am trying to make an attendance application using barcode scanner to get attendance. I am using Patch with Default function on text input but it does not save my result in the Excel sheet on OneDrive. I do not want to use a button. I only want the result to be saved just when the code is scanned.

But it does not work. No error or exception. 

Any guidance would be helpful.

 

Regards

Naqash

5 REPLIES 5
BitLord69
Level 10

Re: Patch function not working the way it is suppose to

Can youi please attach a screen dump and your exact fomula you're using? Without those it's impossible to guess what's going on, or more to the point, what's not going on.

JennieTodd
Level: Power Up

Re: Patch function not working the way it is suppose to

I am having the same problem

animeyt | kissanime
 

Anonymous
Not applicable

Re: Patch function not working the way it is suppose to

powerapp2.png

 

 

BitLord69
Level 10

Re: Patch function not working the way it is suppose to

Where's the Patch -code, and where do you call it? Provide as much as information as you can, it makes it so much easier to write a good and helpful reply, no I still need to guess a lot.

 

You have an EditForm. Why not use the built in functions for saving data?

 

Do you not want the users to acknowledge that the label is scanned properly by pressing a button? 

Highlighted
Anonymous
Not applicable

Re: Patch function not working the way it is suppose to

This is the Patch code i am writing in the OnSelect event of text input

Patch(Table1, Defaults(Table1), {Code: Barcode1.Text, Name: User().FullName})

I want the user to just scan tha barcode and the result saves automatically in my Excel sheet in OneDrive. Because Patch function is used when we do not want any user interaction (e.g. button tap).

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (3,844)