cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: concationation sharepoint columns & creation date

Hi,

 

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.

 

https://www.alanps1.io/power-platform/flow/flow-stripping-unwanted-characters-or-special-characters-...

 

Regards,

 

Alex

 

-------

 

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.

Highlighted
Helper III
Helper III

Re: concationation sharepoint columns & creation date

@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?

 

Thanks

Highlighted
Helper III
Helper III

Re: concationation sharepoint columns & creation date

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

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,848)