Unanswered

Pull Stream on Sharepoint likes and views and feed data into an excel

(0) Share

Report

Posted on by Tracy_ngu

Does anyone know if it's possible to use Power Automate to fetch Stream on Sharepoint likes and views count and feed the info into an excel sheet? And also have the info automatically update once someone likes or views a video.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,194 Most Valuable Professional on at

Like (0)

Report
Hi @Tracy_ngu,

Since this is Stream on SharePoint you should be able to use the Get itemAnalytics method to get the views of an item in a library:

https://learn.microsoft.com/en-us/graph/api/itemanalytics-get?view=graph-rest-1.0&tabs=http

I am not sure about the likes though. I will have another look for that part.

Below is an example to get the views of a single item

_api/v2.1/drives/@{variables('DriveId')}/items/@{variables('DriveItemId')}/analytics/allTime?$expand=activities($filter=access ne null)&$select=access/actionCount

Was this reply helpful? Yes No
Tracy_ngu 26 on at

Like (0)

Report

Hi @Expiscornovus,

Sorry, I'm a beginner in Power Automate.

What should I select for DriveId and DriveItemId? I'm not sure if the view data I can pull from is from the view column field we created or the analytics built into Sharepoint. I'm trying to get data from the latter as per below.

Also, after that, would I need to add another step to feed the data into Excel Online?

Was this reply helpful? Yes No
MBB 4 on at

Like (0)

Report

What was your trigger?

Was this reply helpful? Yes No
MBB 4 on at

Like (0)

Report

What are the variables DriveId and DriveItemId?

Was this reply helpful? Yes No