Concated formula not displaying date correctly

Copper Contributor

I have the following


=CONCATENA(Title&" "&"Phase"&Phase&" "&Pillar&" "&Score&" "&Date)


This is to create a column with a summary for my power app.


When I try to use the &TEXT(Date,"dd/MM/yyyy") it does not work, I get a syntax error. Any help?

1 Reply

@finlglonger76 you've spelt CONCATENATE incorrectly. A formula like the one below will work: 
=CONCATENATE(Title&" "&"Phase "&Phase&" Score "&Score&" "&TEXT(Date,"dd/MM/yyyy")) 


Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)