You’re offline. This is a read only version of the page.
Hello,
I can't make heads and tails of what I'm doing wrong. I created the app from my sharepoint list. I also want the ability to look up a value within a sharepoint list column based on a barcode scan and take me to the DetailScreen1 with the information within the row of that sharepoint list.
See my formula below placed under OnScan
Navigate(DetailScreen1,ScreenTransition.Fade,LookUp(<sharepoint list>,'<sharepoint list column name>'= BarcodeScanner3.Value))
Thank you so much in advance!
Another thing to look for is whether there are other places that also set the 'Record' variable. I created a new app with your scenario based on a SharePoint list (called 'deleteme20190920') with two columns: Title and Barcode (both of type "Single line of text"), and used the "Start with your data" to create a starter app.
Those were the changes that I did to the app to enable the scanner to go directly to a detail form:
That should do it for the display form, as we decoupled it from the gallery selection. This would still be missing the integration with the edit screen - for that you would need to do something similar, and this is explained in this post I wrote a while ago: https://powerapps.microsoft.com/en-us/blog/decouplingbrowsegalleryfromforms/.
It is. Also, I decided to delete the old one and redo it, thinking it would help so BarcodeScanner3 is now BarcodeScanner1. This screen though doesn't show any errors.
Your data source for the form is "PCF_F"; is the lookup expression that you are using in the lookup from that list?
Set( Record, LookUp( PCF_F, '<sharepoint list column name>' = BarcodeScanner3.Value));
The record must come from the same data source as the DataSource property of the form.
If you click on the red 'X', which error do you see? Another option is to click on the "App Checker" icon (see below), and it will show you the errors of the document:
Knowing which error you get will help with finding a solution.
I'm still not sure why it's not working. Previously BrowseGallery1.Selected was there.
This is my screen
There are two expressions in @v-monli-msft suggestion. The first one should be set to the OnScan property of the BarcodeScanner control:
Set( Record, LookUp( <sharepoint list>, '<sharepoint list column name>' = BarcodeScanner3.Value)); Navigate(DetailScreen1,ScreenTransition.Fade)
The second one should be set to the Item property in the display form on the DetailScreen1 (assuming it's called DisplayForm1):
Record
That also assumes that the DataSource property of the display form:
<sharepoint list>
Where <sharepoint list> is the actual name of your SharePoint list.
Hope this helps!
Hello Mona,
Thank you for the help.
Unfortunately it doesn't work. The part that I am receiving an error message for is the latter one.
DisplayForm1.Item=Record
Should it be separated by a semicolon or parentheses?
Hi @djean64 ,
What is the column type of this column that you lookup to? If it's a text/number column, then below formulas should be set to achieve this:
BarcodeScanner2.OnScan=Set(Record,LookUp(<sharepoint list>,'<sharepoint list column name>'= BarcodeScanner3.Value);Navigate(DetailScreen1,ScreenTransition.Fade)
DisplayForm1.Item=Record
Regards,
Mona
#1
WarrenBelz
146,743
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,089
Most Valuable Professional
Share
Report
All responses (
Answers (
