You’re offline. This is a read only version of the page.
Announcements
11
I am trying to build the following workflow and having trouble adding dynamic content to a newly created excel file.
The process
1) Users fill in a form. With the form submission they select an application. Each application has its own specific list of approvers (which is stored as a stand alone excel document called 'approval matrix').
2) The form data is added to a SharePoint list as a new item
3) Next step is to attach a business case to this newly created item as an attachment. This attachment is created from template excel file where the content is copied to the new attachment. The file works fine and stores this as an attachment in the item.
4) I scan the 'Approval matrix' file and filter all the appprovers for the application in question. This is stored as an HTML table (as below) which works fine.
The Issue - I want to now append this HTML table of approvers directly into the newly created attachment. I cannot seem to get this working.
The Flow as is
Create Item - takes form responses and creates a new List Item
Create File - creates a new attachment with my template content (blank business case)
Create Table - creates a new table in the attachment. This is the table where I want to store all my approvers from the array below
List rows present in a table - this takes all the approvers Name, Platform, Role & Email from the Approval Matrix
Filter Array - filters only those who match the criteria (in this case all approvers that match the Platform in question)
Create HTML Table - this stores all the approvers that I want to add to my newly created Table above in the attachment file.
As you can see it outputs the correct array highlighted in red.
How do I add this dynamic content into my newly created Excel table?I have tried adding them as new rows in a loop but its not working.
Any help is greatly appreciated.
Share
Report
All responses (
Answers (
