I'm trying to create an item in a sharepoint list from power automate. The list has a lookup column called 'Company' (field name is same) that I need to populate, but it's not showing in PA. After doing some research, it seems the column should be showing in PA as 'Company Id' but I'm not seeing that either. What am I missing?
Update: I had another list that has a lookup column to the same Company list where 'Company Id' is showing as expected in PA. The only difference in the columns was that it is required in the working one. I made the column required in the one I'm having issues with, and i received the attached error when I try to edit the create item in PA, stating 'The required field \"Company\" data type is not supported'. Why would this be the case? And how would I resolve? The only other difference between the lists is the one having the issue is a subsite. Are there restrictions with lookup columns on subsites and PA?
