Answered

CountRows The data returned by the service is invalid

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for the advice, this seems to have worked!

Was this reply helpful? Yes No