SharePoint List "Lookup" columns not available in Get Items in Flow

I have seen this discussion before (see here) but suggested solutions have not resolved my issue.

So, I am looking for some more guidance or suggestions.

I have a SharePoint list with a Look-up column. Using Get Items in a cloud flow this field does not display. 

Setup 

1. SharePoint List called "ARB Meetings"
2. SharePoint List called "Decision Register", this has a lookup column to the ARB Meetings list.
3. Get Item

   Note, I have tried using Limit columns by View and created a new view including the required lookup column, without success.

   

    

4. In the Decision Register SharePoint List, there are some items where the ARB Meetings column is blank, I don't know if this could cause an issue?

Co-Pilot Help

I have asked Co-Pilot for help, which gave me plently of good options I have tried the following without success:

If your lookup column is not showing in the Get items action in Power Automate, here are a few steps you can try to resolve the issue:

1. Check List Views:

   • Ensure that the lookup column is included in the default view of your SharePoint list. Sometimes, columns not included in the view might not appear in Power Automate[1].

2. Refresh the Flow:

   • After adding the lookup column to your list, refresh your Power Automate flow. You might need to close and reopen the flow designer to see the updated columns[2].

3. Limit Columns by View:

   • In the Get items action, use the Limit columns by view option to select a view that includes the lookup column. This can help ensure that the column is retrieved[2].

4. Check Column Settings:

   • Verify that the lookup column is properly configured in SharePoint. Ensure it is not hidden or restricted in any way[1].

5. Pagination Settings:

   • If your list has a large number of items, enable pagination in the Get items action settings. This can help retrieve all items, including those with lookup columns[3].

If these steps don't resolve the issue, you might want to try creating a new flow from scratch to see if the lookup column appears. Sometimes, starting fresh can help Power Automate recognize new or updated columns.

Let me know if you need further assistance or if there's anything else I can help with!


References

[1] Solved: Get items not showing lookup column - Power Platform Community

[2] Solved: Missing Columns from SharePoint List in Flow - Power Platform ...

[3] In-depth analysis into 'Get items' and 'Get files' SharePoint actions ...

Thank-you,

Irene