You’re offline. This is a read only version of the page.
131
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:
Thank you in advance for your assistance.
1. To grab the correct file from SharePoint dynamically, it can be a bit tricky. You can populate the File as a dynamic value but you will have to populate the word template values in a JSON format since the designer is not able to identify the fields anymore.
Share
Report
All responses (
Answers (
