Unanswered

Use item value in array filter body in create file

(0) Share

Report

Posted on by jsbev

Hi,

I have a 5 values in the array, use them to generate pdf documents. When saving the pdf file, I would like to name the file by adding the Owner/L'ld name as the prefix.

How can i reference the body.item.value for each iteration. The output should be 5 pdf files with the owner name value in the front.

Thanks

Jag

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Here is one solution for you.

outputs('Compose')?[0]?['Name']

Let me know if any query.

If you like my response, please give it a Thumbs Up.
If this helps, please Accept as solution.

Regards
Kaif

Was this reply helpful? Yes No
jsbev 48 on at

Like (0)

Report
Copy link

Link copied!
Hi Kaif,

Thank you for the reply. I'm able to get the owner name value but the apply to each only picks up the owner name from the first row. We need to keep moving down each row, select the owner name and use that in the filename.

I think this expression selects the first owner name in the array. How do we setup the expression to pick the owner name for each row?
outputs('Compose')?[0]?['Owner name']

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Use
item()?['OwnerName']
in your Apply to each.
See item() function.

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Update anyone:
item()?['Owner name']
items('Apply_to_each')?['Owner name']

If you like my response, please give it a Thumbs Up.
If this helps, please Accept as solution.

Regards
Kaif

Was this reply helpful? Yes No
jsbev 48 on at

Like (0)

Report
Copy link

Link copied!
if i use items('Apply_to_each')?['Owner name'].pdf the flow works but if i add the unique identifier value in the file name box, the flow does not run complete. The flow outputs 4 files and then times out after 10 mins

The above peek code
"parameters": { "folderPath": "/Automation/ERPMA/output/Housing", "name": "@{items('Apply_to_each_2')?['Unique identifier']}_@{items('Apply_to_each_2')?['Owner name']}.pdf", "body": "@outputs('Generate_document_from_Word_template_2')?['body/fileContent']" }
items('Apply_to_each')?['Unique identifier']_items('Apply_to_each')?['Owner name'].pdf

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

ID is Unique identifier ??(highlighted in blue)

If yes, I observed it has some special characters. Please check the ID used for naming the file:
Also, check length of File Name and Overall File Path should be as per Windows standards.

Regards
Kaif

Was this reply helpful? Yes No