Connection powerapps to Dynamics 365 for operations custom tables

[SeanJansen]

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

[v-yamao-msft]

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

[SeanJansen]

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.

[danta · Accepted solution]

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

[SeanJansen]

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]

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

[Selina123]

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

[danta]

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]

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]

@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