calculate the count of sharepoint list items and then record in an excel using power automate

Question

Hi there,

I'd love to request your kind help with the difficulty written in the title. In detail, I want to use Power Automate to respectively calculate the count of total items and the count of 'Completed Status' and then record this value in the assigned field in an excel. I am wondering if any flow could work out? Big thanks in advance!

Answer 1

Hi Dong, Si Yu [Chevron], since I found out that you have also posted this issue in the Power Automate community, and I am pleased to know that this issue has now been resolved by our Power Automate colleagues: )

In order for other users with similar questions to find solution more easily when browsing the forum. I posted the solution below. If possible, would you mind kindly clicking "Accept Answer", which is also helpful : )

Thanks for your understanding.

.

Best Regards.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.