cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
octaking
Helper V
Helper V

Formula with delegation

How can I apply this formula without giving me a delegation?

 

68716652_467055983873774_4623692200071397376_n.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @octaking ,

Currently, the nested LookUp formula could not be delegated withn Filter function. As an alternative solution, please take a try with the following workaround:

Set the OnStart property of App to following:

 

Concurrent(
                 ClearCollect(SolicitudesCollection, Solicitudes_app),
                 Set(CurrentUserEmail, User().Email)
)

then modify your formula as below:

 

 

Filter(
         Approvals,
         LookUp(SolicitudesCollection, Id_app = Value(Label18_1.Text), Solicitante.Email) = CurrentUserEmail
)

then re-load your app (fire the OnStart property of the App control), then check if the issue is solved.

 

Note: Please also set the "Data row limits for Non-delegable queries" option to maximum value -- 2000 within Advanced settings of App settings of your app.

 

In addition, I think the filter condition (LookUp function) you specified in your Filter function does not make sense. The LoolUp(...) = User().Email filter condition would alwasys return true or false. So your Filter formula would looks like below:

Filter(Approvals, true)
Filter(Approvals, false)

The filter condition you specified within your Filter function should be related to columns in your Approvals Entity. The standard format as below:

Filter(Approvals, FilteredColumn = "A specific value")   /* <-- FilteredColumn is a column from your Approvals Entity */

 

Please take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-xida-msft
Community Support
Community Support

Hi @octaking ,

Currently, the nested LookUp formula could not be delegated withn Filter function. As an alternative solution, please take a try with the following workaround:

Set the OnStart property of App to following:

 

Concurrent(
                 ClearCollect(SolicitudesCollection, Solicitudes_app),
                 Set(CurrentUserEmail, User().Email)
)

then modify your formula as below:

 

 

Filter(
         Approvals,
         LookUp(SolicitudesCollection, Id_app = Value(Label18_1.Text), Solicitante.Email) = CurrentUserEmail
)

then re-load your app (fire the OnStart property of the App control), then check if the issue is solved.

 

Note: Please also set the "Data row limits for Non-delegable queries" option to maximum value -- 2000 within Advanced settings of App settings of your app.

 

In addition, I think the filter condition (LookUp function) you specified in your Filter function does not make sense. The LoolUp(...) = User().Email filter condition would alwasys return true or false. So your Filter formula would looks like below:

Filter(Approvals, true)
Filter(Approvals, false)

The filter condition you specified within your Filter function should be related to columns in your Approvals Entity. The standard format as below:

Filter(Approvals, FilteredColumn = "A specific value")   /* <-- FilteredColumn is a column from your Approvals Entity */

 

Please take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

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 (4,049)