Power Platform Community Forum Thread Details

Hi all,

I've build a flow that starts when a new item is created in SharePoint. The data is entered, and the flow then transfers it to an excel table, from that table i fill an excel form. After that the template is emailed to the requester, so they can fill it with the codes they would like to order. After that they will attach the complete excel template to the Sharepoint item. All this is working well.

The problems starts now that i've build a macro in the excel file to automatically fill some shipping forms. I noticed that i can't add a row to a .xlsm file. To bypass this problem i created a parallel .xlsm file, that gets his data from the original excel template. The .xlsm file is then emailed to the requester. Also this is working well.

The problem i now (logically) discovered is that when a new order is made the template will be filled with new information. But because of the links in the .xlsm file also the old files are updated with new information. While i would only like to have them updated at the moment they created/emailed.

Does anyone have any suggestions?

Thanks in advance,

Ben

Categories:

Using flows