My goal is to have a user select from different drop downs a project, employee, and role. Then manauly type in a percentage. I want all of these saved into one excel file when the user submits the form. Is it possible to pull the drop down info into a seperate a file?
Could you please share a bit more about your scenario?
Do you want to submit data from multiple data sources and user input into single one row of your Excel table?
If you want to submit data from multiple data sources and user input into single one row of your Excel table, please check and see if my response within the following thread would help in your scenario:
In addition, I don't think the SubmitForm function would help in your scenario. I think the Patch function could achieve your needs. On your side, you should type the following formula within the OnSelectproperty of the "Submit" button: