I have a stored procedure that executes with a parameter of Batch_ID. Inside of flow I am able to successfully run everything and then in the output body I am able to see all associated values of that Batch_ID. The query Joins multiple tables to print a Roast_Tag for the specific Batch_ID. However, nothing is getting passed to my Word Template. Eventually this will be triggered through PowerApps once the Batch is created. Please see attached pictures.
My Flow:
This is my word template:
This is the failed PDF after conversion: No values were passed.
@yashag2255 Thanks for the reply. Unfortunately when I tried that way my flow kept failing (The field ID is invalid). I went back to the Populate Word Template step and put in the below for each Item, just changing the last part to match the template tag.
first(body('Execute_stored_procedure_(V2)')?['resultsets']?['Table1'])?['Blend_Number']
After doing this it worked fine. Thank you for the reply.
Hi @Anonymous
The reason why you are not getting the data there is probably because you are converting the base template and not the actual populated template. Convert to PDF in word is a premium connector and premium action and required the file to be present somewhere in the document library so that you can refer to it by selecting the folder icon. There is a convert to PDF action in OneDrive for business connector and I have used it as shown below:
I have tested this and it works fine.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2