Title combine fields with split in SP lists columns

Question

Hi,

I have a title column I would like to be a calculated column & combine multiple fields in my sp list.

the final result should be like this

1st letter of [Col1]_1st&2nd letter from the last [Col2] _TEXT[Created], "d-mmm-yyyy")

Can you please help!

Answer 1

Hi @Oraib Alhemmyaine ,

Neither the CONCATENATE function nor the CHOOSE function currently supports Date and Time type fields.

What is currently possible is shown in the following figure:

For more information, please refer to:

https://support.microsoft.com/en-us/office/concatenate-function-5b0392b2-94ef-49ea-8532-4fdd3a69d362

https://support.microsoft.com/en-us/office/choose-function-e4b61fbc-40a4-4fe2-8b9c-c5e7a51fdbbe

And you can also use Power Automate to make it. Therefore, we suggest that you can go to the Microsoft Power Automate Community  for help.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.