NimzITLabz

Error :  The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/SST' is required to be of type 'Number/double'. The runtime value '""' to be converted doesn't have the expected format 'Number/double'. When users attempt to upload Excel file data using Power Automate, this issue commonly happens. The reason is that the Excel table contains empty cells. Proper configuration in Power Automate is necessary to avoid this problem. It's a simple fix, and I'll show you how to implement it. Before the fix, it looks like this: items('Apply_to_each')['XXX']) Just need to add a condition as below: if(empty(items('Apply_to_each')['XXX']),null,items('Apply_to_each')['XXX']) This formula describes the following: If the value of the 'XXX' field for the current item is empty, it will retu...

Hello everyone, in this article, we are going to discuss how to connect your Dataverse tables to Azure Synapse workspace. First, we are going to look at what is the Dataverse and What is the Azure Synapse link for Dataverse. What is Dataverse Dataverse is a cloud-based storage space formerly known as the Common Data Service (CDS). It allows users to securely store data within sets of tables. We can use Dataverse as a data source for business applications such as the Power Platform and Dynamics 365. What is Azure Synapse Link for Dataverse? Azure Synapse Link for Dataverse allows you to easily analyze your Dataverse data using Azure Synapse Analytics without needing to move the data around or use complex processes. It makes data analysis simpler and faster.  Once the link is established, Azure Synapse Link for Dataverse will export all the initial data and continuously sync any new changes. This allows customers to gain near real-time insights from their data stored in Microsoft Dat...