cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kannan1
Helper I
Helper I

How to compare two list

Hi,

I need to iterate through all the list item and If the length of a title is less than 12 characters i need to compare it with the title of another list and populate certain field from the second list. How do i do this?.

 

wish to do it in manual or scheduled trigger 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
manuelstgomes
Super User
Super User

Hi @kannan1 

 

You can try the following:

1. Get all items

2. Find the ones with the title with lesser than 12 characters

length(items('Apply_to_each')?['Title'])

 3. Filter using an OData query for the title

Title eq '@{items('Apply_to_each')?['Title']}'

4. Update the information

 

Here's the full view. You can use either Scheduled or Manual trigger, and it works the same.

Screenshot_2020-07-28_at_10_40_09.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

 

View solution in original post

1 REPLY 1
manuelstgomes
Super User
Super User

Hi @kannan1 

 

You can try the following:

1. Get all items

2. Find the ones with the title with lesser than 12 characters

length(items('Apply_to_each')?['Title'])

 3. Filter using an OData query for the title

Title eq '@{items('Apply_to_each')?['Title']}'

4. Update the information

 

Here's the full view. You can use either Scheduled or Manual trigger, and it works the same.

Screenshot_2020-07-28_at_10_40_09.jpg

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,404)