Answered

Birthday Email automation organization wide using power automate

(0) Share

Report

Posted on by aneeshrv

When i try to run the flow condition the below error is coming.

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 'Float'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.

I have already raise a service ticket dated 12/03/2023 to Microsoft support team through power automate admin Centre nobody can assist me till now service request number:2303120030000251.

Kindly help me somebody to solve my issue

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @aneeshrv ,
From the error message you provided:
We can see that the location of the error is in [Condition] in [Apply to each], you used formatDateTime() to change the time format by mistake.

In the error message: You wrote the data of the floating point type (like: "45782.9") into the first parameter of formatDateTime(), which caused the problem. The first parameter of formatDateTime() requires data of type String (like "2023/03/14")

Can you show the screenshot of formatDateTime() in the flow?

Best Regards
Cheng Feng

Was this reply helpful? Yes No
aneeshrv 8 on at

Like (0)

Report
Copy link

Link copied!

Hello Cheng,

Please find the screen shots.

Thanks and Regards,
Aneesh R V

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @aneeshrv
I found that your first formatDateTime() uses the output from the Compose above, please test it, and then check whether the output is String or Float. (under the condition of ensuring the security of personal information) please provide the content to facilitate the modification of the format

Best Regards
Cheng Feng

Was this reply helpful? Yes No
aneeshrv 8 on at

Like (0)

Report
Copy link

Link copied!

Hello Cheng,
Sorry to interrupt you, I am the beginner of this power automation, could you please help to guide me where I can do the modification, once again I run same error is coming. Here I attached the error screen shots and database details.

Thanks and Regards,
Aneesh R V

Was this reply helpful? Yes No
v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @aneeshrv ,
It can be seen from your data source that the BirthdayDay column is a float type, which does not meet the standard date format Iso8601 format.

(For your date format, I have not seen it), you could tell me what this 32.114 means.

Best Regards
Cheng Feng

Was this reply helpful? Yes No
aneeshrv 8 on at

Like (0)

Report
Copy link

Link copied!

Hello Cheng,
First we have upload an Employee List Excel sheet data in table format in SharePoint.So that table format power query editor check the formula like this "= Table.TransformColumnTypes(Source,{{"EmpNo", Int64.Type}, {"EmpName", type text},"
The screenshots are attached here
I watch the below vide and try to perform this
Link Video:https://www.youtube.com/watch?v=OBkocffNKhs

Was this reply helpful? Yes No
Verified answer

v-chengfen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @aneeshrv ,
Why not use the Iso8601 format to store birthdays?
This is more friendly and easier to compare.
If you don't want to format uniformly and still want to use the current date:
Please use this:
formatDateTime(addDays('1899-12-30',int(replace(string(outputs('Compose')),'.',''))),'MM-dd')

Best Regards
Cheng Feng

Was this reply helpful? Yes No
aneeshrv 8 on at

Like (0)

Report
Copy link

Link copied!

Hello Cheng,

Now everything is fine the program is running successfully.
but some challenges I am facing this.
when run the program the out put(Birthday Automation mail) is sending with different images in each members.
This is the image variable "rand(1,4)", but 3 users different image received 1 user same as like out f these 3
another challenge is when we do some changes in SharePoint database(integrate with power automate) like data deletion or addition after that we run the workflow it will come error.

Was this reply helpful? Yes No