You’re offline. This is a read only version of the page.
Announcements
Hi - hoping that someone can point me in the right direction?
My colleague and I create a weekly newsletter which is mostly a table with repeating structure - it takes about 4 hours a week (sometimes more) and it's a right pain. I want my Fridays back so I've decided to automate it.
The content is structured so that colleagues can see (quickly)
This means that a month long event (say Black History Month) will appear in all three sections, while a one off event like a CEO Update will only appear in Section 1 (What Happened This Week).
I've put all of my events in a single Sharepoint list and inserted a column called "ThisWeekText" in where a Variable Array has the word "Yes" if it's supposed so go in Section 1.
I've managed to populate a Word Document with This Weeks events using a Variable Array with a filter turned on (enabled Test features in PowerAutomate for ThisWeekText = Yes )
I then use the Variables to create a loop that populates each line in my template and populate a word document
But I can't figure out how to create the other two sections (Next Week and Coming Up).
Any suggestions?
Share
Report
All responses (
Answers (
522
