Announcements
Hello,
I need to change the format for the Date Due column. But I keep getting an error.
this is the format I do not want
this is the HTML table and the expression I used
the error
@Alondrae05
I think your expression is incorrect, it should be:
formatdatetime(item()?['Due Date *****'], 'MM/dd/yyyy')
You missed of one Y from the YYYY.
Try that and see how you get on.
Regards,
Andrew
Hi @Alondrae05,
I think the reason why you have this issue is that you have empty date value in your SP list.
You just need to modify your expression as below:
if(equals(item()?['DateDueColumn'],''),null,formatdatetime(item()?['DueDateColumn'], 'MM/dd/yyy'))
It gave me the following error.
HI @Alondrae05,
Modify as below:
if(equals(item()?['DateDueColumn'],null),'',formatdatetime(item()?['DueDateColumn'], 'MM/dd/yyy'))
Actually, it is better that you could show me how you write your expression.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 227
David_MA 204 Super User 2026 Season 1
Valantis 177
