Flow to get sharepoint list to powerapps will all columns (including person column fields etc)

[ardak2]

Hello I have a SharePoint List with many columns, some are single text, some are multiple text, choices, number, date etc. In my powerapp, if I connect this SharePoint list direct as a data source, I can use it as data source to my "data table". Columns and all other data perfectly shows. But due to the reason that I dont want end users to have access to this sharepoint list, I want to bring the information thru a flow. 

Attached is the screenshot for my flow. 

And I use this function on a button's onselect property: 

ClearCollect(DataTableSource2, '2_PowerApp->Getitems'.Run())

As you can see in screenshot, data table does not recognize the columns. My SharePoint has like person column, which as DisplayName, Email etc. So just like connecting the SP List directly, I want all fields of objects etc to be available for data table to use. Please help this is really urgent. Thank you

[ardak2]

And as you can see in screenshot, i can use the same data I used in gallery (the upper one) in data table (lower one) but it does not show more than one column, whereas I want it recognize the columns automatically just in the same fashion that it would do it in direct connection to sharepoint as data source. 

[JatinSaini]

On your Flow image, it seems that while getting the items the top count is way too high. 

THe max limit is 5000. If you have more than that, then enable the pagination within that get items action setting.

[JatinSaini]

On your Flow image, it seems that while getting the items the top count is way too high. 

THe max limit is 5000. If you have more than that, then enable the pagination within that get items action setting.

[ardak2]

My items are around couple hundred only, and pagination is turned on to 5000.

[Pstork1]

What are you using as the Items property of the embedded data table? When you bring the data back from the Flow you will load it into a Collection.  When you use that Collection as the Data Source you should be able to access all the columns.

[ardak2]

Hey Sir, please see attached screenshots. I kept trying, and this is the closet i could get. With the setup of flow and items of data property, i could have columns to show in “edit field” section of data. However, as you can see, I had to use Select function to convert output of get items to a simpler array. But what I ideally like to manage is the get everything in get items over to app. So that even objects (like person column with subfield DisplayName, Email etc) can be referenced in the data table and any other function (like a button to send email to person column’s email value). Is that doable?

in case you cannot see photos

flow: Power App (v2) > get items > select > response (premium)

button to call flow: 

ClearCollect (output7, '3_PowerApp-›Getitems’ . Run ())

Data table items: output7

3 column and values successfully shows. 

 

 

 

 

[ardak2]

@Pstork1 Forgot to mention you for above reply sir

[Pstork1]

Based on the screenshots check that the flow is actually returning data.  I would suspect something is wrong either with the Data Select or the HTTP response.  What does the collection look like after you run the flow and return the data?

[ardak2]

@Pstork1 Sir, here are the screenshots of how app looks with the data I managed to get and screenshot of the response output from the flow. Again, this kindda serves to the purpose. However, I have to list each column in the Select function of the output, and output is an array not an object. For example, for person column in sharepoint list, I have to do couple rows in Select function as person column is an object with sub-values has displayname, email etc. So I am trying to get all fields to the app in a rich format so that i can use thisitem.selected.projectmanager.displayname. I.e. same fashion of rich data same as connection sharepoint list directly as a data source rather than pulling it with a flow. hope this makes sense. appreciate your help.