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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Delegation Sharepoint ...
Power Apps
Answered

Delegation Sharepoint ID based on Collection ID

(0) ShareShare
ReportReport
Posted on by 195

Hi Everyone, 

 

Good day! 

 

I just need some help on delegation error encountered. I have a sharepoint clearcollect from a list.

then I'm filtering it based on the collection id.

code below: 

/*first collection */
ClearCollect(
 colUserRequests, 
 Filter(
 'SIMPL List', 
 'Created By'.Email = gvCurrentUserEmail
 )
);

/* second collection with delegation */
ClearCollect(
 colRequestContactApprovers, 
 Sort(
 Filter(
 'Contact Assigned Status',
 Request.Id = colUserRequests[@ID]
 )
 )
); 

The delegation was in Request.Id = coluserRequests[@ID].

Thanks in advance for your help guys! 

Categories:
I have the same question (0)
  • BCBuizer Profile Picture
    22,563 Super User 2026 Season 1 on at

    Hi @YamiteKudasai ,

     

    What is the column type of 'Contact Assigned Status'.Request?

     

    If this is a LookUp, the issue in the fact that only the .Value column is delegable. This is something that can be overcome by setting the ID column of the SIMPL list as the primary field in the LookUp column in the 'Contact Assigned Status' list in SharePoint. Like that, Request.Value actually holds the ID values in the same way as the Requests.Id column, with the difference that it is delegable.

  • YamiteKudasai Profile Picture
    195 on at

    Yes this is a lookup column.

  • Verified answer
    BCBuizer Profile Picture
    22,563 Super User 2026 Season 1 on at

    Hi @YamiteKudasai ,

     

    In that case, the workaround to get delegation to work can be found in the post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Why-i-got-2-columns-inside-out-Power-Apps-which-represents-a/m-p/1727768/highlight/true#M439572

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard