How to compare two list

[kannan1]

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 

[manuelstgomes · Accepted solution]

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.

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