Unanswered

How to get Date format to work when sending Forms via email

Like (0) Share

Report

Posted on 29 Jan 2021 11:10:22 by Community Power Pla...

Hi, I want to show Form dates like 'dd/MM/yyyy'. I have multiple date fields on Forms and I will get next error on power automate if I let some date field to empty on Forms.

Unable to process template language expressions for action 'Condition' at line '1' and column '13822': 'In function 'formatdatetime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'.

It works perfectly if I fill all date fields on Forms.

My date fields looks like this

formatdatetime(outputs('Get_response_details')?['body/rcc776c322f2247e2a45f2c62cd23dc74'],'dd/MM/yyyy')

How to get it working if I let some date field for empty?

I have the same question (0)

All responses (7)

Answers (0)

Community Power Pla... on 29 Jan 2021 at 13:45:47

Like (0)

Report

Re: How to get Date format to work when sending Forms via email

@Mira_Ghaly

I changed it back to not formatted and conditions went through. Now I got again this error on email section.

"ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email_(V2)' skipped: the branching condition for this action is not satisfied."

Was this reply helpful? Yes No
Mira Ghaly 11,409 Moderator on 29 Jan 2021 at 13:30:18

Like (0)

Report

Re: How to get Date format to work when sending Forms via email

@Tuukka

On your left hand side of your conditions u should not add the formatted expression as this will throw error if the parameter passed to the formatdatetime does not contain data so u need to add condition if value is not null then do formatting otherwise don't Format and u can pass a constant.

Was this reply helpful? Yes No
Community Power Pla... on 29 Jan 2021 at 12:57:40

Like (0)

Report

Re: How to get Date format to work when sending Forms via email

Date fields formula's are on conditions and email body:

Date1: formatDateTime(outputs('Get_response_details')?['body/rcc776c322f2247e2a45f2c62cd23dc74'],'dd/MM/yyyy')
Date2: formatDateTime(outputs('Get_response_details')?['body/r814ef78b9dd444689d21747e94a55c5a'],'dd/MM/yyyy')

Was this reply helpful? Yes No
Community Power Pla... on 29 Jan 2021 at 12:51:50

Like (0)

Report

Re: How to get Date format to work when sending Forms via email

@Mira_Ghaly

Was this reply helpful? Yes No
Mira Ghaly 11,409 Moderator on 29 Jan 2021 at 12:41:45

Like (0)

Report

Re: How to get Date format to work when sending Forms via email

@Tuukka

Can u add some screens for ur flow so that I can understand where is the issue?

Was this reply helpful? Yes No
Community Power Pla... on 29 Jan 2021 at 11:55:15

Like (0)

Report

Re: How to get Date format to work when sending Forms via email

@Mira_Ghaly

I tried that already and it didn't work. It goes through that conditions but the next error is

"ActionBranchingConditionNotSatisfied. The execution of template action 'Send_an_email_(V2)' skipped: the branching condition for this action is not satisfied."

Was this reply helpful? Yes No
Mira Ghaly 11,409 Moderator on 29 Jan 2021 at 11:29:02

Like (0)

Report

Re: How to get Date format to work when sending Forms via email

@Tuukka

I believe you need to add a condition to check if the field is not null before applying the format

Was this reply helpful? Yes No