Jan 12 2023 10:31 AM - edited Jan 12 2023 10:34 AM
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?
Jan 13 2023 05:51 AM
@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)