Why Don’t My Calculated SharePoint Fields Show in Flow Dynamic Content List?

//Why Don’t My Calculated SharePoint Fields Show in Flow Dynamic Content List?

Why Don’t My Calculated SharePoint Fields Show in Flow Dynamic Content List?

Why Don’t My Calculated SharePoint Fields Show in Flow Dynamic Content List?

If you use Microsoft Flow to create and/or copy values into SharePoint lists, you may have noticed that calculated fields from the SharePoint list do not always appear among the Dynamic Content fields you can select. This is because Flow prevents these fields from being used for all field types.

When you try to select a field to copy into the list field on the Create Items screen, Dynamic content will show, but not include all fields:

image

This was a real head scratcher for me, as I needed to get a calculated field that included tax into the destination list, yet wanted to avoid doing another calculation in Flow if I could help it.

Well, there’s a handy workaround. I noticed that when I was in text fields, all of my SharePoint list fields appeared as choices in Dynamic content:
clip_image004

So I tried something sneaky: I selected all the fields I needed and inserted them into one Text field, then I cut and paste them into each of the destination fields in which I really needed them.

Insert, then Cut from here:

clip_image006

And paste into here:
clip_image008

Voila!

Go forth and Flow!

By |2019-05-02T12:30:32-04:00May 2nd, 2019|Uncategorized|0 Comments

About the Author:

Leave A Comment