Lookup Function to pull value from external list

  • 16 February 2024
  • 1 reply

Userlevel 1
Badge +9


I am having an extremely difficult time trying to pull a value from an external list to populate a field. I need to pull a value from the “SPS Security Group” column and cannot seem to get that value.

The columns in my main form are as such…


And the columns from my external list are as such:



I need the value from the SPS Security Group column once the Title in the main list equals the title in the external list  but not sure if I’m doing this right… I use the below: 

lookup("My External List Name","Title","Title","SPS Security Group")


Best answer by jpacheco 19 February 2024, 17:37

View original

1 reply

Userlevel 1
Badge +9

I have finally figured out how to grab the groups I need and have listed in the external list within the “Office 365 update item permissions” control. This is no longer an issue,