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

Community site session details

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

Dimensions and Dimension combination matrix

(0) ShareShare
ReportReport
Posted on by 50

Hello Everyone, 

I need to get the dimensions and dimensions values from business central and store in sharepoint or read it via flow.


I saw the power automate flow Get an image, file or document (V3). I was thinking if there is any possibility of to do this:

Go to dimensions in BC and click on the button to export to excel and store in someplace in BC (I don't know where and how).
pastedimage1680230764613v1.png
And then get this file via the flow mentioned above Get an image, file or document (V3) or a way of storing in SharePoint.

Here is a screenshot of the flow:
pastedimage1680231591047v1.png


ANOTHER IDEA is:

To have a C/AL extension for BC to call the function that the button export to excel calls, and after the file is generated, we store in the SharePoint.

Is this possible?

Any other approach or suggestion?

I have the same question (0)
  • Suggested answer
    Nitin Verma Profile Picture
    21,698 Moderator on at
    RE: Dimensions and Dimension combination matrix

    There might be another approach for this, try to Get all the records of BC in Powerautomate, convert and compose those records into excel and later save that excel file direct to sharepoint.

  • Ricardo Jacobsen Profile Picture
    50 on at
    RE: Dimensions and Dimension combination matrix

    I can't get all the records. because the records will come with only the dimension id, name and other some basic info. However, the info that i need is to know if the dimension is limited in somewhere else.

    For example:

    In the image above there are some limited combinations. I need that info.

    I tried to retrieve it via API, but that info doesn't appear.

    On the other side. When I export the file to excel. The info will be complete.

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,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans