Answered

Counting attachments in SharePoint list item

(0) Share

Report

Posted on by CU10081606-2

I am trying to loop through a SharePoint list and grab the attachments from each item, if any exist. I get the error below about an expression being invalid. The expression is supposed to count the number of attachments so I can use it in a condition.

Here are two expressions I have tried separately:

length(body('Get_attachments')?['value']) > 0
@greater(length(outputs('Get_attachments')?['body']), 0)

I get an invalid expression on both. Any help would be much appreciated. Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Pstork1 69,456 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

The left side of the comparison should be

length(body('Get_attachments'))

That will return the length of the array returned by Get_attachments. Then set the comparison to greater than and the right side to 0

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
Verified answer

CU10081606-2 10 on at

Like (0)

Report
Copy link

Link copied!

After trying so many different formulas, this worked for me length(outputs('Get_attachments')?['body'])

Was this reply helpful? Yes No
Pstork1 69,456 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

In case someone else comes looking here.

outputs('Get_attachments')?['body'] is the same as body('Get_attachments')

Both return the array that is the body of the Get Attachments action.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No