I have a SharePoint list with a lookup column connecting another list. This lookup column is referencing the Title and two extra values that I need to show from the second list but not the ID. This is fully functional in SharePoint (no errors here).
If I try to create (or update) an item in Power Automate, the corresponding column is not available in the action and therefore I cannot update the value in my flow.
I created a test list and in that one it works just fine, so I'm wondering if anyone knows why a lookup column might dissapear from Power Automate and how to bring it back.
Can you post a screen shot of the list settings page which shows the lookup column and also a screen shot of the create item action with the site and list selected?
Sorry, but I tried an am unable to replicate your issue. I know this may sound silly, but can you double check to make sure that your Flow is pointing to the correct list?
That was my first thought, and I created a second list with this same scenario. Used this approach multiple times but only in this case have I ever seen a lookup column disappear like this.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!