Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

concationation sharepoint columns & creation date

Dear All,


I am trying to create ref number using a flow. Main idea concationation of columns with ID.


The issue is the creation date. When i run flows: result comes as following.


I would like to reach "MA11200506D52".


How can i do it? If you support me i will be glad.


2020-05-06 23_17_50-Edit your flow _ Power Automate.png2020-05-06 23_18_11-EMEA Central Logistics - TransferOrderNumberApplication - All Items.png




You should just need to write this to a variable first and then write it through a filter to get rid of all the characters that you don't want. It would probably be easiest to just write the created variable and only keep the first 8 characters after removing the "-"'s. I'll post and article below on how to do this.








Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@alrezthanks for the reply.


Seems it is pretty advance detials for me. I checked the link but didn't understand.


Is there an easier way out for the begginners?



Dear All,

Any alternative solution for my request? I am really struggling to find solution.


If you support me i will be glad.


Helpful resources

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (6,836)