How to add ‘missing’ SharePoint column to expression in Power Automate

“After starting with my expression and going to the dynamic content section, Power Automate doesn’t show any column that is in my SharePoint list other than body and value.”


You just used ‘Get items’ to get items from a SharePoint list to process them later in the flow. All the columns are available among the other dynamic content, until you need an expression. You type in the expression, switch to the ‘dynamic content’ tab, and it’s not there. You see only ‘body’ and ‘value’. None of the columns that were available a moment ago is available for the expression.

How can you then e.g. split() a string or formatDateTime() when Power Automate doesn’t show you the column?

Use ‘Compose’ action

The simplest solution is to store the dynamic content in a ‘Compose’ action before you need it. As you can see on the screenshot above, outputs from the ‘Compose’ action stay available.

If you store the SharePoint column into a ‘Compose’ action, you can later add it to the expression.

missing SharePoint column expression Power Automate Compose action

‘Type in’ the column

The other option is to type in the column directly into the expression. Even if it’s not displayed among the dynamic content, the column is still there. It’s inside the ‘value’ output from ‘Get items’, but you must tell the flow how to find it.

The best start is to enter the column into any Power Automate action, e.g. ‘Compose’ as in the previous step. Copy/paste it from there into a text editor, you’ll get a result similar to the one below.

@{items('Apply_to_each_3')?['DateTime']}
Power Automate get sharepoint column dynamic content

Remove from there the starting @{ and closing } and you get a reference to that column.

items('Apply_to_each_3')?['DateTime']

Now you can copy/paste the column reference directly into the expression.

Power Automate use sharepoint column in an expression

Summary

As already explained in the post on processing JSON without ‘Parse JSON’, it’s not necessary to have all columns available as dynamic content. It would be nice, it would simplify your work, but it’s not a blocker.

You can add a ‘Compose’ action and use its output, that’s the most brute force solution. Or you can reference the column by yourself with the second solution, even without coding knowledge.

You could probably also use ‘Parse JSON’ to get all the dynamic content back, but I think that would be an overkill in this situation.


Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

Add a Comment

Your email address will not be published. Required fields are marked *