Forum Discussion
"Rating" field from a Form to a SharePoint List
This is for the people following the thread. I had the same issue and was also disappointed that the solution was not provided.
I created a SharePoint list and the rating field was created as a Number field. When mapping the response field to SharePoint, the only option available from Dynamic Content was the Response ID (which is an integer). This tells me that the source field needs to be an integer. When exporting to Excel, I noticed that the field type came across as "General" (Text/String).
The "rating" field from Forms is not provided when you try to map because it views it as Text/String so it has to be converted to a number. After digging, I found a post that shows the Expression option (at the top of the Dynamic Content pane). Click that and select the function INT(). Here is what is non-intuitive. Click BACK on the Dynamic content link and ALL of your form fields are displayed. Make sure your cursor is between the () and select your rating field. Click OK and it will add the function to your form. Works like a charm!