You’re offline. This is a read only version of the page.
438
By all the rules, that relational lookup should not be Delegable - I am also still confused about the structure of 'L-Grade' and why it was failing at some times and showing delegation issue on others.
I also see now you have posted that it does not work.
@WarrenBelz, hi good evening. i trying do myself and made it to solved. here is my formulas:
Filter(
'Class of 20XX Fundraising Items',
LookUp(
'Class of 20XX (Officers)',
'L-Grade'.Value = LookUp(
'Class of 20XX (Officers)',
'Head Sponsor' = User().FullName ||
'Sponsor 1' = User().FullName ||
'Sponsor 2' = User().FullName,
'L-Grade'
).Value,
'L-Grade'.Value
) = 'L-Grade'.Value
)
Sorry I have exhaused all possible Delegation options - you will have to manage it as non-Delegable
Sometime I see is not right here. But I trying to copy and paste then delegation warning:
Something is not right here - if both fields are single choices, they should match - also you should not get a Delegation warning. Another variation
Share
Report
All responses (
Answers (
With(
{
_Sponsor:
LookUp(
'Class of 20XX (Officers)',
'Head Sponsor' = User().FullName
).'L-Grade'
},
Sort(
Filter(
'DHS Student Users',
'L-Grade'.Value = _Sponsor.Value
),
'Student Name'
)
)Copy and paste, and warning back to error message again. See screenshot.
A bit strange - you can try it this way
With(
{
_Sponsor:
LookUp(
'Class of 20XX (Officers)',
'Head Sponsor' = User().FullName
).'L-Grade'.Value
},
Sort(
Filter(
'DHS Student Users',
'L-Grade'.Value = _Sponsor
),
'Student Name'
)
)@WarrenBelz, I found the solution. I just added it to 'DHS Students Users' Now it's better, and no errors are displayed; we still have a warning message, though.
There is somehting wrong with one of your references as the structure is correct. There is a line under 'DHS Student Users', so maybe that is not the correct name.
Ok I got it! You correct that L-Grade is a single choice choice column, and Head Sponsor is a text field. It's still something error in red box. Otherwise, green box is worked. 🙂
#1
WarrenBelz
146,605
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
