List Indexing

[Tono_Analyst]

Hi!

I am trying to pull the first item from a SharePoint List in a specific column. 

First(Source).Column

However, I get a delegation warning. 

Is there a way to reference the first item in a table without getting this warning? I have considered using a lookup, but want to avoid hard coding a lookup value, as it may not exist in the SharePoint List in the future.

Thank you!

[WarrenBelz · Accepted solution]

Hi @Tono_Analyst ,

Yes - like this

With(
   {
      wList:
      Sort(      
         SPListName,
         ID
      )
   },
   First(wList).Column
)

Also,  although First() is not Delegable, your code would work.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.