Skip to main content
Nintex Community Menu Bar

Linking Control to SharePoint List

  • June 15, 2021
  • 2 replies
  • 4 views
  • Translate

I'm trying to connect a control to display the data found in the column of a sharepoint list. At first, the box was displaying Loading... and now it's showing Overflow.

 

This is the formula that I am using:

lookup("Tracking", "ID", ApprovedContractor, "Contractor Name")

 

  • Tracking is the name of the Sharepoint List
  • ID - (I saw this listed in other solutions)
  • Approved Contractor: The named control
  • Contractor Name: The column that has the info that I want from the Sharepoint list.

 

 

Did this topic help you find an answer to your question?

2 replies

Forum|alt.badge.img+12
  • Apprentice
  • 292 replies
  • June 16, 2021

Hi,

Here is how the lookup function works - lookup(“ListA”, “ID”, 1, “Title”)

The above function queries "ListA" for item with "ID" equals "1" and show the value from "Tilte" column.

So update your forumla as required, lookup(“listname”, “column to filter on”, "condition", “column to output”).

 

Translate

ghaiashish

Is ApprovedContractor a numeric field?

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings