Forum Discussion

pratk30's avatar
pratk30
Advocate I
8 years ago
Solved

Filtering OData queries result [Project Online]

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.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    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. :smileyhappy:

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

     

    Regards

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    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. :smileyhappy:

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

     

    Regards