cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SeanJansen
Level: Powered On

Connection powerapps to Dynamics 365 for operations custom tables

Hi everyone,

 

While creating an connection between Microsoft Powerapps and an Dynamics 365 for operations instance all the standard tables are availible to use from the powerapps.

 

The only thing i seem to be missing are the "custom" tables that are being added to Dynamics 365 for operations from Apps that are installed to Dynamics 365. For example some rental tables do not show up in the whole list that is loaded when creating an connection.

 

Does anyone know why i can't connect to these custom tables and can connect to the standard tables.

 

Best regards,

 

Sean

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft Employee

Re: Connection powerapps to Dynamics 365 for operations custom tables

Hi Marco,

 

A few questions. 

1) Do the extensions that you installed show up on the Dynamics AX $metadata endpoint:

    render the endpoint: https://youraosednpoint.cloudax.dynamics.com/data/$metadata

    and look for the extensions (additional types & additional fields)

    In order for tables to show up they need to be exposed by DataEntities.

2) if you create a new powerapp (not use an existing ones do do you see your types)?

3) do you see your types when you try flow?

 

Thanks,

Dan

 

View solution in original post

9 REPLIES 9
Community Support Team
Community Support Team

Re: Connection powerapps to Dynamics 365 for operations custom tables

Hi Sean,

 

Are you able to create an app based on standard tables?
Have you created custom tables in Dynamics 365 for Operations successfully?
Are all the standard tables shown in the whole dataset list expect the custom tables?

 

Please help to collect the information above.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SeanJansen
Level: Powered On

Re: Connection powerapps to Dynamics 365 for operations custom tables

Hi Marco,

 

Thank you for the reply, see below for anwsers:

 

Are you able to create an app based on standard tables?

  • Yes this works perfectly for example on the customers table


Have you created custom tables in Dynamics 365 for Operations successfully?

  • Yes the tables are working propperly from within Dynamics 365 for Operations, they came from an add-on for 365 that was certified (DynaRent)


Are all the standard tables shown in the whole dataset list expect the custom tables?

  • This is correct, i can see all the standard tables like customers, sales orders, assets etc. But the custom tables won't show up in the dataset list.

 

Microsoft Employee

Re: Connection powerapps to Dynamics 365 for operations custom tables

Hi Marco,

 

A few questions. 

1) Do the extensions that you installed show up on the Dynamics AX $metadata endpoint:

    render the endpoint: https://youraosednpoint.cloudax.dynamics.com/data/$metadata

    and look for the extensions (additional types & additional fields)

    In order for tables to show up they need to be exposed by DataEntities.

2) if you create a new powerapp (not use an existing ones do do you see your types)?

3) do you see your types when you try flow?

 

Thanks,

Dan

 

View solution in original post

SeanJansen
Level: Powered On

Re: Connection powerapps to Dynamics 365 for operations custom tables

Hi Danta,

 

Thank you for your reply, and sorry for the late reaction from my side.

 

1. Will look into that today

2. Creating a new or using an existing app both gives the same result that i can't see the tables added by the extension

3. Will look into that today

 

Regards,

 

Sean

Vicky_Song
Level: Powered On

Re: Connection powerapps to Dynamics 365 for operations custom tables

@SeanJansen, what is your issue now? What's your test result and do you still need help on this issue? 

Selina123
Level: Power Up

Re: Connection powerapps to Dynamics 365 for operations custom tables

Hello Sean,

 

I currently have access to an enviornment (dynamics 365 for operations and assigned as an admin). I also signed into powerapps, I established a connection with dynamics 365 for operations. But with that said, I don't have any dataset to select from.

 

It seems you were able to access the standard tables, can I ask if you had to specify your URL in powerapps or any presetup?

 

THanks,

 

Selina

Microsoft Employee

Re: Connection powerapps to Dynamics 365 for operations custom tables

This is the way it works:  Your user id is within a tenant.  The tenant is associated with a set of Dynamics 365 environments.  The Dataset box looks up the list of environments that are accessible for your tenant.  Currently powerapps allows you to only create apps on enviornments which your tenant has access to.

 

 

SeanJansen
Level: Powered On

Re: Connection powerapps to Dynamics 365 for operations custom tables

Hi Selena,

 

Also look if your 365 for operations is the update 3 version, i thought this is a requirement in order to see your tables. I have specified my 365 for operations enviroment link before but you could also set this in the powerapps itself (when developing one).

 

Regards,

 

Sean

SeanJansen
Level: Powered On

Re: Connection powerapps to Dynamics 365 for operations custom tables

@Vicky_Song

 

Sorry for the late reply, was abroad for work quite some time. The current status is that we found out our current custom tables did not have a data entity. Because it is lacking the data entitiy the PowerApps could not find our tables.

 

We are currently working on getting data entitiy's for all our custom tables.

 

Regards Sean

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 209 members 5,410 guests
Recent signins:
Please welcome our newest community members: