FORMAT DATE USING COMPOSE

[eka]

Please i am getting this error in an attempt to format a sql date; 

formatDateTime(triggerBody()?['Date'],'dd-mmm-yyyy')

this is the error;

InvalidTemplate. Unable to process template language expressions in action 'Compose_2' inputs at line '1' and column '2192': '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.'.

attached is my flow

[Gristy]

inspect your trigger, is date null it sounds like it is?

is this a document with metadata? add a delay of 1 minute and then do a get file properties using the id from the trigger.

[eka]

The date column is not null.

[Pstork1]

Can you provide a screenshot of the output of your compose action?  Something about the way the date is formatted as input is wrong.

[eka]

[AKRogers]

Looks like there are 3 m’s there in your expression; I think you’re looking for ‘dd-MM-yyyy’ instead.

[v-bacao-msft]

Hi @eka ,

What is the data source for PowerApps connections?

As far as I know, if you use the PowerApps button as a trigger, the Dynamic content output by the trigger is automatically generated based on the corresponding action.

So expressions such as triggerBody()?['Date'] are not able to get the specified field value.

Please refer to this online doc for more details on PowerApps integration with MS Flow:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

Then use the correct expression to get the value of the Date column and convert it using the formatDateTime() function.

Best Regards,

[eka]

I am using Azure Sql as data source as shown in the picture i posted

[v-bacao-msft]

Hi @eka ,

If PowerApps does the job of adding a new line, then I recommend that you use When an item is created (V2) as the trigger instead of the PowerApps button.

Best Regards,

[eka]

I tried formatDateTime(triggerBody()?['Date'],'dd-MM-yyyy') but still get the error attached;

[v-bacao-msft]

Hi @eka ,

Maybe you could try to use When an item is created (V2) as the trigger instead of the PowerApps button.

Best Regards,

[Pstork1]

I think your problem is that you are accessing the wrong date field.  triggerBody()?['Date'] would be a parameter coming in from Power Apps  I think what you want is the following:

formatDateTime(body('Get_row_(V2)')?['Date']),'dd-mmm-yyyy')

You are trying to format a parameter coming in from the trigger, not a date field in the SQL row.  I suspect that is why its telling you its null