Unanswered

Getting items from multiple lists power automate and send in a single email

(0) Share

Report

Posted on by naijacoder

172

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

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-jefferni on at

Like (1)

Report

Hi @naijacoder ,

Could you please share more details about your scenario? What do you mean by send a single email with some basic information Title and a link to the item?

I have no idea how you could get specific items from the lists, but below the Get items action you can use "Filter array" along with "Select" operations to iterate all entries and get desired column values:

You can also add a Create HTML table underneath the Select, use the outputs to generate an HTML table which can use in Email body.

Best regards,

Was this reply helpful? Yes No
Verified answer

naijacoder 172 on at

Like (0)

Report

Thanks v-jefferni for your response.
What I was looking and meant is send the items all in one email
I ended solving it myself but without using filter array but Apply to each but would try your approach too
Whats the filter array in your post suppose to do..?

Was this reply helpful? Yes No
naijacoder 172 on at

Like (0)

Report

Actually the filter for the list if needed

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @naijacoder ,

It can be used for applying another query on the outputs of get items and then in Select you will be able to find reference to the dynamic contents, which cannot be referenced easily from get item output array.

Best regards,

Was this reply helpful? Yes No