Stack Overflow
Stack Overflow

Questions tagged [dataverse]

Microsoft Dataverse is a Microsoft-created cloud-based storage space that businesses can use to store data securely. Dataverse allows you to store and manage data securely while maintaining ease of use and accessibility. Data is stored in a set of tables. Each of these tables consists of a set of rows (also known as records) and columns (also known as fields/attributes). Each column in a table can store a certain data type (i.e., text, number, etc.,)

285 questions
4
votes
1 answer

Accessing DataVerse data and running SQL statements against it from C# code on .NET 6 (Azure Function)

I'm working with Dynamics365 CE in the cloud. I'm trying to run some rather involved queries that I've built up as SQL scripts (using the wonderful "SQL-4-CDS" plugin for the XrmToolBox). Now I know I can connect to the Dataverse data store through…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
3
votes
0 answers

How to connect to dataverse rest api from sharepoint online webpart

It seems to be hard finding a good sample or article on this and i was hoping to get some links to samples or articles with regards to configuring this. Or if someone has some experience connecting to dataverse from spfx webparts? caveats and…
Ole Bergtun
  • 113
  • 6
3
votes
2 answers

How to get record before and after in forall loop powerapps

I am trying to run a function that returns a table with a corresponding date index and date text. This is so that I can display the information in a tutorial screen. However, I am confused on how to access to the previous record. Here is my…
Jonathan
  • 441
  • 1
  • 9
  • 28
3
votes
3 answers

Dataverse (common data service) - create tables with a script?

Is it possible to create some kind of script (SQL, PowerQuery or whatever) to create tables (and other DB Stuff) in Dataverse? Everywhere I look they only describe how to click click click, I'd like to have a workflow of creating stuff on my own…
Rudonja
  • 47
  • 8
3
votes
0 answers

SQL Server linked server to a Microsoft Dataverse environment

I would like to connect from an on premise Microsoft SQL Server environment to a Dataverse environment in Azure. I want to be able to download data from Dataverse to SQL Server. I would like to know if i can use linked servers to do this and what…
Nige
  • 31
  • 1
2
votes
1 answer

Dataverse Table creating multiple columns

Is there a faster way to create dataverse table columns instead of one by one? I have a list of columns that I want to add and know what types I would like to assign to them. Can I bulk update this easier or do I have to manually create each new…
dml5055
  • 23
  • 2
2
votes
1 answer

Is there a way to capture what have been changed inside Dataverse tables and update sharepoint lists accordingly using Power Automate flow

We have 2 data-verse tables named:- Invoices Accounts Also we have 2 SharePoint lists named:- Invoices_Logs Accounts_logs The dataverse tables will contain the actual values and the SharePoint lists will act as the logs for the updates. now we…
John John
  • 1
  • 72
  • 238
  • 501
2
votes
2 answers

How to get "PluginProfiler.Solution.zip" - Plugin Registration Tool - Profiler

I face problem that drives me nuts, and I cannot find a solution anywhere. Also it seems many people faced this problem, and asked in several "more expert" forums like "community.dynamics.com" (for example here) or on sites of MIcrosoft MVPs like…
BayerischerSchweitzer
  • 51
  • 1
  • 5
2
votes
1 answer

Power Automate Flow Dataverse Connector Delete trigger - customize Body fields

I am using the Dataverse connector for Microsoft Flow. I am using the Delete trigger to run my flow whe a row is deleted. I then would like to call an 3rd party API, but I need other fields from the row being deleted than is provided in the body of…
user210757
  • 6,996
  • 17
  • 66
  • 115
2
votes
1 answer

Cannot use CTE in SQL query connected to an Dataverse table (in SSMS)

I've connected to our Dataverse environment in SSMS. I can run this simple query: SELECT cr6e4_customeruseradfunction, cr6e4_customeruser, count(cr6e4_assettag) as AssetCount FROM [dbo].[cr6e4_itassets] WHERE…
MrSiezen
  • 83
  • 7
2
votes
1 answer

Is there an IN operator for Power Automate Odata List Rows - Filter Rows expression

What is the syntax of a Filter Expression for the DataVerse List Rows component, using a comparison similar to the SQL IN Statement. I have tried things such as name in ('name1','name2') with no luck.
Tim T
  • 140
  • 2
  • 11
2
votes
1 answer

Generating C# classes from dataverse

Is there a way to generate C# classes from a dataverse endpoint? Alternatively, is there a way to generate dataverse custom tables according to c# classes? I'm searching for a "db(dataverse)-first" or, alternatively, a "code-first" solution to…
Luis Gouveia
  • 8,334
  • 9
  • 46
  • 68
2
votes
1 answer

Get current "Power Apps per App Plan" - License Usage

i can assign 'power apps per app plan'-licenses to a specific app. I can see how many licenses i have assigned. But i am unable to find an overview of the current usage of the license. I want to see the users who are using an license right now and…
bob
  • 595
  • 2
  • 18
2
votes
2 answers

crm cascade delete does not fire plugin

In crm i have solution with several entities. There are three that are causing a problem. Lets call them A, B and C. A and B have a one to many relation with a cascading effect on deletion B and C have a one to many relation without a cascading…
martijn
  • 1,417
  • 1
  • 16
  • 26
1
vote
1 answer

Return all rows from JSON Query

I am currently using the below API call to a Dataverse table. Unfortunately, this results in only the first 500 rows being returned. let Source = Web.Contents(https://xxx-prod-xxx.api.crm11.dynamics.com/api/data/v9.2/audits) in Source I…
Ami Khan
  • 21
  • 1
  • 5
1
2 3
…
18 19