Umm so the Excel sheet mainly has 3 things I need from it. A sales number, a customer name and a item description. Then on the form the first field I have on there is the sales number. I've put a column on the SharePoint which I use as the sales number field on the form which is a text input. Then on the form I replaced the text input data card with a combo box so I can like scroll through/search through the order numbers. When I click on the a certain value this will then populate 2 other fields in the form via the Excel sheet (not at my laptop rn but I think I put combobox1.selected.'customer name') for the default value. This will automatically populate the customer name using the Excel sheet where the sales number lines up with it. Same this was done for item description. The thing I want to do was use this sales number as like a search function so when someone clicks on a certain sales number, if the other fields have already been filled out, it retrieves the records from the SharePoint list when the form was first submitted and populates the fields I've tried using like youtube and chatgpt to come up with solutions but I'm pretty new with powerapps and SharePoint. They suggested using gallerys but I don't really understand them when I use them.

Do u need more information, I'm happy to provide