web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows A text field contains ...

Power Automate - Building Flows

Unanswered

A text field contains invalid data

Like (0) Share

Report

Report

Posted on 27 Nov 2020 15:57:22 by NS-10041416-0

64

Hi,

I have a field called ApprovalDate2.

ApprovalDate2 column is of type single line of text.

I am updating the above field with todays date in the update item action as below

formatDateTime(utcNow(),'MM-dd-yyyy')

But I am getting the error as below. Please let me know if I am making any mistake

'A text field contains invalid data. Please check the value and try again.'

Regards,

Sudheer

All responses Img

All responses (2)

Answers Img

Answers (0)

Ahmed-Eid Microsoft Employee on 22 Sep 2022 at 14:18:16

Like (0)

Report

Re: A text field contains invalid data

Try changing the column format in the SharePoint List from "Single line of Text" to "Multiple Lines of Text"
abm abm 32,506 Most Valuable Professional on 27 Nov 2020 at 16:23:23

Like (0)

Report

Re: A text field contains invalid data

Hi @sudheermadduru1

FormatDateTime returns a string value so that should work as expected. Are you sure this error is related to ApprovalDate2 formatDateTime() value? Try also formatting without the hyphens.

formatDateTime(utcNow(),'MMddyyyy')

I am not suggesting to remove hyphens as a suggested solution but lets see what error you get?

Thanks

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 2

#2

David_MA 436 Super User 2025 Season 2

#3

Riyaz_riz11 244 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans