Please i am getting this error in an attempt to format a sql date;
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
Can you provide a screenshot of the output of your compose action? Something about the way the date is formatted as input is wrong.
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:
Then use the correct expression to get the value of the Date column and convert it using the formatDateTime() function.
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.
Hi @eka ,
Maybe you could try to use When an item is created (V2) as the trigger instead of the PowerApps button.
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:
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
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!