Answered

CountRows The data returned by the service is invalid

Like (0) Share

Report

Posted on 12 Jul 2020 21:00:18 by Community Power Pla...

Hi there,

I have a couple of CDS entities which I'm using to supply Power Apps. When I use the CountRows function I get an error advising "The data returned by the service is invalid". There are currently only 3 rows in the table so its not a delegation issue.

To troubleshoot, I have added the following to the Default Value of a Text Box which fails:

CountRows('Houses')

With Houses being the name of the Entity.

This works when I point to Entities which are auto generated by Power Apps, but does not work for my custom entities.

Your help is much appreciated.

Richard

Categories:

Entities

All responses (2)

Answers (1)

Community Power Pla... on 13 Jul 2020 at 05:34:10

Like (0)

Report

Re: CountRows The data returned by the service is invalid

Thanks for the advice, this seems to have worked!
Verified answer

EricRegnier 8,714 Most Valuable Professional on 12 Jul 2020 at 21:38:43

Like (0)

Report

Re: CountRows The data returned by the service is invalid

Hi @Anonymous,
Seems like your missing privileges on those custom entities. You'll need to edit an existing security role (or create a new one) to grant privilege on those entities. Make sure you edit the role(s) that are assigned on the user that is used in the CDS Connector.
Cheers