Concated formula not displaying date correctly

New 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")) 

 

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