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']

View solution in original post

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']

View solution in original post

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 Power Automate Community Manager
Are YOU a member of your local Power Automate User Group?
Fill out This Form to claim your Community User Group Member Badge!

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (3,782)