Unanswered

Create a GET request to extract the contents (the actual data) of a List View in a Sharepoint

(0) Share

Report

Posted on by Community Power Pla...

Hi guys,

I need to extract the data of a sharepoint list view and send it to Power BI, but there's no connector between a sharepoint list view and Power BI yet, so I'm exploring other options.

Is it possible to get the data from a sharepoint list view through a GET http request?

I would like to know how please.

Thanks guys!

All responses (5)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Create a GET request to extract the contents (the actual data) of a List View in a Sharepoint

Hi @CFernandes,

Thanks for your message.
I tried this and I'm getting the metadata of the view, which is good but I also need to extract the actual data within the view.
Appreciate the help (:
Thanks&Regards,
Ottmar V
CFernandes 8,295 Most Valuable Professional on at

Like (0)

Report
Re: Create a GET request to extract the contents (the actual data) of a List View in a Sharepoint

@Anonymous Hey Mate,

If I understand correctly, you need to query a view in the list.

If yes, you can use the HTTP action and query

/_api/web/lists/getByTitle('<listTitle>')/Views/getbytitle('<viewTitle>')

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Diksha 301 on at

Like (0)

Report

Re: Create a GET request to extract the contents (the actual data) of a List View in a Sharepoint

Hi @Anonymous ,

The Power Automate actions to get the items from SharePoint list does not have option to specify the specific view name of list. However, the workaround you can do is to apply filter while fetching data from SharePoint.

I have answered to the similar question here. Please check once.

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .
Thank You !!!
Diksha 301 on at

Like (0)

Report

Re: Create a GET request to extract the contents (the actual data) of a List View in a Sharepoint

Hi @Anonymous ,

The Power Automate actions to get the items from SharePoint list does not have option to specify the specific view name of list.
However, the workaround you can do is -

1. When you have created a view , you must have applied some filters to show filtered items from the list.
2. Use Get items action of Power Automate.
3. Apply the same filters you have applied while creating a view in Filter Query option of Get items.

By this, you will get the same set of items that are there in SharePoint list view .

If this answered your question, please mark this question as answered and if you liked my response, please consider giving it a thumbs up .
Thank You !!!
Community Power Pla... on at

Like (0)

Report

Re: Create a GET request to extract the contents (the actual data) of a List View in a Sharepoint

Oh! I missed to mention, I'm trying to achieve this using Send an HTTP request