How to get the first attachment on a SharePoint list item

[olacharles]

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.

[abm]

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

[tom_riha · Accepted solution]

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']

 

[olacharles]

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

[SteveCochrane]

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