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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Business Central - how...
Power Automate
Answered

Business Central - how to loop through items in a table

(0) ShareShare
ReportReport
Posted on by 9

Hi,

I would like to loop through records in a table within Business Central. There is a Fin&Op actions called "List items present in table" that allows you to do just that. However, i cannot see a similar action for Business Central, is this feature not available yet for BC ?

 

Thanks

Categories:
I have the same question (0)
  • Verified answer
    rrovira Profile Picture
    Microsoft Employee on at

    Hello, @flyinglaptop!

    Well, I've never used the Business Central connector, however, reading the documentation I found a "Get record" action but this only brings one record and it requires the ID of said record. For what I can see, there isn't an action capable of bringing a list of all the records (https://docs.microsoft.com/en-us/connectors/dynamicssmbsaas/#actions)

     

    I'm not sure if someone else knows a different way of obtaining a list of the records, but please feel free to share more info. 

     

    Example of the action Get record (V3):

    rrovira_2-1624380473216.png

     

    Cheers,

    Rodrigo

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard