---

🚀 Power Automate + SharePoint: Turn Any List Item Into a Live Web Page Update

A Simple, Smart & Zero-JSON Method to Auto-Publish Dynamic Posts on SharePoint Pages

If you’ve ever wished your SharePoint modern page could update itself automatically—without touching page JSON, scripting, or custom web parts—this guide is your new best friend.

Imagine posting status updates, announcements, alerts, tickets, or news items directly from a SharePoint list… and watching them appear instantly on a SharePoint page as clean, readable posts.
No editing the page.
No approvals.
No republishing.

Just automation magic. ✨

In this blog, I’ll walk you through a completely no-code, beginner-friendly, yet enterprise-ready technique using:

• Power Automate

• A SharePoint list

• A simple text file

• The File Viewer web part

Let’s go! 💪

---

🌟 What We’re Building

We’ll create an automated solution where:

1. A user creates a new item in a SharePoint list (example: “Server Outage Update”).

2. Power Automate grabs that item.

3. The flow automatically formats it like a clean blog post.

4. The post is appended to a text file.

5. That text file is displayed on a SharePoint modern page.

6. The new post appears instantly — no manual page edits required.

Think of it like SharePoint + Auto-Blogging.

---

🔧 The Magic Behind the Scenes

The trick is simple but powerful:

• A .txt file inside a document library acts as a live content container.

• Power Automate reads the file, appends a new formatted “post block”, and writes it back.

• The File Viewer web part displays the whole file on the page.

✔ Zero JSON
✔ Zero coding
✔ Zero breaking the page
✔ Works in any site
✔ Keeps previous versions safely

---

🧠 Real-World Use Cases (Where This SHINES)

1️⃣ Live IT Status Updates

Teams can post updates like:

• “VPN outage resolved”

• “SharePoint maintenance completed”

• “Critical incident tracking started”

Your IT home page will update instantly.

---

2️⃣ Daily Operations Logs

Perfect for:

• Branch updates

• Audit notes

• Shift logs

• Manufacturing floor summaries

Every entry becomes a new post.

---

3️⃣ Announcements & News

HR or leadership can maintain a simple list:

• Policy changes

• New employee welcome notes

• Holiday messages

• Weekly newsletters

All displayed automatically on your SharePoint page.

---

4️⃣ Live Training Notes & Coaching Updates

Managers can track:

• Team performance logs

• Coaching entries

• Training completions

Each new update becomes a clean, dated post.

---

5️⃣ Customer / Case Updates

Support teams can use this to auto-publish:

• New case updates

• High-priority alerts

• Product release announcements

All feeding into a single page view.

---

🛠️ How It Works (High-Level)

🔹 Step 1 — Create a text file (HomeText.txt)

Stored in a library called DynamicFiles.

🔹 Step 2 — Display it on your SharePoint page

Use the File Viewer web part.

🔹 Step 3 — Create a SharePoint list (DynamicUpdates)

Each new list item becomes a new post.

🔹 Step 4 — Power Automate watches the list

Trigger: When an item is created

🔹 Step 5 — Flow reads the existing file

Using Get file content using path.

🔹 Step 6 — Flow appends a beautiful post block

Here’s the actual formatter expression:

concat(
  body('Get_file_content_using_path'),
  '\r\n\r\n',
  '==============================',
  '\r\n',
  'Post from item ID ',
  string(triggerOutputs()?['body/ID']),
  '\r\n',
  'Title : ',
  triggerOutputs()?['body/Title'],
  '\r\n',
  'Created: ',
  formatDateTime(triggerOutputs()?['body/Created'], 'yyyy-MM-dd HH:mm'),
  '\r\n',
  '==============================',
  '\r\n'
)

🔹 Step 7 — Flow writes the updated file back

Your page updates in seconds.

---

📸 Final Result — What It Looks Like On Your Page

*** Dynamic Posts ***

(New posts appear automatically below)

==============================
Post from item ID 48
Title : Server Down – East Region
Created: 2025-02-01 08:42
==============================

==============================
Post from item ID 49
Title : Connectivity restored – All Clear
Created: 2025-02-01 09:21
==============================

Beautiful. Clean. Automatic.
All from a SharePoint list entry. 🙌

---

💡 Bonus Tip:

Turn on Versioning in your library to preserve full post history.
It’s included in the guide above.

---

🎉 Final Thoughts

You’ve just created a dynamic publishing system on SharePoint with no code, no approvals, and no page editing.

This approach is:

• Lightweight

• Enterprise-friendly

• Easy to maintain

• Perfect for posting updates from any team

Whether you're managing operations, IT service updates, HR communications, or status dashboards — this method gives you live content on your SharePoint page with almost zero effort.