Count how many items has created in Sharepoint List

(0) Share

Report

Posted on by echodapogi

516

Hey Community,

How do you count the number of items that has been created by a "Create Item" in SharePoint action?

Scenario: I have a Power Automate step that IF the EmployeeID is already in the SharePoint list (tblEmployee) SKIP the create new and IF the EmployeeID is NOT in the SharePoint List (tblEmployee) then CREATE ITEM in SharePoint table. Now that is working fine.. my problem is i wanted to check or how many new records has been created IF the EmployeeID is not in the table.

How do i do that? I used the below code in a compose action but it has error.

length(outputs('Create_item')?['body'])

any help is appreciated.

Thanks

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

Initialize an Integer variable and increment it whenever you add an item.

Was this reply helpful? Yes No
echodapogi 516 on at

Like (0)

Report

i did but i cannot make it work

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (0)

Report

What is the problem?

Was this reply helpful? Yes No
Verified answer

echodapogi 516 on at

Like (0)

Report

I managed to solve this in a different way. Your idea helped too. thanks

Was this reply helpful? Yes No
brittany 11 on at

Like (0)

Report

I'm interested in seeing your solution for counting items but this thread doesn't seem to show it and the link to "View solution in original post" just takes me to the same thread. Would you mind sharing it again? I am trying to get a count of items from one List to increment up each time an item type is created in the shown value of another List.

Was this reply helpful? Yes No