Scan qr and modify registry

[Anonymous]

Hello,

With excel create a table, to show the records in power apps, it works fine. But I try to add a barcode scanner, so that when I start the application it reads the code and goes to the record I have in excel to modify it. I am a beginner at this, so far I have only achieved this:

Patch(Readings,
Defaults(Readings),
{
BarcodeScanned: BarcodeScanner3.Value,
ScannedPerson: User().FullName,
ScannedTime: Now()
})

But the above only scans the qr and adds it as a new record.

I hope someone can help me Greetings

[Anonymous]

Hi @WarrenBelz 

I had added .tx, for the above that you had told me.

As you indicate that excel is not a good database for various reasons, which one would you recommend it to be?

What I need to achieve is something like this https://powerapps.microsoft.com/en-us/blog/make-barcode-scanning-apps-in-minutes/ , but I see that the barcode detection property no longer appears in power apps...

Thanks for help 🙂

[WarrenBelz]

Hi @Anonymous ,

Under your "standard" licence, SharePoint is the best option - I use it for all of our company apps.

I am not sure what you mean about the barcode scanner - it is available under Media.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Anonymous]

@WarrenBelz  thank you very much, I already switched to sharepoint.

Excuse me, how could I enter 2 formulas to search for a record in the Gallery Items function?
Namely
1. To use the barcode scanner, and
2. To use the filter text field when typing a few words?
Since I add them but it indicates that it is wrong

Thanks for help

[WarrenBelz]

Hi @Anonymous ,

Something like this should do it

SortByColumns(
   Filter(
      [@SReadings],
	  StartsWith(
         Barcode, 
         BarcodeScannerl.Value
      ) ||
      StartsWith(
         Title,
         TextSearchBoxl.Text
      )
   ),
   "Title",
   If(
      SortDescendingl,
      Descending, 
      Ascending
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Anonymous]

Hi @WarrenBelz 

I change like you say, but appers the errors:

The function 'StartsWith' has some invalid arguments.

Invalid number of arguments: received 1, expected 2 or more.

Name isn't valid. This identifier isn't recognized.

😕

[WarrenBelz]

@Anonymous ,

Where are you using this code? The syntax is valid providing your values are. Can you also please post the exact code you are using.

[Anonymous]

Hello @WarrenBelz 
I am using the code in the gallery items function
The code that I am using, was the one that you provided me

SortByColumns(
   Filter(
      [@SReadings],
	  StartsWith(
         Barcode, 
         BarcodeScannerl.Value
      ) ||
      StartsWith(
         Title,
         TextSearchBoxl.Text
      ),
      "Title",
      If(
         SortDescendingl,
         Descending, 
         Ascending
      )
   )
)

and the variables are correct

[WarrenBelz]

@Anonymous. 

free type text and one bracket in the wrong place I am on my phone at the moment but it needs a double bracket at the bottom before the sort then remove one right at the bottom.

[Anonymous]

Hi @WarrenBelz 

I add a bracket as you say

SortByColumns(Filter([@SReadings],
StartsWith(Barcode, BarcodeScanner1.Value) ||
StartsWith(Title,TextSearchBox1.Text)),
"Title", If(SortDescending1,Descending, Ascending))

but only works once, what's due to?

now only the record is found by the TextSearchBox1

[WarrenBelz · Accepted solution]

Hi @Anonymous ,

This is the correct syntax for your query (I have also fixed my original post to avoid any confusion)

SortByColumns(
   Filter(
      [@SReadings],
      StartsWith(
         Barcode, 
         BarcodeScanner1.Value
      ) ||
      StartsWith(
         Title,
         TextSearchBox1.Text
      )
   ),
   "Title", 
   If(
      SortDescending1,
      Descending, 
      Ascending
   )
)

You can also do this to allow for blank values

SortByColumns(
   Filter(
      [@SReadings],
      (
         IsBlank(BarcodeScanner1.Value) ||   
         StartsWith(
            Barcode, 
            BarcodeScanner1.Value
         ) 
      ) &&
      (
         IsBlank(TextSearchBox1.Text) ||   
         StartsWith(
            Title,
            TextSearchBox1.Text
         )
      )
   ),
   "Title", 
   If(
      SortDescending1,
      Descending, 
      Ascending
   )
)

Does this improve it?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.