Unanswered

Birthday Automation

(0) Share

Report

Posted on by MImran

Hi can someone help me out, as getting error as "Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Array'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'."

attached screenshot for reference.

What I actually selected the format in Condition

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

Hi @MImran ,

Could you share the expression you are using in the condition action?

Best Regards,

Wearsky

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

You are trying to convert an array (a list of items) to a date and that is not allowed. What you need to do is convert a single string.
We would need to see the exact expressions of both of your formatDateTime() expressions to provide more specific guidance.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No
MImran 10 on at

Like (0)

Report

thank you for the respond, here the screenshots.

for the 1st one is formatDateTime(outputs('compose'),'MM/dd'

2nd one is formatDateTime(utcNow(),'MM/dd')

Was this reply helpful? Yes No
MImran 10 on at

Like (0)

Report

thank you for the respond, here the screenshots.

for the 1st one is
formatDateTime(outputs('compose'),'MM/dd'

2nd one is
formatDateTime(utcNow(),'MM/dd')

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @MImran ,

Thanks for the clarify.

The value of the compose is wrong.

It seems that you have a date column in SharePoint list, and you want to compare it with utcnow(), right?

If my guess is right, please use items('Apply_to_each')?['DateColumnName'] here.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

I would argue that the compose is probably not even necessary at all. The expression suggested above can be used directly in the formatDateTime() expression resulting in formatDateTime(items('Apply_to_each')?['DateColumnName'],'MM/dd') for the first operand.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.
If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

Was this reply helpful? Yes No
MImran 10 on at

Like (0)

Report

Getting the same error after updating

Was this reply helpful? Yes No
MImran 10 on at

Like (0)

Report

Hi,
Getting the error again to run a flow

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

You do not need the Compose action there. You're not using it anyway, as far as I can tell.

As for the other error, it is a different one. It says the date you are trying to convert is not recognized as a date, because it is in an unsupported format. Can you share what the dates look like in your inputs?

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @MImran ,

Please use 'Apply_to_each' here.

Best Regards,

Wearsky

Was this reply helpful? Yes No