Hello everyone,
Today i need your help for something i can't do myself.
i need to do an inventory app. All work great with so many screen, it's pretty ugly but meh it work.
I have a QR code scanner, this scanner display me a product ID. That's great but i need to "translate" this in an other name.
I use an excel as a database.
I think of something like this :
Create a table in a excel sheet. In this table there is a column with the list of the product ID and an other column with the translation.
I need a formula that look if scanner find a product id he would replace it by the translation. and reinject it in a cell of an edit form in power apps.
if someone have an idea, it would save me a lot of time in my inventory !
Thank you Have a nice day
