Custom Page :: Query D365 Table

(0) Share

Report

Posted on by h4x0rz3d

Hi All,

I am trying to execute a 'retrieve multiple' request from a custom page when I click a button.

I have been playing with PowerFX and ClearCollect and various other techniques without success.

Unlike a canvas app, I cannot see a FetchXML or method to call an API URL directly?

What is the best way to perform a retrieve multiple for the contact's table, for example via a custom page?

The below works to some extent - but it's not what I'm after. Is there another way?

ClearCollect(
ContactsCollection,
Contacts
)

The below don't appear to work in custom pages:?

ClearCollect(
 ContactsCollection,
 'https://<your_organization_name>.crm.dynamics.com/api/data/v9.1/contacts?$select=fullname,emailaddress1,telephone1'
);

ClearCollect(
 ContactsCollection,
 FetchXML(
 "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
 <entity name='contact'>
 <attribute name='firstname' />
 <attribute name='lastname' />
 </entity>
 </fetch>"
 ).value
);

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report
Hi @h4x0rz3d ,

Please try this:

ClearCollect( ContactsCollection, ShowColumns(Contacts,fullname,emailaddress1,telephone1) );

This has the same effect as the api you mentioned above.

Best Regards,

Wearsky

Was this reply helpful? Yes No
h4x0rz3d 8 on at

Like (0)

Report

Hi Wearsky,
I am getting "The function 'ShowColumns' has some invalid arguments." when trying this.
Thanks,

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @h4x0rz3d ,

Double quotes are missing in my formula.

Here is the documentation.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-table-shaping

Best Regards,

Wearsky

Was this reply helpful? Yes No
h4x0rz3d 8 on at

Like (0)

Report

Thanks very much.

Was this reply helpful? Yes No