News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows count rows based on re...

Power Automate - Using Flows

Unanswered

count rows based on reference id

(0) Share

Report

Report

Posted on by Community Power Pla...

Hi,

I have two list below mentioned.

1- Email list

in email list, there is one column RefID.

2-list is order

now i want to compare eCARID with RefID and find how many rows are in order list.

All responses Img

All responses (1)

Answers Img

Answers (0)

v-yamao-msft on at

Like (0)

Report
Re: count rows based on reference id

Hi @Anonymous,

Do you want to get how many rows are there in the list?

Please try using the function length to return the number of items in a string or array.

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#length

I have made the following flow for your reference.

After the action Get items, add a Compose action and input the following code:

length(body('Get_items')?['value'])

Please take a try with it to see if it will work for you.

Best regards,

Mabel

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,522 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,890 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans