
Announcements
Hi,
We have a dataverse table whereby dates are in a text column. I need to create some logic on these, but first I need to 'convert' them to dates. How can I do this via a formula column?
Thanks
K.
I have checked all the available functions for DataVerse formula column but none of them would be able to perform this conversion.
Reference is here: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns#functions
so what you need is a power automate that parses the Text field and convert it to a date value and then you can update the new field of the type datetime from the date value you have converted.