Sharepoint records or sub-lists inside the list

[vladimir84]

Hi everyone,

You know those connected sublists, tables, records within a Sharepoint? 

The question is how to get that in Powerapps inside a collection or as a data source?

Take a look at the screenshot I took form PowerBI.

[v-yutliu-msft]

Hi  @vladimir84 ,

Could you describe more clearly about the data in sharepoint that you want to connect with?

Please show me the data 's screenshoots in sharepoint.

Currently, you could only connect powerapps with sharepoint list and sharepoint document.

Others are not supported yet.

You just need to click View->data source->sharepoint->choose the list/document that you want in your app.

Then the connection will be created.

 Here's a doc about how to connect with sharepoint for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-onlin...

Best regards,

[vladimir84 · Accepted solution]

Thank you, but no, this is not what I mean, it's obvious that I already managed to connect to the Sharepoint list...I cannot share the data, however the scenario is clear: I have nested records inside a Sharepoint list and I need to access it.

I found the solution, so I'm posting it for others for reference:

First, you collect the nested field from Sharepoint into a collection of its own like this:

ClearCollect(collectionName, Dropdown.SelectedText.Country.Value);

You will notice here the PowerApps is letting you select the nested tables inside the list.

Second (if you need the value in a variable), you set a variable as the first value from that collection

Set(variableName,Text(First(collectionName).Value))