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

3 REPLIES 3
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:

Split(
Text(DatePicker1.SelectedDate,"[$-en-US]mm/dd/yyyy"),
"/"
)

On your side, you should type:

Split(
      Text(YourDateValue,"[$-en-US]mm/dd/yyyy"), 
      "/"
)

 

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.
MsMicrosoft
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 user@microsoft.com i want to split the email to get the string "microsoft".

 

thanks

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   https://github.com/jlattimer/CRM-String-Workflow-Utilities

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,694)