Delegation Sharepoint ID based on Collection ID

(0) Share

Report

Posted on by YamiteKudasai

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
YamiteKudasai 195 on at

Like (0)

Report

Yes this is a lookup column.

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No