Unanswered

How to get the first attachment on a SharePoint list item

(0) Share

Report

Posted on by TheOyinbooke

Dear community,

I am currently working on a flow and need to get the first attachment file out of the multiple files attached to a SharePoint list.

My flow is typically like this

Get attachments >>> Get Attachment Content >>> then send email with the attachment content.

My flow will run and I will get different emails for every attachment on the list meanwhile I needed the first attachment file and not others.

It is frustrating and I need help right now.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @olacharles

After the get attachments step you will have a loop which will retrieve all the attachments. You could use a Do until loop or an IF condition with an incremented counter to stop iterating the next attachment. Inside your Do Until Loop or the IF condition (where counter = 1) do the attachment content extraction action steps.

Thanks

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (5)

Report
Hello @olacharles ,
you can use the First() expression to get the 'Id' of the first item in the collection of attachments provided by the 'Get attachments' action. Then apply the 'Get Attachment Content' only on the 'Id' of the first item, without 'Apply to each'.
First(outputs('Get_attachments')?['body'])?['Id']

1 people found this reply helpful.

Was this reply helpful? Yes No
TheOyinbooke 17 on at

Like (0)

Report

Thank you so much @tom_riha . this works perfectly well!

Was this reply helpful? Yes No
SteveCochrane 219 on at

Like (0)

Report

Many thanks for this!
This works well, but what if in the trigger, we wanted an input to select which file we wanted to rename? For example, an input can have "2", and then, instead of "first(outputs...)" to get the first file, it would be "second(outputs...)", or something equivalent? Adding the input and reading it is fine, but would anyone know the syntax to select a specific file? I would prefer not to use an Apply To each loop.
Thank you, in advance!

Steve in Spain

Was this reply helpful? Yes No
apettit 245 on at

Like (0)

Report

Will you please advise... for whatever reason and whatever I try, I can't seem to get this to work? Thank you so much for considering!
json from When a new email arrives

Was this reply helpful? Yes No