Posts

Showing posts from December, 2021

How to have your vendors and customer self onboard in Business Central using Power Automate (Flow) and BC

Image
 Hi Everyone,   Due to popular asks from my sessions back at Directions EMEA, please see my video on how to create a Power Automate to have your customers and vendors onboard themselves using Microsoft Forms, Microsoft Teams, Dynamics 365 Business Central and Twitter.  You can try my flow at:  https://forms.office.com/r/Em6MZ7Gyr0 Questions, feel free to email me at smullins@accelerynt.com or follow me on twitter @1shannonmullin1.

Extract Your Dynamics 365 Business Central Data in Excel in Five Easy Steps

Image
Every once in a while, you need a table in Business Central (BC) that does not have an export to Excel button. The instructions below will give you the ability to export page and table data into Excel as a refreshable file.  Before you start, figure out the table and page you are on by using the help button. In my case, I need a download of the extension deployment logs. I first start by clicking on the ? in the BC navigation bar at the top right corner of the page while on the page where I need to grab the data fields. Then I click on inspect pages and Data.  Next, I locate the name of the page and number:  Then I follow the steps below:  Step 1: Create new web service using page 2508. Just click new at the top. Choose page as the object page, enter the page number as the object ID and give it a name. (No Spaces). Click off that line and then scroll to the right and get the API created automatically. Copy it for the steps below.  Step 2: Go into Excel, Click on Data Tab, Choose Get Da