Power Automate flow to push MS Forms data into SharePoint list column that is a lookup list

Question

Hi,

I'm trying to push the data from a Microsoft Forms submission to a SharePoint list. The specific data I'm trying to transfer is a string value intended for a column in the SharePoint list, which is configured as a lookup list with string values.

I'm need some guidance on how to change the the format from integer to string for passing the information. Any advice on how to accomplish this would be greatly appreciated.

The error - The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/EquipmentID/Id' is required to be of type 'Integer/int64'. The runtime value '"Toyota Forklift"' to be converted doesn't have the expected format 'Integer/int64'.

MS form -

SharePoint form -

Flow to get response from MS forms to SharePoint list -

Answer 1

Dear Sayand,

Good day! Thank you for posting your query in our community.

Based on your description, you encountered when creating a Power Automate flow.

However, I’d explain that, because this problem is related to Microsoft Power Automate, I found threads which has the similar query with you in Microsoft Power Automate Community, such as: Solved: The 'inputs.parameters' of workflow operation 'Cre... - Power Platform Community (microsoft.com), Solved: The 'inputs.parameters' of workflow operation 'Cre... - Power Platform Community (microsoft.com).

So my suggestion is to post on dedicated Microsoft Power Automate Community, the members and engineers in this community are more experienced in this area. You will get a more detailed and professional answer to your problem there.

We appreciate your understanding.

Sincerely,

Jazlyn | Microsoft Community Moderator

Answer 2

Noted! Will post on the Power Automate community. Thanks Jazlyn.