Hello
My app ask a user to enter a number who range between 000000 and 999999 and who are used to reference products . Then i search in my table this number in a specif column (alway the same) and i get the first match.
Then i use this match to give info to the user about the product. I tested with a self made test table where the reference range between 000000 and 999999 and it work.
Now I got to use a table made by someone else. In this table, the reference column is different since it's made like this :
Y-XXXXXX
Where Y is a letter and XXXXXX are my number (who range the same).
I want to compare the number my user input with the reference number of the new table minus the Y- .
Do you know any way who can help me achieve that ?
I can do this in powerapp OR i can do this in the sharepoint who is my source. But i don't know how to do this for both.
Thanks in advance.
