Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

The requested operation is invalid server response - filter formula

(0) ShareShare
ReportReport
Posted on by 892

I have had this app running for some time months and this formula has worked well for the same amount of period. But today it gives me an error. It also only sometimes gives me an error. I reload it and it is fine, then all of a sudden it gives an error.

 

the requested operation is invalid. Server response: Progress candidate failed: Expression expected at position 154 in 'filter((key_progCand/key_candidatesid eq 49sdfh4873443ds334sds34 or key_progCand/key_candidatesid eq d4d24d-23sdf-34-d343-34 or ))/aggregate($count as result)

 

the formula is this:

Screenshot 2022-10-20 100634.jpg

 

colBookings is a collection where I have two records listed. Progress candidates is a dataverse table. 

 

TO give you an idea what it is for, I use it create a progress bar to showcase how far all students have progressed a course combined.

Screenshot 2022-10-20 101136.jpg

Thanks for your help!

  • Gyllentid Profile Picture
    892 on at
    Re: The requested operation is invalid server response - filter formula

    Microsoft Support couldn't tell what the issue was either. I solved it by rebuilding it into collections.

  • Gyllentid Profile Picture
    892 on at
    Re: The requested operation is invalid server response - filter formula

    It's popping up on more places in the app... I wonder if this is some bug...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard