You’re offline. This is a read only version of the page.
Hello,
I'm new to Flow and am struggling a bit. I’m hoping one of you talented folks might be able to help out.
In summary, I am trying to create a Flow that would send a reoccurring (weekly) email to users that summarizes the new articles we have recently posted on SharePoint 365. It seems like this should be easy but I cannot figure it out.
Some additional requirements:
So far I have tried the following:
Thank you for your help! Any ideas you can provide would be much appreciated.
You can use the 'Parse JSON' action in Power Automate to make it easier available as dynamic content. In the Parse JSON action us this schema on the body of the HTTP request:
The NEWSPAGE ID is available as Dynamic content from the Get Items block.
I got the SITE PAGES ID from @RezaDorrani 's post: Get the ID of a Sharepoint List.
Another method to obtain the SITE PAGES ID is here.
Now, I only need to find out if there is an elegant way to retrieve the value from the HTTP request block, or I use the slice function to strip the unnecessary characters off the body:
{
"odata.metadata": "https:// bla bla bla",
"value": " the entire page is here! "
}
thank you, @Anonymous ,
I'm struggling finding the SITEPAGES LIST ID and NEWSPAGE ID.
From a Get Items block I see some lines that may or may not be the NEWSPAGE ID. I have no clue as to where to obtain the Site Pages ID.
"{Identifier}": "SitePages%252f05-08-2022.aspx",
"{ContentType}": {
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedContentType",
"Id": "0x0101009D1CB255DA76424F860D91F20E6C411800EC33C5EB059A8349BB2806C04F0AE5A3",
"Name": "Página del sitio"
},
"{ContentType}#Id": "0x0101009D1CB255DA76424F860D91F20E6C411800EC33C5EB059A8349BB2806C04F0AE5A3",
"{VersionNumber}": "1.0"
@MO, yes there is a way to get the entire page's content. You can achieve it by making an HTTP request to SharePoint with the following URI:
_api/web/lists(guid'SITEPAGES LIST ID')/items(NEWSPAGE ID)/CanvasContent1
Use the following headers:
accept: application/json
odata: nometadata
On this site they explain it using another URI, but the idea is the same:
Is there a way to email the entire page content? not just the first paragraph from "Description".
@Anonymous I hope you are doing well in these challenging times.
Do you mind to share your entire flow? I'm trying to create the exact same but I'm unable to? I tried different approaches in Power Automate, I also made use of the News Digest-option in SharePoint but that option is quite basic an no custom modification can be done. Thank you very much.
Regards,
Bart Van Eynde
Hi @Anonymous I wrote this blog article a while ago, see if this answers some of your questions. If not, I'll be happy to answer anything.
https://collab365.community/using-flow-sharepoint-news-notifications/
Thank you so much for your help! I'm still playing around with this but I think it should work.
Hi kharris1,
you are doing good.
just make use of the var very useful feature. initialize a string var and do the loop on him always appending the data you need
after that you can send it once in one email
hope this helps a bit and if you need further information just ask
Share
Report
All responses (
Answers (
261
