Published by
on
Importing previously exported data into Excel from Power Platform would be so easier if you could use a formula to derive another column.
For example, setting a date to the same value as another column using something like:
=A1
But if the cell is going to be re-imported into a particular type such as a date/time, this is going to fail.
So copying/pasting you will have to do using the “Paste Values” function:
[…] set the (currently empty) Skill level column with values from the Skill level (deprecated) field. Remember you cannot use formulae. When setting the field value for the new column, use the values in the existing Option […]
In the beginning there was Jack … and Jack had a groove. And from this groove came the groove of all grooves. And while one day viciously throwing down on his box, Jack boldly declared “Let There Be House” and House music was born.
~ Chuck Roberts
Living and working in the Isle of Man, a lovely island nestled in the Irish Sea between Ireland and the UK.
I principally work in the Microsoft stack, particularly the .NET Framework, having worked in Dynamics 365, Power Platform, SharePoint, WCF, Silverlight, WPF, SQL Server, ASP.NET Web Forms, Web Pages, MVC and Web API. Other than Microsoft, I have worked in MySQL, FastAI and PayPal.
Outside of work, I’m a Scout Leader, geeky-type person with interest in Manx Gaelic, Tolkien, film and trains.
Live to work 
Leave a comment