cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
radhe
Advocate III
Advocate III

count rows based on reference id

Hi,

 

I have two list below mentioned.

1- Email list

in email list, there is one column RefID.

email.png

2-list is order

order.png

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

1 REPLY 1
v-yamao-msft
Community Support
Community Support

Hi @radhe,

 

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#l...

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'])

1.PNG

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

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,406)