Small and medium business | Business Central, N...

Dimensions and Dimension combination matrix

(0) Share

Report

Posted on by Ricardo Jacobsen

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).

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:

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?

All responses (2)

Answers (0)

Ricardo Jacobsen 50 on at

Like (0)

Report

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.
Suggested answer

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

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.