"Rating" field from a Form to a SharePoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-131462%22%20slang%3D%22en-US%22%3E%22Rating%22%20field%20from%20a%20Form%20to%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131462%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20does%20one%20get%20a%20%22Rating%22%20field%20(using%20stars%20format)%20get%20pushed%20into%20a%20SharePoint%20list%20field%3F%20Using%20flow%20to%20push%20through%20the%20various%20fields%20of%20the%20form%2C%20but%20I%20can't%20find%20the%20right%20format%20for%20the%20SharePoint%20list%20field%20that%20needs%20to%20accept%20the%20%22Rating%22%20value.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-131462%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-805968%22%20slang%3D%22en-US%22%3ERe%3A%20%22Rating%22%20field%20from%20a%20Form%20to%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-805968%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F77002%22%20target%3D%22_blank%22%3E%40Stefanos%20Papadopoulos%3C%2FA%3Ehow%20did%20you%20get%20the%20forms%20to%20push%20a%20rating%20using%20flow%20to%20the%20sharepoint%20list.%26nbsp%3B%20I%20would%20like%20to%20know%20how.%26nbsp%3B%20I'm%20guessing%20my%20problem%20is%20the%20column%20datatype%20or%20definition%20in%20the%20list.%26nbsp%3B%20I%20have%20tried%20number%20-%20since%20the%20graphic%20stars%20will%20be%20the%20number.%26nbsp%3B%20But%20the%20dynamic%20content%20list%20doesn't%20show%20the%20form%20entry%20to%20map%20to%20the%20field%20-%20the%20list%20is%20empty%20aside%20from%20the%20form%20id.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-157917%22%20slang%3D%22en-US%22%3ERe%3A%20%22Rating%22%20field%20from%20a%20Form%20to%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-157917%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20There%2C%20would%20you%20mind%20sharing%20how%20you%20found%20this%3F%20I%20would%20also%20like%20to%20add%20rating%20to%20a%20custom%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131467%22%20slang%3D%22en-US%22%3ERe%3A%20%22Rating%22%20field%20from%20a%20Form%20to%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131467%22%20slang%3D%22en-US%22%3E%3CP%3EI%20figured%20it%20out%2C%20please%20ignore%20my%20question...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1227621%22%20slang%3D%22en-US%22%3ERe%3A%20%22Rating%22%20field%20from%20a%20Form%20to%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1227621%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F77002%22%20target%3D%22_blank%22%3E%40Stefanos%20Papadopoulos%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20for%20the%20people%20following%20the%20thread.%26nbsp%3B%20I%20had%20the%20same%20issue%20and%20was%20also%20disappointed%20that%20the%20solution%20was%20not%20provided.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20SharePoint%20list%20and%20the%20rating%20field%20was%20created%20as%20a%20Number%20field.%26nbsp%3B%20When%20mapping%20the%20response%20field%20to%20SharePoint%2C%20the%20only%20option%20available%20from%20Dynamic%20Content%20was%20the%20Response%20ID%20(which%20is%20an%20integer).%26nbsp%3B%20This%20tells%20me%20that%20the%20source%20field%20needs%20to%20be%20an%20integer.%26nbsp%3B%20When%20exporting%20to%20Excel%2C%20I%20noticed%20that%20the%20field%20type%20came%20across%20as%20%22General%22%20(Text%2FString).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20%22rating%22%20field%20from%20Forms%20is%20not%20provided%20when%20you%20try%20to%20map%20because%20it%20views%20it%20as%20Text%2FString%20so%20it%20has%20to%20be%20converted%20to%20a%20number.%26nbsp%3B%20After%20digging%2C%20I%20found%20a%20post%20that%20shows%20the%20Expression%20option%20(at%20the%20top%20of%20the%20Dynamic%20Content%20pane).%26nbsp%3B%20Click%20that%20and%20select%20the%20function%20INT().%26nbsp%3B%20Here%20is%20what%20is%20non-intuitive.%26nbsp%3B%20Click%20BACK%20on%20the%20Dynamic%20content%20link%20and%20ALL%20of%20your%20form%20fields%20are%20displayed.%26nbsp%3B%20Make%20sure%20your%20cursor%20is%20between%20the%20()%20and%20select%20your%20rating%20field.%26nbsp%3B%20Click%20OK%20and%20it%20will%20add%20the%20function%20to%20your%20form.%26nbsp%3B%20Works%20like%20a%20charm!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1752081%22%20slang%3D%22en-US%22%3ERe%3A%20%22Rating%22%20field%20from%20a%20Form%20to%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1752081%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20EXACTLY%20my%20problem%20-%20but%20you%20didn't%20provide%20the%20solution%20of%20how%20to%20fix%20it%20%3A(%3C%2Fimg%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20could%20shed%20some%20light%20on%20how%20you%20resolved%20it%2C%20users%20around%20the%20globe%20would%20be%20super%20thankful!%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F77002%22%20target%3D%22_blank%22%3E%40Stefanos%20Papadopoulos%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

How does one get a "Rating" field (using stars format) get pushed into a SharePoint list field? Using flow to push through the various fields of the form, but I can't find the right format for the SharePoint list field that needs to accept the "Rating" value.

5 Replies
Highlighted

I figured it out, please ignore my question...

Highlighted

HI There, would you mind sharing how you found this? I would also like to add rating to a custom list.

Highlighted

@Stefanos Papadopouloshow did you get the forms to push a rating using flow to the sharepoint list.  I would like to know how.  I'm guessing my problem is the column datatype or definition in the list.  I have tried number - since the graphic stars will be the number.  But the dynamic content list doesn't show the form entry to map to the field - the list is empty aside from the form id.

Highlighted

@Stefanos Papadopoulos 

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!

Highlighted

This is EXACTLY my problem - but you didn't provide the solution of how to fix it :( 

If you could shed some light on how you resolved it, users around the globe would be super thankful!

@Stefanos Papadopoulos