Date not showing in dynamic content

(1) Share

Report

Posted on by CG83

Hi all,

I have a flow set up which emails a report of all open repair requests within our datasource (excel). This is working well, but I cannot format the date correctly as it is not appearing within the dynamic content options in my Select step. I have read a few blogs regarding this, but cannot make any of the solutions work within my flow.

My steps are below:

Currently, the expression in the 'Next Chase Date' entry within the select step is:

formatDateTime(item('List_rows_present_in_a_table')?['ChaseDate'],'dd/MM/yyyy')
 
This is coming through as a failure and I cannot resolve this. 
 
I want to use the 'ChaseDate' column of the entry, but formatted as dd/MM/yyyy. 
 
Is anybody able to help?

Categories:

Business Process Flows

All responses (1)

Answers (0)

Expiscornovus 31,732 Most Valuable Professional on at

Like (0)

Report
Date not showing in dynamic content

Try this expression instead:

formatDateTime(item()?['ChaseDate'],'dd/MM/yyyy')