cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
johnjohn123
Post Prodigy
Post Prodigy

Delegation error on this formula "First(Filter('Mobile Devices',PhoneAndColour=DataCardValue37.Selected.PhoneAndColour)).NewCost"

I have a SharePoint list named "Mobile Devices", and i want to filter it based on a column of type Calculated Column named PhoneAndColour, but i am getting a delegation error:-

 

 

First(Filter('Mobile Devices',PhoneAndColour=DataCardValue37.Selected.PhoneAndColour)).NewCost

 

 

filter.png

 

 

so is there a way to fix this? or we can not filter based on calculated columns?

 

Second question, now the Mobile Devices has a column of type true/false named Available, so we only want the search to be based on the items which have the Available value = true.. so could this help in fixing the delegation warning we are getting?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
StalinPonnusamy
Community Champion
Community Champion

Hi @johnjohn123 

 

Please try this. 

With({_Item:'Mobile Devices'},
First(Filter(_Item, Available && PhoneAndColour=DataCardValue37.Selected.PhoneAndColour)).NewCost
)

 

 


Thanks,
Stalin

Learn To Illuminate

View solution in original post

1 REPLY 1
StalinPonnusamy
Community Champion
Community Champion

Hi @johnjohn123 

 

Please try this. 

With({_Item:'Mobile Devices'},
First(Filter(_Item, Available && PhoneAndColour=DataCardValue37.Selected.PhoneAndColour)).NewCost
)

 

 


Thanks,
Stalin

Learn To Illuminate

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (994)