8
I have a flow that runs a query against a database and puts it into a CSV table
The date in the query returns in the ISO 8601 format (e.g. 2023-10-11T00:00:00), but I need it to have dd/mm/yyyy
the select portion is just to rename column headers as i need the space between words, and no square brackets.
I used this expression item()?[Column Header]. Tried to wrap a format time around this but it didnt work
This returned Blank
a bit more context
My output looks like this:
my dax query i run is:
Share
Report
All responses (
Answers (
DEFINE
VAR __DS0FilterTable =
FILTER (
ALL('Combined CACSTOREADVICE'),
'Combined CACSTOREADVICE'[Start Date] >= TODAY() &&
'Combined CACSTOREADVICE'[Start Date] < TODAY() + 7
)
VAR __ColumnsToSelect =
SELECTCOLUMNS (
SUMMARIZE(
__DS0FilterTable,
'Combined CACSTOREADVICE'[Start Date]
),
"Start Date", 'Combined CACSTOREADVICE'[Start Date]
)
VAR __FilteredColumns =
FILTER (
__ColumnsToSelect,
NOT ( ISBLANK ([Start Date] ) )
)
EVALUATE
__FilteredColumns
After this I have to rename the columns:
using the item()?['Combined CACSTOREADVICE[Start Date]']
Hi @ADDLarter ,
Try this:
Unfortunately it doesn't work, I get this:
'The template language function 'formatDateTime' expects its first parameter to be of type string. The provided value is of type 'Null'. Please see https://aka.ms/logicexpressions#formatdatetime for usage details.'.
Hi @ADDLarter ,
Please try this
