Hello,
I'm in need of some help, I'd like to create a new column in my dataverse table called "CreatedInfo" which will pull information about the "CreatedBy" user into it. Ideally I'd like to have have the data within the field look like this:
{"fullname":"First Last","internalemailaddress":"my@email.com","systemuserid":"cc123ffd-9b12-ee12-1234-5432123b87dc"}
I know the formula would look something like this, but I'm struggling to find a way to place the user info into it.
"{'fullname':'"&USER_FULLNAME&"','internalemailaddress':'"&USER_EMAIL&"','systemuserid':'"&USER_ID&"'}"
But I'm not sure what to put in place of the values. Ideally I'd like to do this outside of having to edit the app and add additional code. Is this possible?
Thank you 🙂
