microsoft / microsoft/PowerPlatformConnectors
Unable to import into child tables correctly
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 1.3k
- Forks
- 1.5k
- Avg merge
- 5d 15h
- Merged PRs (30d)
- 11
Description
Type of Connector
Certified Connector
Name of Connector
Dynamics 365 Business Central
Describe the bug
Using the D365BC Connector inside Power Automate, users are unable to import into a "child" table while referencing the "parent" table, because the parent table name is a primary key inside the child table. Primary Keys cannot be imported into, but that is a requirement for basic functionality of child tables.
We can create a flow that imports into child tables without primary keys. In this instance, standard users wouldn't ever be able to find the appropriate records. The below examples are for Price Lists. We imported into the Price List table but the Price List Code field is blank, making that record meaningless.
Is this a security bug?
No, this is not a security bug
What is the severity of this bug?
Severity 2 - One or more important connector features are down
To Reproduce
- Create a custom API for a "child" table. Examples: Price List Lines, Production BOM Lines, or Routing Lines.
- Go to Power Automate
- Create a Flow and add an action with the D365BC Connector
- Select "Create a Record"
- Click Advanced Parameters and scroll through the list of available fields.
Expected behavior
- Create a custom API for a child table.
- Power Automate Flows would allow a primary key through the Advanced Parameters menu (or, at least one main primary key in order to associate it with a parent record),
- If the Primary Key is not imported into correctly, the flow would fail with an error message something like "Unknown Parent Record".
Environment summary
Install Method (e.g. pip, interactive script, apt-get, Docker, MSI, edge build)
CLI version (paconn --version)
OS version
Shell Type (e.g. bash, cmd.exe, Bash on Windows)
I'm not sure of any of the above. I'm using standard cloud-based Power Automate Flows.
Additional context
These are the tables that I'd like to insert into, but because of this issue, cannot.
Price Lists
Production BOM
Routings
We are forced to create an excel-based automation that users can then import into configuration packages.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by inspecting the Dynamics 365 Business Central connector's Create a Record action and its Advanced Parameters in Power Automate, then reproduce the issue with a child-table custom API such as Price List Lines. Compare behavior for the parent primary key and verify that child records can be associated with their parent or fail with a clear error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp
- Domain
- api
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100