Forum Discussion

finlglonger76's avatar
finlglonger76
Copper Contributor
Jan 12, 2023

Concated formula not displaying date correctly

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?

Lists

1 Reply

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Jan 13, 2023

    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)

Resources