Answered

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

(0) Share

Report

Posted on by SayandSajith1

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 List form -

Flow to get response from MS forms to SharePoint list -

Categories:

Business Process Flows

Screenshot 2024-0...

All responses (9)

Answers (1)

v-yetonggu-msft on at

Like (0)

Report

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

Hi @SayandSajith1 ，
Could you please tell me the name of your list?
Best Regards,
Sunshine Gu
v-yetonggu-msft on at

Like (0)

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

Hi @SayandSajith1 ,
Change the list name in your 'get items' control to the referenced list name,
and change 'Title' to 'Plant_x002f_EquipmentID' referenced by the lookup.

Plant_x002f_EquipmentID

Best Regards,
Sunshine Gu
SayandSajith1 26 on at

Like (0)

Report

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

I have a different list where I store information of equipment's and is looking up the Plant/Equipment ID column from the below list
v-yetonggu-msft on at

Like (0)

Report

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

Hi @SayandSajith1 ,
Which column in another list is the reference column of your lookup column?
Best Regards,
Sunshine Gu
SayandSajith1 26 on at

Like (0)

Report

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

Here you go -
This is the SharePoint form which I replicated on MS form so the Guest users who does not have access to the site can put entries into SharePoint list
v-yetonggu-msft on at

Like (0)

Report

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

Hi @SayandSajith1 ,
Can you show me a screenshot of the SharePoint list that your flow is involved in?
Best Regards，
Sunshine
SayandSajith1 26 on at

Like (0)

Report

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

Thanks Sunshine, the flow is successful without errors. However, the data doesn't seem to the pass the information from the MS form to a SharePoint list item.
Verified answer

v-yetonggu-msft on at

Like (0)

Report

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

Hi @SayandSajith1 ，
I did a test for your reference.
In my scenario:
My SharePoint List1:
My SharePoint List2:
My MS Form:
I think this link will be helpful to you:
Solved: On Create Item, tying to automate lookup value ent... - Power Platform Community (microsoft.com)
My Flow:

Best Regards,
Sunshine Gu
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report

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

Hi @SayandSajith1

You need to use filter query in "Get items" to get a list item from the lookup list based on the value in form response. In create item action, pass the ID of the lookup list item in the main list where all MS responses values are stored.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks