Power Platform Community Forum Thread Details

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!