How to get all values when creating a collection from Dataverse?

(0) Share

Report

Posted on by Aurora

364

Hi All,

I am trying to create a collection from a Dataverse table. When I do, I get the unique identifier for each item, as well as a value for the field I used for the filter criteria. Is there a way I can easily bring in more columns at the same time as running this formula?

ClearCollect(colConnectorsEdit, Filter('Wire Harness Connector Collections', 'Quote #' = Gallery2.Selected.Result))

I would like to bring in most of the values in the image below:

can anyone help me add values like cost and terminalqty to my collection?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@Aurora

Since Collections are highly inefficient, they do not bring in all the columns like some other functions would.

In your case, you will only get the columns you specify in your Filter.

This is all due to an efficiency feature in PowerApps. It is called "Explicit Column Selection".

So, if you really want to duplicate all of your column data into app memory, then you need to turn that feature off in your app features list.

I hope this is helpful for you.

Was this reply helpful? Yes No
Aurora 364 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

I need to bring in 9 columns from my data source, but not all of them. The reason I am using a collection in the first place is because this app is used to build quotes for parts, but often a quote cannot be finished in a single setting, so it needs to be saved for later. A quote can be open ended, so there is not really a standard for what parts they normally do or do not have included in them... so I create collections while the app is being used, and give the user the option to save them if they need to exit the app.

I then intend to re-load the data from dataverse into a collection if they need to resume later, as the app uses a few collections already to calculate a final price and estimate what parts are still required. Do you know of if there is a more efficient way to achieve this process? I figured collections made since as they can become quite large (a collection in the app could have 50+ rows, and there are 5 collections) and did not want to run a bunch of calculations using our internet connection, as it can be slow.

I know this a bit outside the scope of the original question, but if you have any more feedback, I would appreciate it.

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (2)

Report

Copy link

Link copied!

Hello, @Aurora, You can use ShowColumns function to only get the columns that you need.

ShowColumns( Table, ColumnName1 [, ColumnName2, ... ] )

Table - Required. Table to operate on.
ColumnName(s) - Required. Name(s) of the column(s) to include. You must specify a string (for example, "Name" with double quotes included) for this argument.

Also, when using the "Explicit Column Selection" feature, that data of those columns that are not showing in the Collection view, will be retrieved when the column is used inside your app.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Aurora

Not sure that your current approach is bad. Especially if you have a need for an in-memory database-like table (add/remove/edit ability) - That is what a collection brings to the table. Beyond that, it is just a normal table.

Were you able to get all your columns though that you wanted?

Was this reply helpful? Yes No
Aurora 364 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes,

Yes, between you and @AhmedSalih I am now able to get the data I need, and only the data I need. Thanks!

Was this reply helpful? Yes No