Answered

Auto add on scan to collection

(0) Share

Report

Posted on by Ramole Super User 2024 Season 1

Hello everyone,

I would like to know is it possible after i scan and it matches the lookup then to auto add to the collection gallery and navigates to the relevant screen so i can add only quantity, here is my currant formula for the collection

Collect(
 CartList,
 {CItemSerialNumber: Text(Last(CartList).CItemSerialNumber + 1),
 ID: Concatenate(
 Text(
 Now(),
 "[$-en-US]mm/dd/yyyy hh:mm:ss"
 ),
 ThisItem.Title,
 Text(TextInput1.Text)
 ),
 Name: ThisItem.Sales_x0020_Description,
 SKU: ThisItem.Title,
 Amount:TextInput1.Text,
 Price: TextInput1_2.Text,
 Total: (TextInput1.Text * TextInput1_2.Text)
 }
));Navigate('Book Listing_Orders_1',ScreenTransition.Cover)

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

MarvinBangert 1,924 Most Valuable Professional on at

Like (0)

Report
Hi @Ramole,
there is a control named "OnScan" in your "scan" button (if you use the barcodescanner). Just add an "if"-statement around your code, than this should work.
Like:
if(Self.Value exactin <YourLookupCollection.ColumnName>, Collect( CartList, {CItemSerialNumber: Text(Last(CartList).CItemSerialNumber + 1), ID: Concatenate( Text( Now(), "[$-en-US]mm/dd/yyyy hh:mm:ss" ), ThisItem.Title, Text(TextInput1.Text) ), Name: ThisItem.Sales_x0020_Description, SKU: ThisItem.Title, Amount:TextInput1.Text, Price: TextInput1_2.Text, Total: (TextInput1.Text * TextInput1_2.Text) } ));Navigate('Book Listing_Orders_1',ScreenTransition.Cover), Notify("Not data / lookup value found"))

Hope this helps you!

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
Ramole Super User 2024 Season 1 on at

Like (0)

Report

Hi @MarvinBangert

I am having hard time the lookup to navigate with the collection and add to the gallery, my lookup looks a CODE field but it navigates blank when i try, can you please tell me the correct formula for the lookup

Thanks

Was this reply helpful? Yes No
Verified answer

Ramole Super User 2024 Season 1 on at

Like (0)

Report
I have re used my own formula just added a Global variable and used across screen
Collect( CartList, {CItemSerialNumber: Text(Last(CartList).CItemSerialNumber + 1), ID: Concatenate( Text( Now(), "[$-en-US]mm/dd/yyyy hh:mm:ss" ), ThisItem.Title, Text(TextInput1.Text) ), Name: ThisItem.Sales_x0020_Description, SKU: ThisItem.Title, Amount:TextInput1.Text, Price: TextInput1_2.Text, Total: (TextInput1.Text * TextInput1_2.Text) } ));Navigate('Book Listing_Orders_1',ScreenTransition.Cover)

Was this reply helpful? Yes No