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... Microsoft Employee

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!

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Diksha 301 on at

Like
a
(0)

Report
Copy link

Link copied!

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 !!!

Was this reply helpful? Yes No
Diksha 301 on at

Like
a
(0)

Report
Copy link

Link copied!

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 !!!

Was this reply helpful? Yes No
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No