Filter Query - Get file properties based on calculated column due date

[irene]

I am trying to use the Filter Query options in a Get Files Properties from SharePoint action.

The SharePoint Document library contains a calculated column 'DueDate'.

i want to get items with where DueDate equals today

Help would be much appreciated.

Thanks,

[v-bacao-msft]

Hi @irene ,

Currently, Filter Query does not support configuring Calculated column as a filter parameter.

{
  "status": 400,
  "message": "The field 'DueDate' of type 'Calculated' cannot be used in the query filter expression.\r\nclientRequestId: 9cbfe98d-f39b-4a32-88be-97b4bed87dc6\r\nserviceRequestId: 23fbc39e-008f-8000-1099-ac01787ba94e"
}

You could use Filter array to filter the files that match the criteria. Filter array accepts the field of type Calculated column as the filter condition.

Image reference:

Please take a try.

Best Regards,

[irene]

Hi @v-bacao-msft  , thank a lot for this solution. 

in my case i have 3 due dates(two of them are calculated columns, the third is date time column) with 3 different emails. 

please what should i use?

Bests, 

[v-bacao-msft · Accepted solution]

Hi @irene ,

You could consider adding a parallel branch and filtering the files using the fields you mentioned.

The action of each branch configuration is similar, as below:

Please take a try.

Best Regards,