cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Darren137227
Resolver I
Resolver I

The value provided for date time string (value) must match ISO 8601 format.'.

Hi, 
I have a list row action where I am trying to only pull records where the expiry date + 15 days is equal to the current date

 

So Initialized a variable called CurrentDate and set to utcNow()

Then Initialized another variable after above action called  'FormattedCurrentDate' and set it to:

 
formatDateTime(variables('CurrentDate'),'yyyy-MM-dd').
 
So far so good.
Then, i
n my list Rows action in Filter rows I put  the expression
addDays('scor_expiry',15,'yyyy-MM-dd') eq FormattedCurrentDate. 

'scor_expiry' is a Date field in my table that I want to compare on...

 However I get the error:
Unable to process template language expressions in action 'List_rows' inputs at line '1' and column '9851': 'In function 'addDays', the value provided for date time string 'scor_expiry' was not valid. The datetime string must match ISO 8601 format.'.

Any help on this  is appreciated

Darren137227_0-1638981635191.png

 



 
1 REPLY 1
abm
Super User
Super User

Hi @Darren137227 

 

Your filter row expressions are not quite right. On the left hand side you need the Dataverse column name to compare against another date. Here you have addDays() expression which will return another date not the column value which you want to filter against? Could you explain bit more about your requirement?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Users online (1,401)