Unanswered

Import SharePoint meta data to an excel template

(0) Share

Report

Posted on by Chriss1982

Dear all,

I have a SharePoint list which contains information which should be written in an dynamic in Flwo created excel file. I´ve played a bit with some actions but it seems, there is no out of the box solution in Flow or am I wrong?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-bacao-msft on at

Like (0)

Report

Hi @Chriss1982 ,

Could you give an example of the metadata you need?

Dynamic content options only return some standard fields and custom fields. If the response body contains the required metadata, we can get it through expression. You can run the Get items action first, check the body of Get items, and see if the metadata you need is included.

If it does not, we may also need to get the required metadata through an HTTP request.

Best Regards,

Was this reply helpful? Yes No
Chriss1982 71 on at

Like (0)

Report

Hi @v-bacao-msft

thanks for your feedback.
Most of the metadata are custom columns.
The process is some kind of cost expense workflow. The user will fill in the cost in a Powerapp and those information will be then uploaded to SharePoint.
Then for each cost process instance/workflow the information(cost item, date, cots etc) needs to be imported to an Excel file.
If you have a static Excel file it seems no big deal, because you can easily map this from SharePoint to the existing Excel file but in my case the Excel should be created during the process.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @Chriss1982 ,

If the Excel file should be created during the process, we cannot select this file when configuring Flow, and we cannot configure Excel-related actions.

This is a known limitation. We cannot dynamically configure the files specified in the Excel action, nor can we manually enter the file name and table name.

Currently, we can only select the saved file and table to configure the Excel action.

Best Regards,

Was this reply helpful? Yes No