Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get Data from a Sharepoint


I´m not able to get data from my Sharepoint. I´m only able to add the whole folder from the Sharepoint, but can´t get the data from the folder. Does anyone no what the Problem is?


Thanks for help.


Accepted Solutions
Not applicable

I had a mistake in my thinking. It was stupid from me. But thanks for helping.

View solution in original post

Skilled Sharer
Skilled Sharer

Hello @Anonymous,


If I'm interpreting your screenshot correctly, you are about to add a new data source to your app. To get a specific row from your SharePoint list, you would first have to add the list containing the row into your app, by selecting it in the dialog in your screenshot.

Next, you can retrieve a single record from your list.

There are multiple ways to do this, for example if you want to display them in your form control:

  • Using the First(MyList) function if you have only one entry in your list
  • Using the LookUp formula: LookUp(MyList, ID=1234)
  • Using a Gallery, setting the Gallery's data source to 'MyList', and then using Gallery.Selected to retrieve the row selected in your Gallery in the Form
Community Support
Community Support

Hi @Anonymous,

Do you want to access the data you store within the folder?

Actually, you could only get the metadata of the file in sharepoint, like the file's link, the file's name.

I am afraid that it is not supported to access data from the file storing in SharePoint library.

If you want to access the Excel data storing in the folder from SharePoint library , you could only connect with excel on one drive currently.

Then you could get excel content of this file.

Also, you could consider choose "imported from excel". You could also connect with excel content in this situation.

But please notice that:
you will get a static table by choosing this. (Could only view data, can not write data)



Best Regards,
Not applicable

I had a mistake in my thinking. It was stupid from me. But thanks for helping.

Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,974)