Answered

Trigger Condition with Greater and Length expression

(0) Share

Report

Posted on by PAuser_1-2-3

I'd like to create a customized trigger condition that will fire the flow when the number of items in the list is Greater than 4000 AND "When an item is created or modified" in SharePoint. I have my condition written as

@greater(length(triggerOutputs()?['body/value']),4000) but it is not working. Any thoughts and solutions?

This is the error message I received:

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @PAuser_1-2-3

If you want to judge the list is Greater than 4000 , you may need to use the [ID] column in your SharePoint List , you can use this expression:
@greater( triggerOutputs()?['body']?['ID'] , 4000)

And if you do not want to use the [ID] column, you can not judge it in your trigger. You need to add the condition after your trigger:

/_api/web/lists/getbytitle('Your List Name')/ItemCount

body('Send_an_HTTP_request_to_SharePoint')?['d']?['ItemCount']

For more information, you can refer to :
How to Count Items in a SharePoint List with Power Automate - Power Tech Tips

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
PAuser_1-2-3 52 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-yueyun-msft. The first solution using ID doesn't work for my case because I also have a subsequent step that delete items, therefore using ID in the trigger to count number of items would give false result.

Option 2 using Send HTTP and condition steps work flawlessly for my purpose. Much appreciated!

Was this reply helpful? Yes No