Unanswered

Issue with Converting Date and Time Format from SharePoint List to HTML Table

(0) Share

Report

Posted on by MGIOSEFFI

Hi everyone,

I am working on a new flow that pulls a list of tasks from a SharePoint List, converts it into an HTML table and then automatically sends this list to a group chat on Microsoft Teams. I am having a lot of trouble trying to change the date and time format from one of the fields in the SharePoint List. I have tried numerous expressions and have been researching this for days, but nothing seems to be working.

Here is a screenshot of my flow:

Processs Flow.PNG

The default date and time format that is showing up is the following "2024-04-11T04:00:00Z". I have tried to create an expression for "Due Date" as part of the "Select" step of my flow to change the date and time format. I am using the following expression:

if(empty(body('Get_items')?['Received from']), null, formatDateTime(body('Get_items')?['Received from'],'yyyy-MM-dd')).

For context, the field that I am trying to pull this from in my SharePoint List is a tasking due date column with simple date and time picker. Some fields in this column may not have a date or time indicated. What is strange is that when I run this flow, I can see the Due Date outputs I am getting at the 'Select" step are all "Null", even for items that I have a date and time indicated in the SharePoint List.

Any help you could provide would be greatly appreciated as I can't seem to find a solution!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report
@MGIOSEFFI You need to adjust your expression.

if(empty(item()?['Received from']), null, item()?['Received from'],'yyyy-MM-dd')).

You might find my tutorial helpful: Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.

This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:

📅 Student Birthdays

📅 Project Due Dates

📅 Contract/Membership Renewals

📅 License Expirations

📅 Client Anniversaries

IN THIS VIDEO:

✅ How to Send an Email based on a Date Column in SharePoint

✅ Using the Recurrence Trigger in Power Automate

✅How to Use the Filter Array Action with multiple conditions

✅ How to Get Dynamic Content from a Filter Array Action

✅How to Get a Date Three Days from Today

✅ How to Create a Dynamic Date Based on utcNow()

✅ How to Return a Count of Items

✅ How to initialize and set a variable

✅ How to use the Send an Email (V2) action

✅ How to send test emails

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
MGIOSEFFI 32 on at

Like (0)

Report

@creativeopinion Thank you so much!! That mostly solved my problem. However, I now realize that all of the times in the format I want have not been converted into UTC. Is there something I can add to the expression to ensure the time shown is for my current time zone?

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
@MGIOSEFFI You'll need to use the convertFromUtc() function for each of your dates.

convertFromUtc([timestamp], [timezone], [datetime format pattern])

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
MGIOSEFFI 32 on at

Like (0)

Report
@creativeopinion I am sorry for all of my questions. I am fairly new to power automate. How can I utilize that expression along with the one you sent earlier:
if(empty(item()?['Received from']), null, item()?['Received from'],'yyyy-MM-dd'))

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report
@MGIOSEFFI Replace the dynamic content dates with the convertfromutc() expression.

if(empty(item()?['Received from']), null, item()?['Received from'],'yyyy-MM-dd'))

Was this reply helpful? Yes No
MGIOSEFFI 32 on at

Like (0)

Report

@creativeopinion is it possible to please send me some sort of screenshot? I am having trouble understanding what you mean by "replace the dynamic content dates"?

Was this reply helpful? Yes No