Linking Control to SharePoint List

N

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.

 

 

2 replies

K
Userlevel 3
Badge +12

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”).


 

ghaiashish
Userlevel 2

Is ApprovedContractor a numeric field?

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings