You’re offline. This is a read only version of the page.
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 -
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.
Share
Report
All responses (
Answers (Plant_x002f_EquipmentID
Best Regards,
Sunshine Gu
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
Hi @SayandSajith1 ,
Which column in another list is the reference column of your lookup column?
Best Regards,
Sunshine Gu
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
Hi @SayandSajith1 ,
Can you show me a screenshot of the SharePoint list that your flow is involved in?
Best Regards，
Sunshine
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.
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:
My Flow:
Best Regards,
Sunshine Gu
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
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
