cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
YamiteKudasai
Helper IV
Helper IV

Delegation Sharepoint ID based on Collection ID

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! 

1 ACCEPTED SOLUTION

Accepted Solutions
BCBuizer
Super User
Super User

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



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

View solution in original post

3 REPLIES 3
BCBuizer
Super User
Super User

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.



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Yes this is a lookup column.

BCBuizer
Super User
Super User

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



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,885)