Hello Power Community
I have a jobs table with company column as text and another company lookup column, i want to copy data from my company text column to my company lookup column
For this purpose i created lookup table company also
So i wanted to use power automate to fill the lookup column , but its not working for me
1. I started with list rows of jobs table
2. In apply each, i again listed rows of company table , but now is the trick, how to compare each company text to the company field in my company table to get the unique id
i tried something like company eq company using schema names but it gave some errors
Any one can help for that ?? dont know what am doing wrong frankly
Thanks