Crm Newshubb
Advertisement
  • Home
  • News
  • CRM Software & Tools
  • Contact us
No Result
View All Result
  • Home
  • News
  • CRM Software & Tools
  • Contact us
No Result
View All Result
Crm Newshubb
No Result
View All Result
Home CRM Software & Tools

Consume Excel Files with Cloud Flows – CRM Software Blog

admin by admin
January 26, 2023
in CRM Software & Tools


Do you leverage data from multiple applications or services? If you haven’t already found a way to integrate the data between them, you should check out Microsoft Cloud Flows, which are part of Power Automate and part of the overall Power Platform.

Cloud Flows allow power users to build workflows that integrate a diverse set of apps and services, including Dynamics 365, SharePoint, SQL Server, Act!, Twitter and many more! Each workflow can have one trigger, such as a timer or an incoming email or tweet, and one or many actions, such as creating a Lead in your application of choice and sending a text message to a user. Most of it requires little to no code, but a Developer can help extend the functionality.

Within the Power Platform, there are many pre-built tools that you can leverage to consume Excel files. One method is to utilize the pre-built Excel connector which can parse an Excel file uploaded to SharePoint or One Drive.

Since there is a pre-built Excel connector, parsing Excel data and transforming it for the Dataverse may seem straightforward to do (and it is for the most part!), but here are a few tips to make the transformation smoother:

Retrieving the ‘table’ within the excel document

  • One action within the Excel connector is to retrieve the table within the excel document. Part of the challenge with this is that it wants you to specify the table name, which could be different for each excel file, especially if they were generated differently. One workaround for this is to retrieve all tables in the excel file and add an “apply to each” condition. This way avoids having to hard code a table name within the action. Validation of the columns can be performed later on after parsing the data.

Continue reading on www.beringer.net

 



Source link

Previous Post

Stay on Track with CRM on Mobile

Next Post

Training Dynamics 365 Users is a Waste of Time – CRM Software Blog

Next Post

Training Dynamics 365 Users is a Waste of Time - CRM Software Blog

Recommended

Microsoft Dynamics 365 Marketing: Using Pre-defined Tokens

July 28, 2022

Get CRM Right, by Getting Expectations Right – CRM Software Blog

December 15, 2022

Vtiger CRM Blog » Lead Management with AI

January 24, 2023

Mixed Reality is Transforming how businesses remotely collaborate

August 1, 2022

Don't miss it

News

Quality audit and its benefits to your business

March 29, 2023
CRM Software & Tools

Using External Storage for Your Dynamics 365 Attachments

March 28, 2023
News

Security & Scalability: Foundational IT Needs

March 28, 2023
News

Boost your Customer Base with Vtiger Lead Generation Tools

March 28, 2023
CRM Software & Tools

RevOps Strategic Approach to Align Sales, Marketing and Customer Success – CRM Software Blog

March 27, 2023
CRM Software & Tools

How to Hire Microsoft Dynamics 365 Developer

March 26, 2023
crm-white

© CRM News Hubb All rights reserved.

Use of these names, logos, and brands does not imply endorsement unless specified. By using this site, you agree to the Privacy Policy and Terms & Conditions.

Navigate Site

  • Home
  • News
  • CRM Software & Tools
  • Contact us

Newsletter Sign Up

No Result
View All Result
  • Home
  • News
  • CRM Software & Tools
  • Contact us

© 2022 CRM News Hubb All rights reserved.