Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Get Multiple Table Rec...
Small and medium business | Business Central, N...
Suggested answer

Get Multiple Table Record in Power Automate

(0) ShareShare
ReportReport
Posted on by RE-24072358-0 146
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 
 
Categories:
Dynamics 365 Business Central
  • RE-24072358-0 Profile Picture
    RE-24072358-0 146 on at
    Get Multiple Table Record in Power Automate
    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 
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 82,589 Super User 2025 Season 1 on at
    Get Multiple Table Record in Power Automate
    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

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

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

#1
YUN ZHU Profile Picture

YUN ZHU 290 Super User 2025 Season 1

#2
Mansi Soni Profile Picture

Mansi Soni 196

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 156 Most Valuable Professional

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans