Hi guys,
I am currently in a bind, I created a flow that collects data items from different Sharepoint lists in order to generate documents, that is collecting KPIs and goals to create a PDF and Word document, and it allows the users to generate documents of their performance reviews at any moment, e.g., when they have just created the reviews or just after scoring, at any time really.
Previous versions of this flow ran successfully but it seems that new runs of the flow don't complete successfully and the documents have a lot of gaps within them, mainly where I use arrays to populate repeater template sections within the Word document. After some debugging I found that the problem is coming from where I append the values to the respective array variables used to populate the Word template document. The appending happens within an "Apply for Each" control, and something to note is that for a performance review that has been fully populated, i.e. it has been scored, so all columns of the entry are populated, the appending works pretty well. However, for partially filled performance reviews, i.e. with some goals and KPIs created but none scored, this is when the appending of the flow shows the error, "Not specified".
I have tried everything, recreating the flows and even using Compose function as initially I just compiled the array entry into the array variable within the "Append to a variable" control.
Please find below screenshots of the flow before a flow run and the message I get after runtime
Before run
After run
