Unanswered

RATINGS

(0) Share

Report

Posted on by CU09091727-0

Hi all

Ratings just do not seem to want to work when using Power Automate to collect Forms responses and add them to a SharePoint List.

I've tried multiple different codes and methods and it just will not show the rating given on the Form in Star rating.

My test rating of 3 will either give an output of "3" or [ 1, 2, 3 ] ..................neither of which seems to work!

Can anyone help?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

HI

When you say neither of which seems to work, what error message do you get, if any?

[1, 2, 3 ] seems to be a multi select choice?

Please examine and share your Forms runtime output:

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
CU09091727-0 76 on at

Like (0)

Report

@Ellis Karim

It shows the raw inputs as...........

And the error message that comes up is the

"status": 400,

"message": "Item could not be created. Check if input is valid.

When I said about the [ 1, 2, 3 ] response, that was when I tried to use Compose and Select functions to change the outputs, but that didn't work.

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Can you share more of the flow, including any configured actions and their properties.

(1) Can you examine the output from the Get response details action. You should be able to see the rating question and value:

(2) Add simple compose action after the Get response details action to perform your calculation:

(3) The Create Item action - the output does not look right here. It looks as if the SharePoint list was changed (new columns added, old columns deleted??). You may need to delete the Create Items action and re-add it. Or is the output from a Dataverse action? I'm not sure, so I would need to see the entire flow.

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
CU09091727-0 76 on at

Like (1)

Report

@Ellis Karim

This is what shows in the 'Get responses' output. I've highlighted the row showing the rating......

    "body": {
        "responder": (Shows the email of the person who submitted the form)
        "submitDate": "5/21/2025 4:26:02 PM",
        "ra9144d80e892498a9e40363f23969930": "",
        "r1179937ef92144659d3165f977e0ca27": "Not very successful",
        "r959183f89ced434cbcb2f873c00e79f8": "The product didn’t have the desired impact                 ",
        "r82ca3485013044c2a6b5427224f1827e": "TEST",
        "r6a1c68abea71402880d9ce49a44b2244": "3",
        "r709754efdc67448f8ead5b0ee5655630": "YouTube",
        "r6bc35250a3024f66bee2279be4eed5d2": "TEST",
        "r73c88e6d4fe147abba07b3ef668237b7": "TEST",
        "r575eea0f338f4a9c9dcaef728a60d4c5": "",
        "r405f0a5ab2334d0eb45762334828d9e0": "[\"To reduce call demand\",\"To promote new guidance / legislation change\",\"Other\"]"
    }
}

I also added the Compose section with the calculation suggested (substituting my ratings of r6a1c68abea71402880d9ce49a44b2244 in the correct place) and it shows the output for that as just............

3

(see image below)

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report
So far, so good.

Can you please share

the full text of the error message

the full details of the SharePoint Create items action

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
CU09091727-0 76 on at

Like (0)

Report

Error message:

Item could not be created. Check if input is valid.
clientRequestId: ee637e87-3f46-4e39-aa36-1e0aa9344014
serviceRequestId: f4a5a0a1-a0d8-c000-daa5-4f167a673fc0

{

"status": 400,

"message": "Item could not be created. Check if input is valid.\r\nclientRequestId: ee637e87-3f46-4e39-aa36-1e0aa9344014\r\nserviceRequestId: f4a5a0a1-a0d8-c000-daa5-4f167a673fc0"

}

'Body' on the User ratings section is just the output of the Compose element with the code you advised

int(.....

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

It's not clear why this error is happening.

If there was a mismatch between the SharePoint column type (e.g. Date type) and the forms data (the responder sent text "sdsdfsd , which is not a date), then we would expect to see a meaning error message. For example,

Action 'Create_item' failed: The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/EndDate' is required to be of type 'String/date-time'. The runtime value '"sdsdfsdf"' to be converted doesn't have the expected format 'String/date-time'.

But you aren't getting a helpful error message.

(1) Test: please hard code the number 3 into the create action, as shown below, and run the flow. I suspect it will still fail. If this is the case, the issue lies elsewhere, with one of the other columns?

(2) Can you please share the entire flow. I note that there is an apply to each loop in the flow, and the current item property is being used in the create item action.

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
CU09091727-0 76 on at

Like (0)

Report

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU09091727-0,

What was the runtime output when you hardcoded the number 3 into the User Rating?

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No