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

Question

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

bahadrdsr · Accepted Answer · 2020-11-12 18:22:44Z

1

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).

answered Nov 12, 2020 at 18:22

bahadrdsr

4743 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gonzalo Ocampo Over a year ago

You are my hero! But I have another problem, because that video shows how to do it with SQL, so how can I do it with SharePoint? I've been trying for hours...

SeaDude · Accepted Answer · 2020-11-18 04:11:14Z

1

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.

answered Nov 18, 2020 at 4:11

SeaDude

4,4869 gold badges50 silver badges94 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related