Unanswered

using FLOW to load value from field created in FORMS , to sharepoint list in calculated

(0) Share

Report

Posted on by felicini

I have created a new FORMS "new request forms" and I have add some field like "title" and "department" I have then created a new sharepoint list and add several columns and one of them is a column Departments (add from eisting column site (*) ) , (*) the columns Departmens was create in SITE SETTINGS >> WEB DESIGN GALLERY>>SITE COLUMN as Lookup (information already on this site) , that retreive the information forma another list of department and responsible not I am not able with Flow to assigne the value fill on th eform to sahrepoint list that is an existing column and have the property lookup. any suggestion?

All responses (2)

Answers (0)

yashag2255 24,442 Super User 2024 Season 1 on at

Like (0)

Report

Re: using FLOW to load value from field created in FORMS , to sharepoint list in calculated

Hi @felicini

The way lookups work in SharePoint is that you reference the lookup field to the ID of the field of the other list. So let us assume that I have a list Course and this has a column Department. I have another List Person and here I have to lookup to the course based on the department. So in the person, the column department will refer to the item ID of the department in the List Course.

In forms, you just get the label and so to refer that to lookup you first have to get the relevant item.

Please see the screenshot below and replicate:

Here, Get Items action will just return one item as my department is unique value.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report

Re: using FLOW to load value from field created in FORMS , to sharepoint list in calculated

@felicini

The issue you are experiencing is due to the fact that a SharePoint lookup column actually stores the ID of the item from the lookup list. To make your scenario work, you'll first need to use a GetItems action to retrieve the list item from the lookup list that matches the selected option. You'll use the ID of that item when creating the new list item.

I answered this exact question a couple of weeks ago - here is a link to a solution to your issue.