Missing Columns from SharePoint List in Flow

[Anonymous]

I have added columns to my SharePoint list and they are not showing up in my Flow. I've backed out of the Flow and refreshed my screen several times. I've shared my Flow with someone else and they can't see the fields. I've tried creating a new Flow from scratch and the fields still don't show up. There's are 2 choice fields and 1 short-text field not showing up. 

[v-yamao-msft]

Hi @Anonymous ,

How is your flow created? Could you share a full screenshot of your flow?

Have you made any changes to the list after the flow has been established?

I have created a list which contains two Choices column and a single line of text column.

When configuring the flow, all of them are available as dynamic contents.

If possible, please try to recreate the list to see if the issue still exists.

Best regards,

Mabel

[Anonymous]

I do not want to recreate the list because it's already in use. I have other Flows working on it with no issue. The "Calendar SP ID" column showed up before with no issue. The other two columns I just added yesterday and now all three of those columns won't show up. So, yes, I made changes to the list after the flow was established.

I went into another Flow that uses this list and the columns don't show up in Dynamic Content in that one either when I try to add them to a step.

[v-yamao-msft · Accepted solution]

Hi @Anonymous ,

Thanks for updating.

Have you created Views for the list on SharePoint site?

Have you selected a specific View for the field Limit columns by View?

If yes, please make sure the view you’ve selected contains the added columns.

Best regards,

Mabel

[Anonymous]

Oh my goodness!! You are a genius! I can't believe that. THANK YOU!

[pcm]

I ran into a similar issue with a column missing from my loaded list and even with a view that only loaded that column it was not being loaded. The issue ended up being that the column I was loading from did not have a value set for the item I was loading. Since there was no value, the Get Item action just didn't even return that column in the result. So when I used a condition to check what the value of that column was it caused my Flow to fail. I ended up needing to add a check for whether the column was being returned before checking if the column was a specific value.

I would have expected blank columns to be returned and set to empty or undefined instead of not existing. 

[HallieG]

I have the same issue. I have my field in the view I created, the field is a lookup column in the SP list. 

[Udayan]

Same issue .. but lookup column  is not showing up . Tried get items with views but still no luck .

[Vegard1]

I have the same issue, all columns except the ones with lookups.

[Stefni]

I am still having this problem. I added a column to one of my views a couple days ago. I want to filter 'get items' by this column but Power Automate can't find it. I have refreshed multiple times and I have refreshed the sharepoint site as well. It seems stuck on the old data from the list. I checked filter by view, changed it, changed it back - this has no impact. 

[amberschiffer]

I'm having the same problem but with the Title Column, which is not a lookup.  I'm not in a restricted view and have content in the cells under the title column. But power automate is not finding it.