Forum Discussion

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/...

Lists

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)