im trying to insert my MS form content to a list on sharepoint using a flow and im getting this error:
Input parameter 'item/sddd' is required to be of type 'Number/double'. The runtime value '"rdf"' to be converted doesn't have the expected format 'Number/double'.
I dont know what does it means "Item/sddd". the only numeric value i have on my form is the date which i created the column on my list of date/time type (even changed it to text and tested same error occurred)
grateful if any one could help to solve it
Can you share a screenshot from:
-your current flow design, so we can see 'Create item' input details ?
-your sharepoint list column config?
It looks like your 'get response details' is inside an 'Apply to each, right?
If so, your flow is inplemented in the old fashioned way. Please have a look to this topic and see if you can redesign your flow without the 'apply to each'
Hope this helps
i've been looking into this issue recently. Some how the flow passing a null value to Sharepoint from blank fields in Forms.
The problem could be fix by edit the Sharepoint column from Number to Single line of text.
For now i'm not sure if this is by design or bug but we need to take more action on it.
Assuming you can assign a default numeric value if empty response is received from Forms, coalesce() WDL function should do the trick
Hope this helps
Check out how to claim yours today!
Check out new user group experience and if you are a leader please create your group
Test your skills now with the Cloud Skill Challenge.