cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akaur
Frequent Visitor

Get Records from 2 tables of Business Central

How can i get records from 2 tables of Business central.

 

1st table is workflowsalesdocument, 

2nd table is workflowsalesdocumentlines, 

 

with this below method i am getting an error, error is shown below. Can someone please help??

 

akaur_1-1625489832189.png

 

 

akaur_0-1625489728830.png

 

4 REPLIES 4
rrovira
Microsoft
Microsoft

Hello, @akaur

 

Well, I was checking some blogs that talk about this error, and it looks like you need to provide the ID or key for those two elements as well "documentType.documentNumber" and "lineNumber".

 

Error updating AX entities using the Dynamics 365 for Operations connector in Logic Apps – connected...

 

I'm not sure if this might be of some help to you! Let me know, if not, we look for another solution!

Cheers!

akaur
Frequent Visitor

Hi @rrovira,

Thank you for your reply, I tried adding document type and document no but still getting the same error.

All I want is to create a flow that sends customer email with the shipping details and items that were shipped when record is updated in Business Central, 

Getting shipping details is working fine but how do i get items details. is there another way of doing this?

rrovira
Microsoft
Microsoft

Hello, @akaur!

 

Have you tried using Get Record (v3)? I'll keep on investigating to see if I manage to understand what might be causing this issue. 

 

Cheers! 

Hi @rrovira.

there is a problem ahead. there are some Fields from business central that are added as extension to an existing page. I want to get data from from that fields into power automate. 

But when I use Get Record(V3) , It doesn't show me extensional fields can you please help.

Thanks in advance

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (3,019)