web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Get Multiple Table Record in Power Automate

(0) ShareShare
ReportReport
Posted on by 152
Hi,
 
I am trying to create an automated flow for Purchase Order creation in Business Central when the Item inventory level become minimum quantity. 
I have added a Triger and connection to get the item record from Business Central, See the below screen shot.
 
In the next step I have added a control and condition to check the Item Inventory, See the below screen shot. 
 
My requirement is, when the inventory for the item 1908-S is less than 50, then a Purchase Order should be created automatically. 
I have added /Create Record/ action as this condition satisfy. See the below screen shot.
 
I am getting the below error when this Flow Run. 
 
 
Now the Vendor is not mapped in the Create Record step, Is that causes? Or it is api connection issue? 
 
Should I add a step of Get Record for Vendor Table and to map the Vendor No in Create Record Action?  
 
Thanks for sharing your thoughts.
 
Best Regards,
Ranjith 
 
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    95,548 Super User 2025 Season 2 on at
    Hi, it seems that there is no value in Create record (V3) step.
    You can create a manual process that only includes Create record (V3) step to see if you can create an order.
     
     
    Hope this helps.
    Thanks.
    ZHU
  • RE-24072358-0 Profile Picture
    152 on at
    Hi YUN ZHU,
     
    To map the values in Create Record (V3), unable to pick the fields from Dynamics Contents. So that my doubt, should I first create a step to Get Record with "Vendor" table? Since the Item table is already in the previous step using Get Record, so that I can map the Item, Quantity etc in the Create Record.  How to relate and map multiple tables in to different steps in a flow is the confusing one.... 
     
    There is no impact if going for manual process. Trying to complete the automatic flow.... 
     
     
    Regards,
    Ranjith E S 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,151

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,443 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,092 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans