Power Platform Community Forum Thread Details

Greetings everyone,

I'm hoping to seek some assistance with building what I initially thought was a straightforward process.

Here are the basics:

I'm currently utilizing SharePoint, Dataverse, PowerApps, and Power Automate. My goal is to create a Weekly Activity Report, where users from different teams can input their data through a PowerApp. The information is then stored in Dataverse. I have a template for each week of the month in a SharePoint library, and I'm trying to populate each person's section of the Word document once they submit their entries.

In the Word document, I have content controls for each department.

The flow:

The flow is triggered when a new row is added to the Dataverse table. Alternatively, we could run it on a schedule.

I've set up a switch for each department within the Weekly Activity Report. Once a department is selected, it will populate the appropriate content control in the Word template and update the file.

The issue:

I need to figuure out a way to:

Grab the correct file from SharePoint for the current week
Is it possible to have rich text entered into the word document in this way
Identify which entries within Dataverse go with which file week/month
Would it be better to run this on a schedule (Example every 1 week pull all data entries within the dataverse table and apply them?)

Thank you in advance for your assistance.

Categories:

Building flows