Delegation Sharepoint ID based on Collection ID

[YamiteKudasai]

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! 

[BCBuizer]

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]

Yes this is a lookup column.

[BCBuizer · Accepted solution]

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-wh...