cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
grahampasmurf
Advocate III
Advocate III

flow - some columns missing from Dynamic content, from the "when an item is created or modified"

I am working on several flows that run "when an item is created or modified" in SharePoint Online. In that flow I set variables based on the value of the item when it is created or modified.

 

Recently some columns began to disappear from the list of available columns in the Dynamic Content area.

 

These columns will appear in the list from other trigger points, such as if I have an "Update item" action, but I want the original value.

 

Note that the "see more" option is not available in this case. I do not know why the Dynamic Content is behaving this odd way.

 

My only other option is to use a Compose action to get those columns.  Any ideas?

 

1 ACCEPTED SOLUTION

Accepted Solutions

UPDATE - on some of the columns that were missing, the solution was either to add those columns to the "All Items" view or to update the "When an item is created or modified" trigger to set the "Limit Columns by View" to "Use all columns (Do not limit)" or to otherwise not set that limit.

View solution in original post

4 REPLIES 4
RezaDorrani
Dual Super User
Dual Super User

@grahampasmurf 

 

Sometimes Flow does not show all columns in dynamic content

 

You can get the values using expressions and a compose action

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Okay, I will be using Compose action for this from now on, with triggerBody()?['columnName']

This workaround works some of the time, but I still get errors sometimes.  Plus, this bug also affects the initial trigger conditions of the flow, preventing the flow from functioning properly.  That is something that cannot be fixed by this workaround.

 

UPDATE - on some of the columns that were missing, the solution was either to add those columns to the "All Items" view or to update the "When an item is created or modified" trigger to set the "Limit Columns by View" to "Use all columns (Do not limit)" or to otherwise not set that limit.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (6,209)