The requested operation is invalid. server response: The expression is invalid

(0) Share

Report

Posted on by CNT

10,921 Super User 2024 Season 1

I am getting the following Error while loading some data from CDS. Here People is the name of the Entity

The requested operation is invalid. Server response: People failed: The expression is invalid

Any help would be much appreciated.

Thanks.

Categories:

Building Power Apps

All responses (16)

Answers (1)

Sort by

KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CNT ,

May I know how you are reading the entity, could you share me the formula.
Check the below article for People or group field in CDS:
People or Group Field in CDS

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KrishnaV
the link you had sent is not working. Could you please check it. Thanks.
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@KrishnaV
The following formula works fine
Collect(colPeople,Filter([@People], 'Primary Faith Home'.'Faith Home' = ddnFaithHome.Selected.'Faith Home'));

When I add more conditions like below it throws the error
Collect(colPeople,Filter([@People], Or('Primary Faith Home'.'Faith Home' = ddnFaithHome.Selected.'Faith Home', 'Secondary Faith Home'.'Faith Home' = ddnFaithHome.Selected.'Faith Home')));
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

See the below thread on the same:
https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/People-Picker-for-CDS/td-p/161919

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CNT ,

Try this:
Collect(colPeople,Filter([@People], ('Primary Faith Home'.'Faith Home' = ddnFaithHome.Selected.'Faith Home' || 'Secondary Faith Home'.'Faith Home' = ddnFaithHome.Selected.'Faith Home')));

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KrishnaV
I tried that. It works for a while and suddenly throws the same error. Strange!
KrishnaV 5,023 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CNT ,

May I know the error what you see, would you mind send me error screenshot to help you better.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KrishnaV Attached a screenshot
KrishnaV 5,023 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @CNT ,

Can you try this:
Logout from make.powerapps.com
Close all the active browsers
sign-in back to make.powerapps.com

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CNT :
Could you check if the following code reports an error?

Collect(colPeople,Filter([@People], 'Secondary Faith Home'.'Faith Home' = ddnFaithHome.Selected.'Faith Home'));

Could you tell me :
What are'Primary Faith Home' and'Secondary Faith Home'? How are they set up? What the difference between them?
What is ddnFaithHome's items property?
Best Regards,
Bof