dataverse | Open source research data repository software | Machine Learning library

I'm working on migration data to Dataverse by ADF and currently destination tables have a bunch of Choices fields, which IDs (values) I need to consider during source dataset generation to map them accordingly in the ADF p ipeline. Is there a possibility to extract Choices field data in readable name/value pairs?

E.g. for MonthOfYear retrieve Invalid Month Of Year 0 January 1 February 2,.. etc

I'm able to query tables via SSMS, but seems Choices are different story how to get them. Please advice.

When I try and "Upgrade" a "DataVerse for Teams" environment to a regular environment it errors out.

It produces the following error message.

"Failed to initiate upgrade of environment. Session Id: b15502de-5bad-43fc-a67b-9aca18XXXXXX"

I used the following documentation. (https://docs.microsoft.com/en-us/power-platform/admin/about-teams-environment)

Could this be a permissions issue?

Nick

Is it possible to use the Common Data Service connector from an Azure Logic App running in a commercial Azure Tenant to connect to a GCC (government) Power Platform/Dataverse instance? I've not found any specific documentation saying it's not allowed, but after authenticating with the connector no environments are listed even though I'm a sys admin. Unfortunately, I don't have access to a GCC Azure tenant with rights to try a similar test.

The Office365 authentication type and OrganizationServiceProxy Connection are now deprecated Link, which variant is the best to create a connection between dynamics 365 Online and c#. do you have any examples.

End goal:

• Get the old array (repository_data) and their subarrays.
• In the repository_data array, insert $newData array.
• Merge repository_data arrays with newData array!

I have a document on my MongoDB which I created (maybe it needs fixing?)

When I run a query the result is the following:

Is there a way to enable change tracking for couple of entities programmatically? I could not find any api in Dataverse which can help to do this.

I need to build a PowerApp which presents a daily list of tasks to a user such as number of surveys to complete; within which postcode area etc. They then want to complete a questionnaire; and store submissions in the PowerApps own Dataverse.

My thoughts are;

• Ideally i would want to hook up Microsoft Forms (standard not Pro) so the PowerApp could either link to the form and pre-populate a unique ID or similar? they complete the form; and a Logic App would process into the DataVerse by unique ID. However not sure this is possible?

• Other option is i design the Canvas App to complete the survey (similar to the Employee Engagement survey template) - but likely will have 30/40 questions - this would obviously have a direct link to the Dataverse so no Logic App required

• Other options?

Thanks in advance Rich

I am trying MS Dataverse(CDS) for the first time. Say I have a table called "User" which has a column called "credits" which is a whole number. After every 21 days, I want to increment the value of "credits" record for all the users by 5 i;e increase the value of "credits" column for all users by 5 every 21 days.

Is there a way to automate this ? The table can also have additional columns such as "StartDate", "CreditDate" which can be used for making calculation for 21 days.

I was looking into Rollup and Calculated column types but they don't seem like the right answer since my case has more to do with automating rather than calculation.

Help would be greatly appreciated.

We need to move users from an on-premise Active Directory on Windows Server (not Azure Active Directory) to Azure AD B2C. But, we're having difficulty in trying to figure out how to read the user data from the AD using Azure products.

We're thinking about using one of the following Azure products to read from on-premise AD, but it's surprisingly difficult to find if this is possible or not, much less how to do it:

• Azure Data Factory
• Azure Logic App
• Microsoft Power Platform Dataverse (formerly Common Data Service)
• Power BI Data Flows
• Note: We can't use Azure AD Connect to migrate the users because that tool isn't designed to work with B2C. Reference Microsoft's Azure AD B2C: Frequently asked questions (FAQ).

The Microsoft article Migrate users to Azure AD B2C says that a script needs to be written that uses the Microsoft Graph API to create user accounts in Azure AD B2C. But the article doesn't give advice on how to access the source data, which in our case is AD.