Count how many items has created in Sharepoint List

Like (0) Share

Report

Posted on 9 Feb 2023 17:16:10 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

All responses (5)

Answers (1)

brittany 11 on 21 Nov 2023 at 13:02:26

Like (0)

Report

Re: Count how many items has created in Sharepoint List

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.
Verified answer

echodapogi 516 on 10 Feb 2023 at 14:12:18

Like (0)

Report

Re: Count how many items has created in Sharepoint List

I managed to solve this in a different way. Your idea helped too. thanks
Chriddle 7,932 Super User 2025 Season 2 on 10 Feb 2023 at 08:05:31

Like (0)

Report

Re: Count how many items has created in Sharepoint List

What is the problem?
echodapogi 516 on 09 Feb 2023 at 17:50:54

Like (0)

Report

Re: Count how many items has created in Sharepoint List

i did but i cannot make it work
Chriddle 7,932 Super User 2025 Season 2 on 09 Feb 2023 at 17:34:41

Like (0)

Report

Re: Count how many items has created in Sharepoint List

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