Missing Dynamic Content

(0) Share

Report

Posted on by billf24

158

I am creating a Flow, that is using the trigger "When a new reponse is submitted" from a Microsoft Form. Then I have the Get Response Details. When I create the form, the flow through those two items work file. I see all the fields from the Form in the Get Response Details. I created a SharePoint list with the same names as the fields in the Form. Two fields are currency fields that are on the form. When I add Create Item to add the items to SharePoint, I see the two currency fields. the two currency fields do not display.

But when I get to the Currency Field in the Create Item, all I see is this:

This worked before on other flows that I made.

Suggestions?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

David_MA 14,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Please show the configuration of your flow rather than highlighting the actions you used. This statement doesn't make sense, "When I add Create Item to add the items to SharePoint, I see the two currency fields. the two currency fields do not display." Showing your flow and how it is configured will help to clarify what you're trying to say.

Was this reply helpful? Yes No
billf24 158 on at

Like (0)

Report
Copy link

Link copied!

Sorry for the typo. Below shows when I add the Description of Work, you can see Material Cost in the Get response details.0

But when I select the Material Cost line, I do not get the option for Get Response Details. The same with Labor Cost.

Was this reply helpful? Yes No
Suggested answer

Pstork1 69,127 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Those two fields are looking for numeric input so the dynamic content is filtering out string values. The easiest way to fix it is to use a couple compose actions just before the create item. You can load those values into a compose and then you should see the compose when you create the item. You can also do it by typing in the appropriate JSON, but if you aren't familiar with JSON its easier to use the compose. You may also need to cast the values using a Float() function to convert from string to number.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Suggested answer

David_MA 14,090 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
You said the column in your SharePoint list is a number column? If so, Microsoft Forms does not have a true number field. It saves numbers as strings. You need to use the expression builder to convert the string from MS forms to an int or float value.

For an integer: int(outputs('Get_response_details')?['body/YourFieldName'])

For a decimal number: float(outputs('Get_response_details')?['body/YourFieldName'])
When you use the expression builder, you will be able to get to the field from your MS Form in the dynamic content. It doesn't show it without using an expression since you cannot populate a number field in SharePoint with a string.

Was this reply helpful? Yes No
billf24 158 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the insight. Just weird that I have not had to do that before.

Was this reply helpful? Yes No