Hi,
im wondering if someone could asist i have created a SP list and have a calculated column (Datenr) which will add days depending on the type selected :
=IF(OR([Document Type]="Policy",[Document Type]="Procedure",[Document Type]="Rail Form",[Document Type]="Rail Procedure",[Document Type]="Manual",[Document Type]="Objective"),[Date of Review]+365,[Date of Review]+730)
this all works great , but i wanted to create a workflow that would then notify the owner of the document that they had upcoming reviews in the next 30 days ,
so in the get items if tried a Filter Query using : (the reformat outputs are because i had to mess around with the date formats as it wouldn't run properly at all )
(Datenr ge '@{outputs('Reformat2')}' and Datenr le '@{outputs('Reformat')}')
but the flow always fails with :
The field 'Datenr' of type 'Calculated' cannot be used in the query filter expression.
i thought about a filter array but it only allows one option so cant add the and part above ?
any help or pointers would be great
thanks
paddi

Report
All responses (
Answers (