web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Why i got 2 columns in...
Power Apps
Answered

Why i got 2 columns inside out Power Apps which represents a sharepoint lookup field

(0) ShareShare
ReportReport
Posted on by johnjohn123 3,514

We have the following SharePoint lookup field named large:-

 

johnjohn123_0-1661006875035.png

 

and when i added the list, i got 2 fields which represent the SharePoint lookup field, as follow:-

 

johnjohn123_1-1661006929653.png

 

and i can get the lookup id by using any of these formulas:-

 

LookUp(testtestlist,large.Id=9)

LookUp(testtestlist,'large: ID'.Id=9)

 

so any advice why we got 2 identical fields?

 

Categories:
Building Power Apps
I have the same question (0)
  • BCBuizer Profile Picture
    BCBuizer 22,844 Super User 2026 Season 2 on at

    Hi @johnjohn123 ,

     

    Because you selected the ID column to be shown as an additional field in SharePoint:

     

    BCBuizer_0-1661009701356.png

     

  • johnjohn123 Profile Picture
    johnjohn123 3,514 on at

    so at the end those 2 formulas

    LookUp(testtestlist,large.Id=9)

    LookUp(testtestlist,'large: ID'.Id=9)

    are exactly the same?

     

    Second question, are both search not deligable ?

    @BCBuizer

  • BCBuizer Profile Picture
    BCBuizer 22,844 Super User 2026 Season 2 on at

    Hi @johnjohn123 ,

     

    Both formulas will return the same items since the Id will be common across both columns. If you were to look for the Value, that's different, since 'large' has the values for large123.Title and 'large: ID' has the values for large123.ID.

     

    Indeed both are not delegable, but can be made to be as described in this topic: https://powerusers.microsoft.com/t5/Building-Power-Apps/Nested-Gallery-Filtering-with-complex-columns/td-p/1493975

     

    LookUp(
 AddColumns(
 testtestlist,
 "LargeId",
 large.Id
 ),
 LargeId=9
)
  • johnjohn123 Profile Picture
    johnjohn123 3,514 on at

    @BCBuizer thanks.. so you mean , SharePoint lookups can be delegable ? i always get an advice in this forum not to use sharepoint lookup because they are not delegable, and we are always adviced to store the id as a single line of text instead of using sharepoint lookup fields...

  • BCBuizer Profile Picture
    BCBuizer 22,844 Super User 2026 Season 2 on at

    Hi @johnjohn123,

     

    The formula I posted made the delegation warning go away and there are quite some tutorials out there that are promoting this method as a way of dealing with delegation issues, but it seems for LookUp columns this does not work.

     

    I did some tests and what seems to work is to look for the primary key value. With the below settings in Sharepoint for the 'LookUp" column, I got different results for different formulas:

    BCBuizer_3-1661029076947.png

     

    Filter(TEST, 'LookUp'.Value="") No delegation warning, shows more items than the Data Row Limit
    Filter(TEST, 'LookUp'.Id="") Delegation warning, limited by the Data Row Limit
    Filter(TEST, 'LookUp:ID'.Value="") Delegation warning, limited by the Data Row Limit
    Filter(TEST, 'LookUp:ID'.Value="") Delegation warning, limited by the Data Row Limit

     

    I then changed the SharePoint settings and ran similar tests:

    BCBuizer_1-1661028585207.png

     

    Filter(TEST, 'LookUp'.Value="") No delegation warning, shows more items than the Data Row Limit
    Filter(TEST, 'LookUp'.Id="") Delegation warning, limited by the Data Row Limit
    Filter(TEST, 'LookUp:Title'.Value="") Delegation warning, limited by the Data Row Limit
    Filter(TEST, 'LookUp:Title'.Id="") Delegation warning, limited by the Data Row Limit

     

    My conclusion is that on LookUp type columns, you can have a delegable filter on the primary key value, not the Id, nor on the value or Id of an additional column. The workaround with AddColumns makes the delegation warning go away, but not the delegation issue.

     

    Ps. Yes I did actually fill out values in the formulas to make sure items were targeted that should be excluded if the Data Row Limit applied.

  • johnjohn123 Profile Picture
    johnjohn123 3,514 on at

    @BCBuizer so what is the idfferent between primary key and Id are not they the same? which is the id? can you collaborate more please?

  • BCBuizer Profile Picture
    BCBuizer 22,844 Super User 2026 Season 2 on at

    Hi @johnjohn123 ,

     

    In case you set the ID column as the primary key, the value and Id will match:

     

    BCBuizer_0-1661066906729.png

     

    This means you can filter for that information in a delegable way.

  • johnjohn123 Profile Picture
    johnjohn123 3,514 on at

    @BCBuizer thanks for the great info. i always thought that SharePoint Lookups are not deligable ... and that we should/prefer to store the lookup id in a numeric field.. but i think ThisItem will not raise any delegation error unlike using Lookup

  • johnjohn123 Profile Picture
    johnjohn123 3,514 on at

    @BCBuizer I am not sure if your conclusion is correct, because i modified the SharePoint lookup as follow:-

    johnjohn123_1-1661089307558.png

     

     

    and when i try to do this lookup i got a delegation error:-

     

    johnjohn123_0-1661089264597.png

  • BCBuizer Profile Picture
    BCBuizer 22,844 Super User 2026 Season 2 on at

    @johnjohn123m,

     

    Have you refreshed your datasource after making the changes?

     

    Edit: Change from large.Id to large.Value

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#2
11manish Profile Picture

11manish 207 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 177

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans