Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Concatenate from data within Record

I have some properties within a Record and would like to concatenate them. I would like to create a new column with a string of text (the link to the sharepoint site) followed by ParentUniqueId with StreamHash. What would be the custom column formula be?

 

 

This is what i have so far, any reason why it is giving an issue with the first part?

 

 

 

Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    Maybe you can try this code:

    custom column = 

    Text.Combine(

    Record.ToList(

    Record.SelectFields([Column],{"firstRecord","secondRecord","thirdRecord}))

    ,"/")

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Is there a way to create a new column where each cell is just the text (link to sharepoint site)? I can concatenate the three cells together i guess, but i think the issue is getting text into the cells. Thanks!

      • v-chenwuz-msft's avatar
        v-chenwuz-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Anonymous ,

         

        Maybe you can try this code:

        custom column = 

        Text.Combine(

        Record.ToList(

        Record.SelectFields([Column],{"firstRecord","secondRecord","thirdRecord}))

        ,"/")

         

        Best Regards

        Community Support Team _ chenwu zhu

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.