Populating SharePoint Lookup Column from MS Forms

[Anonymous]

Hi

I'm using MS Forms to Capture input from the users. One of the inputs that I capture from the user in MS Forms is "Demo System".

To store my data, I'm using SharePoint List. In my SharePoint List, the column "Demo System" is a lookup field that gets other details from other SharePoint list (it has the equipment name, picture, location ...etc).

Here is my challenge:

I created a flow to get the info from submitted MS Form to populate my SharePoint list. But when I try to populate the "Demo System" Column, I get an error message: 

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

Now how can I overcome this?

SharePoint Columns Config

Flow Setup showing the field with issue (in fact all lookup fields have the same issue)

Error message:

One a side note, I have a column that is set as LOCATION, it doesn't show at all in MS Flow. Not sure if this is working as designed or it's a bug.

[v-LilyW-msft · Accepted solution]

Hi @Anonymous 

Thank you for your posting.

According to your description, you want to create a flow to get the info from submitted MS Form to populate your SharePoint list.

I tried to reproduce your scenario and it works fine for me.

You can refer to as below:

This filter query is used to check whether the value of the column of original list (which the lookup item value comes from originally) is equal to the data from MS Forms that can be used to feed into the lookup column.

This is my SharePoint list which has the equipment name, picture, location

When a new response is submitted as below:

The new item will be created:

Hope the content above may help you.

Best Regards

Lily

[Anonymous · Accepted solution]

Great

This works. Thank you very much.

[Anonymous]

Hi - i followed these steps and it really helped me.

I am trying to update the created item's status to Completed. But the only ID that I can select is from the Get Item action, nothing from the Create item. Maybe I am missing something. Hoping you can help me. Thank you

[Theolsenfamily]

I am trying to replicate this instruction given here but I cannot figure out for the life of me how to recreate this expression in this box... Please send help!  

[Theolsenfamily]

Ok I am going to step back and explain what I am trying to do.

I have New Form Response Data that I am using power automate to create an item with.  Essentially it populates a list on a sharepoint site.  I have no trouble bringing this response data into the list.  What I am having difficulty with is one of the columns in the list is a look up column to a separate list where additional information related to the form response answers can be pulled in. I have made sure that the Form Choice Questions, responses match the title column of the list I want to pull additional information in from. So in theory when a persons response from the form is brought in I would love for it to drop into the lookup column and bring back this information to the list.  I can get it to work manually.  Meaning if I take the response from the question and paste it into the look up column (Edit Grid View) the look up works and it pulls the additional columns in.  What I am really struggling with is getting power automate  to do this for me when a new response comes in.