How to display attachment filename in HTML table for each individual list item

(0) Share

Report

Posted on by katdog888

Hi All,

I have an automated flow where the items added for the past 7 days are sent in an email, plus any attachments.

I want the email to show the attachment filename for each individual list item, but currently it is displaying ALL attachment filenames for every item squished together. E.g.

How do i fix this? Do i need to change the order of the get items / initialize variable actions or the append string variable action? here is my flow:

Thanks in advance for your help.

I have the same question (0)

All responses (10)

Answers (0)

SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: How to display attachment filename in HTML table for each individual list item

Can you try updating this action as below?

Was this reply helpful? Yes No
katdog888 14 on at

Like (0)

Report

Re: How to display attachment filename in HTML table for each individual list item

Won't that just put a line break between each attachment filename...? I want the field to display the file name only for the attachment for a particular list item - not pull all names for all attachments

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: How to display attachment filename in HTML table for each individual list item

Shouldn't the two Apply to each actions be nested?
Like,

Was this reply helpful? Yes No
katdog888 14 on at

Like (0)

Report

Re: How to display attachment filename in HTML table for each individual list item

I hope i didn't misunderstand your instruction, but i tried to move the Append to String Variable action down into the 2nd Apply to Each loop and now am getting this error -

I also think they're already nested. The way i screenshot is might be misleading. i zoomed out so you can see the full original flow:

Any ideas? appreciate your help. I just want it to return the file name for attachments on each individual list item.

Was this reply helpful? Yes No
katdog888 14 on at

Like (0)

Report

Re: How to display attachment filename in HTML table for each individual list item

Anyone? Please help - i'm lost!

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: How to display attachment filename in HTML table for each individual list item

@katdog888
I have put together a sample flow for you.
https://1drv.ms/u/s!AiSgXzNMOHCkz17q05kvSyV9GMNy?e=uhjDJd

Was this reply helpful? Yes No
katdog888 14 on at

Like (0)

Report

Re: How to display attachment filename in HTML table for each individual list item

Hi Sudeep,
Thanks for putting this together. I tried to replicate your solution into my flow, but it did not work - the attachment details are still pulling through for every list item, even though there is only one attachment on a single list item. The formatting also looks odd.
E.g.
This is the flow now -

Your flow ended at 'compose' but i assume i was supposed to input the Compose action into the HTML table.
Is there any way to just return the Attachment filename value that corresponds with the list item? And nothing if there is no attachment?

Thanks
Kat

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: How to display attachment filename in HTML table for each individual list item

HI @katdog888 ,
I suggest that you run my sample flow separately to understand what I am doing.
I am looping the list items in the first apply to each
Looping through the attachments for that specific list items in Apply to each 2
And then saving the results in an array.
[
  "['ListItem':'Approval 1','Attachments':''BoA Logo.png\nSB Logo.png\n",
  "['ListItem':'Approval 2','Attachments':''PXL_20220928_052224402.jpg\nPXL_20220928_052247675.jpg\n",
  "['ListItem':'Approval 3','Attachments':''"
]
Once all the items are traversed, the array should have attachment names per list item.
Start with a simple list and test this flow, then add the logic in yours

Was this reply helpful? Yes No
katdog888 14 on at

Like (0)

Report

Re: How to display attachment filename in HTML table for each individual list item

Hi Sudeep,

The problem is that if I try to input the Compose output into a HTML table from Get Items variables, the array created for attachment names per list item are still pulling through for ALL list items in the HTML table.
If i initialise and append the array, then I just have a list of list numbers + attachment names pulling through for every list item in the HTML table.
What does the 'set variable = null' do?
And why do you need a 'Compose' action for the array variable? How is this different from just using the variable itself?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: How to display attachment filename in HTML table for each individual list item

What does the 'set variable = null' do?
We need to clear out the attachments variable when we traverse through the next list item, otherwise the attachment array just keeps growing.
And why do you need a 'Compose' action for the array variable? How is this different from just using the variable itself?
I just used compose to view the output, it is not required in the flow logic

Was this reply helpful? Yes No