Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Concatenate function not working

(0) ShareShare
ReportReport
Posted on by 6

Trying to create column in a table to have a url to the record. I have done this for several other tables so I can have a quick link to the record when I create a powerbi dashboard. 

 

Today I am no longer able to use the same method.

The message I am getting is

Not supported in formula columns
 
Capture.PNG
 
  • a33ik Profile Picture
    3,304 Most Valuable Professional on at
    Re: Concatenate function not working

    Hello,

    I did not recommend Flow. I suggested using Workflow. In order to process new records you will have to add "Create" trigger. In order to backfill existing records you will have to choose "on-demand" option as well and run "on-demand" workflow against existing records.

  • Medster Profile Picture
    6 on at
    Re: Concatenate function not working

    How exactly would I create a flow to update the record ? this needs to be done for both new records and run once for all existing records.

  • Medster Profile Picture
    6 on at
    Re: Concatenate function not working

    One of the tables I'm using in dynamics sales for my organization, specifically for client visit reports. I have done the same thing on 3 other tables in my organizations dynamics (both field and sales) with no issues but that was done a few months ago.

  • a33ik Profile Picture
    3,304 Most Valuable Professional on at
    Re: Concatenate function not working

    Hello,

    I understand that this approach might be a little conservative but you can use RealTime workflow to populate the field using Dynamic Record Url. Usecase - https://softchief.com/2023/06/02/use-record-url-in-email-using-workflow-dynamics-365-power-apps/

    The difference that you will have to update the current record.

  • Drew Poggemann Profile Picture
    9,278 Most Valuable Professional on at
    Re: Concatenate function not working

    Hi @Medster ,

    I have tried this as well and unable to accomplish, same error.  I had not tried this before so can't help with if it worked in the past.

  • a33ik Profile Picture
    3,304 Most Valuable Professional on at
    Re: Concatenate function not working

    Hello,

    Which table are you trying to add that field to?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 17

#2
mmbr1606 Profile Picture

mmbr1606 15 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics