Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Help with a SharePoint list template

(1) ShareShare
ReportReport
Posted on by
Greetings, I'm experimenting with one of the new SharePoint List templates, specifically the "Content Scheduler with Approvals". Awesome new feature! Once the approval is finalized, I have a second workflow using a manual trigger to move the item (and attachment) to a SharePoint Library. This works well. Then, I decided to add one more function to the end of the second workflow that goes back to the original SharePoint list and changes the published status from "Draft needs approval" to "Published". This too worked well, except that it resets the approval status back "Not Submitted".

OK, it makes sense that changes made to an item after an approval will reset the approval status. But what is the point of the Publish Status beyond its original purpose? Once the draft has been approved to publish, it makes logical sense that (after publishing) I would want to update the publish status field to "Published". However, once approved, the "approval status" still show as approved, but the publish status column will still say "Draft needs approval". So, no matter what option you choose for the publish status, it can never change after an approval completes. It almost seems like you would need to send a draft out for an approval and, once approved, turn around again and send another approval to "Publish" the item. Surely not.

Maybe I don't understand the purpose of the Publish Status column. I also thought about updating the Publish Status and the Approval Status (back to Approved), but the Approval parameter isn't available in the Update Action. There's also a field called "Published Link" to add the URL where the item has been published. However, you wouldn't be able to add that after the approval without reseting the approval status. What am I missing here?
Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard