web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Unify ID information f...
Power Automate
Unanswered

Unify ID information from 2 lists in flow

(0) ShareShare
ReportReport
Posted on by 361

Good Morning,

I'm trying to get this flow to send a material approval email containing all the materials in the ID.

I have 2 lists (one of applicants and one of materials), the applicants list has only the ID of the "order" and the list of materials contains all the IDS of that order, that is, all the materials that the user requested, as follows print:

Applicants:

Materials:

Joaoandrebs_0-1674823530240.png

 

to reach the approval system, it is through a pwa screen that generates the materials, these are forwarded for approval...

my approval system is not via approvals, but via a screen that I created in the pwa... this screen has 2 buttons that patch the "Aprovação da Área" (area approval) column, on the right side of the material list, its default value is "Pendente" " (pending).

as soon as the materials are approved or rejected, a new informative e-mail is sent.

The question is: I'm having a problem gathering all the materials in ONE E-MAIL per ID, several emails are being sent from the same ID and I would like it to be in one ID, all materials in all steps are sent in and separate emails.

Flow data: I used the trigger from the list of materials, as the approval column is related to the materials,

I also used a string variable to gather all the materials in the emails, but without success, arrays give an error in the system and I don't know how to get out of this.

 

Does anyone have a solution to unify this data in emails? any similar cases?

Joaoandrebs_1-1674824488148.png

Joaoandrebs_2-1674824534630.png

 

 

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard