cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MahmoudSaeed
New Member

Building Canvas App connecting to D365 for finance and operations

Hello,
I'm trying to build Canvas app Connecting to Dynamic365 for finance and operations, and I'm facing two main issues as following:

  1. I'm not able to see all of Dynamic 365 for F&O Tables and I can see only some of it (I cannot see The complicated tables like Inventory Transactions for example).
  2. Sometimes while inserting a Field into a Form, I found that field data type doesn't match my requirements. and sometimes i can see the same field duplicated two times with two different types, so where can i control Fields data type in Powerapps?
    For Example, I would like to change the field type from text to Complex.
    Here I Found two Fields for "Project Category" One with data type Text and other with ComplexHere I Found two Fields for "Project Category" One with data type Text and other with Compleximage.png
1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

There are a number of tables in Dataverse that are restricted for use only if you have a Dynamics 365 license.  I suspect that is the problem you are having.  MS does this to keep people from building a limited version of something like CRM without buying CRM licensing.  You can read about it here:

License requirements for tables - Power Apps | Microsoft Docs



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365EduCon in Chicago on Sept. 26-30 where I'll be presenting on the Power Platform!

View solution in original post

3 REPLIES 3
Pstork1
Dual Super User
Dual Super User

There are a number of tables in Dataverse that are restricted for use only if you have a Dynamics 365 license.  I suspect that is the problem you are having.  MS does this to keep people from building a limited version of something like CRM without buying CRM licensing.  You can read about it here:

License requirements for tables - Power Apps | Microsoft Docs



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365EduCon in Chicago on Sept. 26-30 where I'll be presenting on the Power Platform!

Thanks so much for your reply, your link helped me a lot.
Regarding to the second question about changing Field Data type, Do you have any Idea?

Sorry, for that one I don't have any input.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365EduCon in Chicago on Sept. 26-30 where I'll be presenting on the Power Platform!

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,123)