'Trying to collect value and sent it to specific column in collection in powerApps while using a dropdown menu

I'm writing a program in powerapps to log R&D formulas in a collection. Currently, I'm using dropdown menus to pick raw materials. I would then like the %wt for that raw material to be sent to it's respective raw mat column in collections. I'm testing I can get the column to make a label but the %wt doesn't show up in the column. Once i get it to work for one raw mat I'll write the rest of the code.

If(solvent1.SelectedText.Value="SR 506",Collect(Collection1,{'SR 506':solvent1wt.Text}))

The input for the %wt is labelled: solvent1wt



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source