Can't convert string to date

(1) Share

Report

Posted on by EpicTriffid

364

Hi all,

I'm having real trouble here. I have a SP column called FDate that is a string. It needs to be a string for it's use in PowerApps. I'm trying to build a GetItems Filter Query that compares whether or not it is in the future. A really minor thing, but I can't get it to work. For example, my date might be 23/11/2023. Comparing to utcNow throws up the error it is in the wrong format.

I've tried to following commands for converting it:

parseDateTime('FDate','en-US','yyyy/MM/dd')

formatDateTime('FDate, 'yyyy/MM/dd')

concat(split('FDate','/')[2],'-',split('FDate','/')[0],'-',split('FDate','/')[1]) --- (this gives me an error about the [2] being outside array?)

Nothing works. I've also tried to above on the utcNow portion to see if I can convert that to be the same. Nothing.

Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @EpicTriffid

You need to use split and concat() expression together. See this article below

How to Convert a String to Date in Power Automate - Power Tech Tips

Thanks

Was this reply helpful? Yes No
EpicTriffid 364 on at

Like (0)

Report
Hi @abm

Thank you for the reply!

I have already tried that with this, I believe:

concat(split('FDate','/')[2],'-',split('FDate','/')[0],'-',split('FDate','/')[1])

However, I notice your link has this occurring in several steps using Compose actions. If it needs to be done that way, how would I get the value from SharePoint to run it through the Compose actions to then feed it back into the Filter Query?

Was this reply helpful? Yes No