cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
neds Advocate II
Advocate II

Form Dynamic Content missing for Number Fields from form into number fields for Sharepoint Create It

I am having a similar, but not complete problem.  I am already using the Get Response Details Action.  My issue only appears with Number Fields in the Form.  The Dynamic content for number fields was working up until 3 days ago, now, the flow fails and I can't seem to access the dynamic content from ONLY the number fields of the MSFT Form response beyond the item ID.  All other fields still work and are available in the dynamic content.  You can see this below.  The matching Sharepoint List item fields have not changed, and you can actually see that in the Flow the filed used to be available (hilighted) but no longer is. Only the response ID.  The image on the left is a text field and all Dynamic Fields are available. Image on the right is from a number field (same for all number fields) and no dynamic content is available as of 3 days ago.Capture.JPGCapture2.JPG

2 REPLIES 2
Community Support
Community Support

Re: Form Dynamic Content missing for Number Fields from form into number fields for Sharepoint Creat

Hi @neds,

 

What’s the type of anticipated size in Microsoft Forms? I assume that it is of type Text. While in the SharePoint list, the column Anticipated size of round is of type number.

 

If yes, in the action Create item, we are asked to enter a value of type Number. If their types don't match, then there is no dynamic content can be selected.

 

For your scenario, please try to convert the string to integer and use its output for the Anticipated sise of round field.

 

Please check the following screenshot for a reference:

 

The code use in the Compose is:

int(body('Get_response_details')?['r935288ce6e884c21ac87755d0b131a38'])

1.PNG

 

More details for your sencenario:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#i...

 

 

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
neds Advocate II
Advocate II

Re: Form Dynamic Content missing for Number Fields from form into number fields for Sharepoint Creat

Thanks Mabel - but the Microsoft Form Field type is Number - i've checked this like a hundred times!   That's why it doesn't make sense.   And it used to work fine until a few days ago, but nothing changed in the Flow or Sharepoint list structures.  It just started failing and when i went to check why, the dynamic number fileds were no longer available from the MSFT Form.  I am only having this issue for number fields, but it is ALL number fields coming out of the MSFT Form (I have about 4) and they all used to work.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Users online (6,438)