I posted something similar before, but have decided to try it differently. While I fixed one issue, I created another.
See the picture below.
The Set Up:
I have a Form and a Gallery next to each other. Each time a Supplier sends a price back the user will come to this page and insert the price for this specific UniqueID. When all prices are in, the user will choose the supplier from the gallery. This "Chosen Supplier", is then put into the "Chosen Supplier" Column in the form and uploaded to sharepoint. (On the Form each supplier is a column header in a sharepoint list. On the Gallery, the supplier names are being referenced from a "Supplier List" on a different sharepoint list)
I somehow need the Price under the "Chosen Supplier" to be put into a different column called "Chosen Price". I have no idea how to do this. I tried to LookUp UniqueID in sharepoint list-->sortcolumns by chosensupplierinput.text and have that return the value in the cell, but my research has shown that sharepoint does not allow dynamic column names in the filter, search or look up functions.
Any other ideas to on how to go about this would be welcome. I've now spent two days trying different ways to get one price to be uploaded to a column. My last resort is to just have them put in the price again, but that seems redundant.
Solved! Go to Solution.