cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Brice235i
Level 8

How to add SharePoint Date Column to Expression

Hello there, I've successfully added a condition for a SharePoint Event List Start Date.

The condition checks if the even start date is equal to UTCnow.. which will trigger the flow to run.

formatDateTime(items('Apply_to_each')?['EventDate'], 'yyyy-MM-dd')
condition.PNG
 
However, I need to add a similar workflow that fires on the Escalation date & time column.  I enter this column name in place of 'EventDate' and the flow fails.
formatDateTime(items('Apply_to_each')?['Escalation'], 'yyyy-MM-dd')
The error message is:
error.PNG
Wondering if anyone has any ideas on this.
 
Thank you!
1 ACCEPTED SOLUTION

Accepted Solutions
Brice235i
Level 8

Re: How to add SharePoint Date Column to Expression

Hi, actually this formula is correct.  It was the column name causing the problem.

If you have a space in your actual column name it is should be written as: 

['Escalation_x0020_Date']

2 REPLIES 2
Brice235i
Level 8

Re: How to add SharePoint Date Column to Expression

Hi, actually this formula is correct.  It was the column name causing the problem.

If you have a space in your actual column name it is should be written as: 

['Escalation_x0020_Date']

Highlighted
Administrator
Administrator

Re: How to add SharePoint Date Column to Expression

Hey, @Brice235i!

Thank you for posting on the Flow Community! I have moved this post to the "Building FLows" forum board as it fits better here for when users are searching in the future.

-Gabriel

Flow Community Manager

-Gabriel
Microsoft Flow Community Manager

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 208 members 4,591 guests
Please welcome our newest community members: