Solved: How do I save data from an "opinion" field to a Sharepoint item?

Hi there,

I am pretty new to PowerApps and not really a programmer, but I do have a lot of experience from working with data in a lot of ways. Right now I am building a Project Management application for our project portfolio.

I would like to have an "opinion" field, you know the one with stars representing a numeric value, in this case from 1 to 4, and then I want to store the data in a numeric field in Sharepoint. I have figured out how to set the value from the Sharepoint field as "default", but I don't know how to store the new data if the user changes the number of stars.

I suppose it's quite simple, but I would appreciate if someone could help me.

Regards

Lennart

Hi @LennartWalldén ,

Could you please share a screenshot about your app's configuration?
How do you submit your data back to your SP List? Using SubmitForm function or Patch function?

I assume that you add a Rating control in your app, and want to save this "Rating" value back to your SP List, is that true?

If you want to save the new "Rating" value back to your SP List, I think the Patch function could achieve your needs. Please consider set the OnSelect property of the "Save" button to following:

Patch(
 'SP List',
 LookUp('SP List', PrimaryKeyColumn = "Specific value"), // find the reocrd you want to update in your SP List
 {
 RatingNumberField: Rating1.Value
 }
)

Note: The PrimaryKeyColumn represents the column in SP List, which could identify one record uniquely. Rating1 represents the Rating control.

If you use SubmitForm function to submit your data back to your SP List, you could consider enable the RatingNumberField within your Edit form, then change the Control Type from normal TextInput box into "Edit rating" as below: