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
Solved! Go to 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
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
Hi Marco,
Thank you for the reply, see below for anwsers:
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?
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
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
@SeanJansen, what is your issue now? What's your test result and do you still need help on this issue?
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
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.
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
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
User | Count |
---|---|
257 | |
106 | |
87 | |
51 | |
43 |