Filtering OData queries result [Project Online]

[pratk30]

Hi folks,

I have pulled one table using Odata query. 

let
Source = OData.Feed("SiteURL/_Api/ProjectData"),
Assignments_table = Source{[Name="Assignments",Signature="table"]}[Data]
in
Assignments_table

This table having some column like Project, Resource, task etc. all are record type.

Is there any idea how to filter all this rows based on some conditions. And these conditions should be applied on these columns's record. There is option of expanding these columns, but getting some error while expanding due to large data. Hence need to know any filter code without expanding these columns.

[v-ljerr-msft · Accepted solution]

Hi @pratk30,

I'm wondering if you could firstly create new columns to get filtered record columns, then delete the original record columns, and last expand the new ones in your scenario.

The query below to create a new column to get filtered record columns for [Baseline] is for your reference. 

=Table.SelectRows(Table.FromRecords([Baseline]), each condition applied on columns within record)

Regards