Answered

Generating email reports to include data from Sharepoint list in Meeting Capture app

(1) Share

Report

Posted on by jonfuego

I have been working to customize the app below created by @RezaDorrani

https://powerusers.microsoft.com/t5/Community-App-Samples/Meeting-Capture-V2/td-p/342028

We have a recurring meeting where we discuss ongoing changes to various projects, so I have replaced the default Rich Text field in the app with SharePoint list items for the users to update. The users selects the various projects from the drop down and updates the items accordingly... simple enough

At the conclusion of the meeting, we would like the wrap up email to include each list item in its own table/page. I have created a basic HTML template (below), but I am unsure how to loop through the list to generate the "pages".

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

mmbr1606 14,615 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

hey @jonfuego

i havent watched this video yet, but its on my list, but maybe it helps you:

Everything about sending emails with PowerApps (youtube.com)

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
jonfuego on at

Like (1)

Report
Copy link

Link copied!

@mmbr1606,
Thank you for your response and helpful link. I should have been more clear in explaining my issue. I have the mechanics of emailing all sorted out. The part that is giving me trouble is populating the template with the data I am looking for....

The users will be updating a sharepoint list through text fields in the PowerApp. I would like to export each of the records from that list into this email template. My limited knowledge tells me that I would need to create a collection from the Sharepoint list and then use "ForEach" or "ForAll" to loop through and export. I have never used either before, so I was hoping someone smarter than myself could give me a bit of guidance.

Was this reply helpful? Yes No
Verified answer

jonfuego on at

Like (1)

Report
Copy link

Link copied!

I ended up using PowerAutomate to create a Word Document. It requires the Premium PowerApps license, which is not ideal, but made the process infinitely easier.

Was this reply helpful? Yes No