Hi,
I have some "Apply to each" pieces of my puzzle and I'm looking to populate a word document. For the compose, I can use the following syntax. What can I do for components of my flow from the "Apply to each" components?
From compose....
outputs('Compose_company')?['value']?[0]?['Company_Name']
Thanks for the reply. Using the compose statement I used before simply as a reference what is the best way to use your items example? Also, is this the best way to do things since I’m pulling from multiple tables? That’s more of a loaded question but I guess my starting point would be to see if I can get the items example to work. Thanks for your time.
Hi @ez1138 :
Sorry I can't understand what your needs are from your description and formula provided. Can you provide some detailed description and screenshots?
In addition, regarding the usage of apply to each, here are some examples for your reference:
Solved: Re: How to link a column value to an email - Power Platform Community (microsoft.com)
Solved: Re: Using SQL and Flows for recurring reminders? - Power Platform Community (microsoft.com)
Solved: Re: Adding Dynamic Content to Email - Power Platform Community (microsoft.com)
Solved: Re: Updating Rows - Power Platform Community (microsoft.com)
Best Regards,
Bof
Hi @ez1138 ,
What is the case scenario here? You have a bunch of arrays and want to generate a word document using it in a repeating section?
If the data you're getting is in the format of an array of objects, why don't you use a select action? It will take array as input and give the output also as an array, but in a format that you've specified.
If my assumption is wrong and you have a different process in plan, then please provide me the details so I can advise you with a better solution.
Hope you find this helpful! 🙂
Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Thanks for the reply. This is how I have it structured (screen-shot). Using this example, could I use the following code?
item()?['Title_Role']
Just did a mouse over on the "compose".
Hi @ez1138 ,
I have used the compose action just to show you what format the data comes in.
You can use the Values output property of get rows client async and use it directly as input to Select action
Then, in the Map property, give the new column name and value of column to split into a separate array,
The Key is the column name you want for this and Value is the "item()?['#property name from get rows output']"
Hope this is clear for you 🙂
Kind Regards,
Shaik Sha
________________________________________________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Appreciate the reply. Using the "Title_Role", what's the syntax/code to place it in the Word document?