CODEWITHSUNDEEP
sharepointdatatablepowerapps
Gonzalo Ocampo
Gonzalo Ocampo

Reputation: 11

How to select a specific view from SharePoint Online list on PowerApps

In SharePoint I have a list of orders. There are a lot of columns, but the limit to LookUp is limited. I want to show just a few columns in a DataTable. How can I select a view that only has a few columns? Even if I can't select a view, how can I solve it?

Thanks for your time!

enter image description here

Upvotes: 1

Views: 1883

Answers (2)

SeaDude
SeaDude

Reputation: 4375

Try using ShowColumns() or DropColumns().

Example:

ClearCollect(colData,
    ShowColumns(
        BIG_SHAREPOINT_LIST,
        column1,
        column2,
        column3
    )
)

Then ONLY columns 1, 2, 3 will appear in the Collection. Easy.

Upvotes: 1

bahadrdsr
bahadrdsr

Reputation: 474

This is not possible right now. There is a feature request here.

However, there is a hacky workaround. You can filter your desired columns in power automate and use that as a data source in power apps. Here is a video tutorial about it (Not my video).

Upvotes: 1

Related Questions