I'm working on a project I need to be able to: Scan through few lists(around 10) based on some criteria and then send a single email with some basic information Title and a link to the item.
My approach was create a separate list to store the list names and URL and then iterate through the list and then append the values to output.
See screenshot below.
The first get items iterate though the list names stored as a list
The second get item gets scan through the list names and output the values
In the compose I can see the values in JSON for each list.
But how do I iterate though it to get the values I need?
I have also tried the below in the Compose 2 (But I manage to get only the first item of each list)
outputs('Get_items_2')?['body']?['value'][0]?['Title']
Thanks in Advance
outputs('Get_items_2')?['body']?['value']
array to array variable initialized earlier (this way you will have items from all lists in single variable). Let me know if this approach works for you.outputs('Get_items_2')?['body']?['value']
as input parameter to 2nd apply to each. Add compose action inside this apply to each loop and use expression like this to get Title:item()?['Title']
.