Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Building a collection from a dataverse Filtered table.

i am attempting to  create a collection of filtered items from a dataverse table.

DataVerse table: 4-IEX_Data

Dataverse Table View: Data_Filtered_IEX_Data

Collection: Filtered data


the command I am using is 


       FilteredData, '4-IEX_Datas (Views)'.Data_Filtered_IEX_Data)


The output i get is this.


If i use this command


FilteredData, '4-IEX_Datas')



I get this:


the problem is i am wanting to filter the data,(this is a large table, and is growing each day. i have tried this way, by filtering thee table via a view,


and i tried filtering the collection by using a  lookup table. trimming it down by todays date,


I am stumped, and have spent 12 hours on google foo is weak this week. 


any direction on how to do this would be apprecaited.






Super User
Super User

@90_percent have a Look at the ShowColumns() function


Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

​Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

If the content was useful in other ways, please consider giving it Thumbs Up.
Frequent Visitor

@PowerRanger  Thanks for the suggestion. This will be an answer to the question I have after I figure this out. How to only see the columns I need, versus all 60 columns. 
I will clarify a little more on my issue. It has to do with delegation.
I am wanting to create the collection, based on a lookup. If I use the Lookup field on the column Import_Date, and match it to today (if Present) or Yesterday (if today isn't present), this will bring the returned fields down to roughly 150-200 items, for 4 of the 5 pages.
The 5th page, it will bring it down from 50K down to 9K, that will be a different issue, 😛

Here is what i was thinking this morning. 

 Import_Date = Today()

but the error on this formula is that NewFilteredDate (name isn't valid. This identifier isn't recognized.)
Any Suggestions are welcomed and appreciated.




Helper I
Helper I

Ok, so I have come up with this formula. 

ClearCollect(NewDataFiltered, '4-IEX_Datas');

    Data_Date:  If(Value(LookUp(NewDataFiltered, Ticker = "AA").Import_Date) = Today (), {Date: Today()}, {Date: DateAdd(Today(),-1,Days)})

ClearCollect(TodaysFilteredData, (Filter(NewDataFiltered, Import_Date = varDate.Data_Date.Date)))


thought process, 
1. get all the data that is in the table,

2. look for the latest date for a single record ("AA") and use it to set a variable,

3. use that variable to filter the new Collection of the data into another smaller collection. 

        a. this should give me the data for the most recent date. (either today or Yesterday) 


Its a good thought process, but unfortunately it doesn't work. 


Any suggestions?




Ok, Just updating this for those of you who are following along.

Set(varDate,(If(TimeValue(Text(Now())) >= TimeValue("5:00:00 PM"), Today(), DateAdd(Today(),-1,Days))));

ClearCollect(TodaysFilteredData, Filter('2-Finviz_Stockss', Import_Date = varDate))

This is the formula i am using now, this gets me the date set correctly, and changes at 5pm each day.
the ClearCollect filters down the table to the import Date matching the varDate variable. 

Now the issue is that it only shows 2 columns when I look at the collection. (primary_Key and Import_date)

(credit where credit is due, I got help from people over on the discord channel (PowPco) great resource as well)

Helper I
Helper I

Tonights update - there is a toggle for the issue with the columns-
> Settings > Upcoming features > Preview, and then turn off the Explicit column selection toggle.

now all the columns show up, i will turn it off it causes loading issues.

SO we are getting closer to a full solution



Frequent Visitor

ok. so, I know have the smaller collections working correctly and posting in galleries.

Now i am off to start another thread on how to get past delegation in a large table in the Dataverse!

Thank you all for your help. and hope this helps someone in the future. 

Helpful resources

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,236)