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:

General Questions

All responses (3)

Answers (1)

Verified answer

jonfuego on at

Like (1)

Report

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

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.
jonfuego on at

Like (1)

Report

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

@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.
mmbr1606 11,991 Super User 2025 Season 1 on at

Like (2)

Report

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

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