News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Formula Column restric...

Customer experience | Sales, Customer Insights,...

Suggested answer

Formula Column restrictions (email format) that Calculated Columns does not have

(0) Share

Report

Report

Posted on by anavrin

40

Hello,

I was trying to create a calculated column and a message appear stating that it is going to be discontinued.

my goal is to set a a contacts information on a work order.

this is so a guest end user on the mobile app, does not need the read access to our contact table.

when attempting to use the formula data type as suggested, I found that email formats are not supported.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns?tabs=type-or-paste#data-types

I am still able to create the calculated field with an email format currently but, how will I be able to do this going forward?

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

Formula Column restrictions (email format) that Calculated Columns does not have

Hi,

You can try using a normal single line text field to receive the value of the email field and then referencing this text field in Formula.
https://www.reddit.com/r/Dynamics365/comments/1bdojg8/columns_of_type_string_with_format_email_are_not/

Best Regards,
Dengliang Li

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2

Martin Dráb 230,188 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans