Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Calculated Field in Entity - Split

I need to split a value in a calculated field; but i don't see a Split function; seems like the calculated functions are for dates and numbers.

Is there a way to split?

Community Support Team
Community Support Team

Re: Calculated Field in Entity - Split

Hi @MsMicrosoft ,

Could you please share a bit more about your scenario?

Do you want to split a calculated field value from your CDS Entity within your canvas app?

Further, could you please share a bit more about the calculated field that you mentioned?


The Split() function is supported within PowerApps currently. Please check the following article:

Split function


But the Split function is used to split a text string into a table of substrings. It could not be used to split a number value or Date value.

If you want to split a Date value, you could consider convert the Date value into a Date string value (using Text() function), then you could use the Split() function split this value. Please take a try with the following formula:


On your side, you should type:



Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Calculated Field in Entity - Split

hi _ Kris Dai,


your solution works for canvas apps because i can use the Split function there but i don't know what to do for model driven apps.

I have an entity with a field of type User, and i need to split the user email to get the company domain; for example i want to split the email to get the string "microsoft".



Re: Calculated Field in Entity - Split

You're right that unfortunately the CDS calculated fields have hardly any useful string functions. An alternate option would be to use a workflow and a custom workflow activity to do the string manipulation - see

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,147)