So I have a form that has the item lookup field. When i select the value for the field, I want the value of another column from that same selected lookup record.
For example one of the records of the items table:
primary name = glue, chemical = no
So in a form, when i select glue, I want another field in the form to show 'no'.
Is it better to use javascript or power automate? How to do it for each?
