Power Platform is excited to announce over 60 new connector releases for Ignite 2023, along with more than 50 updates to the existing connectors. These connectors are available in Power Automate, Power Apps, and Azure Logic Apps & cover the breadth & depth of solutions and tools for IT Operations, AI, Business Intelligence, Productivity and much more. Power Platform has an existing fleet of 1000+ connectors in the catalog to help creators and learners of all ages and backgrounds connect with the tools and information they need to build a more intuitive & productive solutions.

We are extremely honored to have a great partnership with all our Partners, and we look forward to partnering with many more Enterprises & community developers for providing wonderful solutions in the future.

New Connectors released by Verified Publishers include:

Interested in submitting your connector? Visit our documentation and our GitHub repository to learn how to get started.

1. 3E Events
2. DocuMotor
3. Dokobit Universal API
4. Microsoft Translator V3
5. The IT Tipster
6. HTML to PDF by Pascalcase
7. Monday
8. Eden AI
9. ServiceDesk Plus Cloud
10. ReversingLabs A1000
11. Azure Text to speech
12. StarRez REST v1
13. iManage Insight Plus
14. Adobe Acrobat Sign Government
15. Peakboard
16. Calendly
17. Adobe Acrobat Sign Sandbox
18. BlueInk
19. D7Messaging
20. Event Tickets
21. Tesseron Asset
22. The Events Calendar
23. Navisphere
24. Microsoft Teams Virtual Events

Below are the major releases for you in Ignite 2023:

1Me Corporate

1Me is your next-gen digital contact card. It provides the easiest & fastest way to share your contact information with anyone worldwide. 1-QR Code or 1-Tap is all what you need to share your contacts information.

1Me Corporate Edition, you will be able to manage your entire company’s contact cards, empowered by many powerful tools, such as digital card branding and administration corporate contracts.

Visit www.1me.live to learn more about 1Me.

Now with Power Automate adapter integration, onboarding your team is now a seamless experience, where you will be able to build automation processes that send onboarding invitations automatically to your team members.

Ramy Mostafa, CEO

Visit the 1Me Corporate connector documentation to learn more.

3E Events

3E is Elite Technology’s market leading law firm management, productivity, and financial solution. With the recent availability of the 3E Events Connector Configuration capability, 3E Cloud customers now have the ability to develop event-based integrations using Microsoft Power Platform. This new integration development option combines 3E APIs and 3E Events Hub, in conjunction with the Power Platform 3E Events connector. This combination enables customers to extend 3E’s capabilities using Microsoft’s low code/no code Power Platform to create more interactive, immersive, responsive integrated solutions.

Visit 3E Events connector documentation to learn more.

DocuMotor

The DocuMotor connector allows you to convert data from any system into professional Word documents, PowerPoint presentations, Excel spreadsheets, or accessible PDFs (PDF/UA). Simplify your document creation process with our intuitive yet flexible document automation platform tailored for businesses and the documents that matter.

With DocuMotor, you can effortlessly generate on-brand and compliant documents, saving valuable time and ensuring consistency across your organization. Experience seamless integration and unleash the full potential of document automation for your business.

Easily insert and preview text, conditional sections, images, charts, and tables all within our browser-based template builder. Once you are satisfied, go live with a single click.

Learn more about our user-friendly platform and its capabilities in our documentation.

Visit the DocuMotor connector documentation to learn more.

Dokobit Universal API

Dokobit Universal API is a versatile tool that enables signing documents internally, within your system, and collecting signatures from 3rd parties, outside your system. Document signing occurs in an accountless Dokobit signing (where invited participants can sign documents without registering on the Dokobit portal) interface with your organisation’s branding. Actions also include access to an eIDAS-certified service for qualified e-signature and e-seal validation.

Visit the Dokobit Universal API documentation to learn more.

Microsoft Translator V3

The Microsoft Translator V3 connector now allows you to translate documents and text. Using this connector, you can create automated workflows to translate single/multiple documents that are stored in SharePoint, OneDrive, local folder, or any other storage location. You can also create automated workflows to translate text from any source such as incoming emails via Outlook provider. This connector leverages Azure AI Translator which supports 125+ languages. For more details, check out the following resources:

• Documentation on connector actions.
• Tutorial on how to use the connector to translate documents.
• Video walkthrough on how to create an automated flow to translate a document in SharePoint.
• Tutorial on how to use the connector to translate text.
• Video walkthrough on how to create an automated flow to translate text.

Visit the Microsoft Translator V3 connector documentation to learn more.

The IT Tipster

IT Tipster connector allows the end user to generate code128 barcodes and QR codes by passing in a simple text string to the connector. The barcode and QR code are returned to the user in base64 format.

For more information head over to https://www.theittipster.com and here.

For the person to attribute the connector please use Shane Cosgrove, Solution Architect

Visit the The IT Tipster connector documentation to learn more.

HTML to PDF by Pascalcase

The “HTML to PDF by Pascalcase” connector allows transformation of HTML files into high-quality PDF documents. It allows conversion of web pages, reports, or other HTML content to PDF documents. The connector has the ability to handle heavy-duty PDF generation without any size limitations making it perfect for both small-scale and large-scale projects.

Visit HTML To PDF Converter Help Document for more details.

Visit the HTML to PDF by Pascalcase connector documentation to learn more. 
monday

The monday connector seamlessly integrates Power Automate with monday.com. Create monday items, notifications, subitems, boards, groups, updates and more. Trigger Power Automate flows based on a variety of monday events, such as when an item is created or updated.

Get started by installing the Microsoft Power Automate app in the monday.com marketplace.

Visit monday connector documentation to learn more.

Eden AI

Eden AI makes AI accessible to everyone by providing a unique API connected to the best engines for more than 50 AI technologies.

With the Eden AI connector for Power Automate, you can integrate advanced AI features such as natural language processing, image recognition, document parsing, audio processing, generative AI, and more. Eden AI allows you to enhance your apps and workflows with all the best AI engines (more than 30 different AI providers).

Visit the Eden AI connector documentation to learn more. 
ServiceDesk Plus Cloud (powerautomate.com)

ServiceDesk Plus is the unified service management platform from ManageEngine (a division of Zoho Corporation). ServiceDesk Plus offers a short runway to value with its out-of-the-box industry best practices and helps tackle complex service scenarios with its no-code visual automation.

Packed with contextual integrations with both IT and business apps, ServiceDesk Plus connector is now available in the Power Automate platform. IT admins can now include ServiceDesk Plus in their Power Automate workflows, to more efficiently manage their requests, and changes.

Visit ServiceDesk Help Document to learn more.

Visit the ServiceDesk Plus Cloud documentation to learn more.

ReversingLabs A1000

The ReversingLabs A1000 connector enables Microsoft Azure users to add advanced threat hunting and malware analysis capabilities to their toolbox. Based on the TitaniumCore static analysis engine, security teams using the A1000 can gain rich context and threat classifications across thousands of file types based on a comprehensive history of goodware and malware. Additionally, security teams can also utilize YARA rule matching for further file-based threat detection.

For more information on the ReversingLabs A1000 platform, see the following: ReversingLabs

Visit the ReversingLabs A1000 connector documentation to learn more.

Azure Text to speech

Azure AI Text-to-Speech allows you to build apps and services that speak naturally with more than 400 voices across 140 languages and dialects.

Visit the Azure Text to speech connector documentation to learn more.

StarRez REST v1

The StarRez resident and property management platform is the perfect tool to help your community thrive. With the StarRez REST API, you can automate regular tasks, import and export data and streamline your business processes.

Visit the StarRez REST v1 connector documentation to learn more.

BlueInk

The Blueink connector allows you to incorporate Blueink’s eSignature platform into your automated workflows. The connector allows you to send documents for eSignature, store signed documents, and check the status of your signature requests. Streamline your document management processes by adding Blueink to your existing workflows.

Learn more about Blueink at www.blueink.com.

Visit the BlueInk connector documentation to learn more.

D7Messaging

Direct7 Networks offers a messaging API platform that enables you to establish global connections with your customers. Now, streamlining your Microsoft workflows is more convenient with the D7 messaging connector. Easily dispatch verification messages using the D7 Verifier and gain insights into phone numbers through the D7 Number Look-Up.

Additionally, this connector is highly efficient for sending SMS, OTP SMS, and Viber messages to your customer base. The integration process is straightforward, making it easier to engage with your customers for messaging and verification needs.

For further information, please visit D7Messaging

Visit the D7Messaging connector documentation to learn more.

Updates released for Connectors by Verified Publishers include:

1. AADInvitationManager
2. Adobe Acrobat Sign
3. Centrical
4. Encodian
5. Microsoft Bookings
6. Snowflake
7. Talkdesk
8. The Bot Platform
9. Zoho Sign Team Forms
10. Yeeflow
11. ReversingLabs TitaniumCloud
12. RegexFlow ExecutePython
13. ArcGIS
14. Encodian
15. Survey123
16. LCP – iCordis
17. SmartCOMM DocGen
18. Bitskout
19. ModuleQ
20. Seismic Library
21. AvePoint Cloud Governance
22. Apptigent PowerTools PRO
23. allGeo
24. Adobe PDF Services
25. CobbleStone – Contract Insight
26. Vocean
27. Jupyrest
28. Blackbaud SKY Add-ins
29. Advanced Data Operations
30. FactSet
31. U.S. Bank Treasury Management
32. Maximizer
33. DocuSign Demo
34. Dokobit Portal
35. Meisterplan
36. Power Textor
37. Converter by Power2Apps
38. SMSAPI
39. CivicPlus Transform
40. OneBlink
41. iManage Work for Admins
42. DocuSign
43. Data Activator Early Access
44. InEight
45. Tesseron Invoice
46. Plumsail HelpDesk
47. ArcGIS
48. ArcGIS Enterprise
49. GMO Sign
50. OpenText Extended ECM
51. OpenText eDOCS
52. OpenText Core Share
53. Plumsail HelpDesk
54. ArcGIS
55. ArcGIS Enterprise
56. GMO Sign
57. OpenText Extended ECM
58. OpenText eDOCS
59. OpenText Core Share

Below are few of the most significant updates.

Microsoft Bookings

With this change, customers can select a booking page from the drop-down menu instead of entering the SMTP address for creating a Bookings trigger. We have also powered the connector with newer APIs for the experience to be better. If you run into any connection related issues, please delete and recreate Bookings connection from Data->Connections tab as we have updated our APIs as well for this new change.

Visit the Microsoft Bookings connector documentation to learn more.

Snowflake

Build low-code data applications in just a few clicks with Microsoft Power Platform and Snowflake. The Snowflake Connector for Microsoft Power Platform provides instant access to up-to-date data within your Snowflake environment without manually integrating against API endpoints. Now anyone can easily build low-code applications or workflows on Power Platform that leverage Snowflake data without any previous technical or app development experience.

The Snowflake Connector for Power Platform provides a wide range of benefits:

• Seamless data connectivity: You can easily connect to your Snowflake account from within the Power Apps environment.
• Advanced analytics:  Snowflake’s advanced analytics capabilities allow you to extract deeper insights from your data, including predictive analytics, machine learning, and data science workflows.
• Automation capabilities: Automate processes, trigger workflows, stay informed about data updates, and execute actions based on events in Snowflake.
• Secure data access: The Snowflake Connector for Power Platform provides secure data access, helping to protect from unauthorized access.

Get the Snowflake Connector for Microsoft Power Platform by installing it from the Power Platform Connectors listing. Explore our detailed Snowflake Quickstart guide or read the documentation and start building your data applications today.

Zoho Sign

The Zoho Sign platform enables organizations to digitally sign, send, and manage business paperwork from anywhere. This connector allows you to set up automated workflows to collect signatures on documents from your everyday apps and business tools such as CRM, HRMS, cloud storage, and other communication and collaboration platforms.  With this update, you’ll be able to connect your apps to the Zoho Sign service across all of our regional datacenters to initiate workflows for signing and processing document data within geographical boundaries that are best suited to your business operations.

Visit the Zoho Sign connector documentation to learn more.

Team Forms (powerautomate.com)

Teams Forms brings digital forms into Microsoft Teams and empowers your teams to build and deliver forms from within the productivity tools they already know and trust. Unlike many other forms solutions on the market, Team Forms works offline and communicates directly with your Teams SharePoint, ensuring that data captured by forms remains under your control and never leaves your trusted Microsoft 365 environment.

You can use the Team Forms connector to trigger automated workflows, access response fields, attachments, and generated PDFs.

Visit the Team Forms connector documentation to learn more.

Yeeflow

The Yeeflow connector bridges the gap between Yeeflow and Microsoft Power Automate, offering users an intuitive way to trigger workflows when data is added or updated in Yeeflow Data Lists. By eliminating the need for manual interventions, businesses can now automate their operations and ensure smooth data flow across platforms.

With the Yeeflow connector, Microsoft 365 users can seamlessly integrate Yeeflow with Microsoft Products and Third-party systems without writing a single line of code. This powerful integration empowers organizations to streamline their business processes and enhance collaboration effortlessly.

Highlights of the Yeeflow Connector:

• Effortless Integration: Microsoft 365 users can integrate Yeeflow with their existing Microsoft Products and Third-party systems seamlessly, simplifying the management of business processes.
• Code-Free Automation: With the Yeeflow connector, you don’t need to write any code. The user-friendly interface allows you to set up and customize workflows quickly, saving valuable time and resources.
• Streamlined Collaboration: Collaborate effortlessly between Yeeflow and Microsoft Power Automate users, enhancing cross-platform communication and optimizing productivity.

Visit the Yeeflow connector documentation to learn more.

RegexFlow ExecutePython

RegexFlow’s ExecutePython service allows users to execute Python scripts remotely.  All standard Python libraries are supported along with  openpyxl and pillow.  Additional libraries can be added by request.  The ExecutePython connector for Power Automate allows users to easily extend their Flows’ functionality with the flexibility of the Python programming language.

Visit the RegexFlow ExecutePython connector to learn more.

ArcGIS Survey123

ArcGIS Survey123 is a powerful solution for creating smart forms and surveys that accelerate data collection on web and mobile devices. Benefit from dynamic form builders that make designing simple to complex, engaging forms enriched with location data easy. Visualize and analyze survey results with a geographic lens to better understand where and why things occur. Share data to other critical business apps and services staff uses daily with the Survey123 Power Platform Connector. Provide instant access to real-time information to better support decision-making and improve business processes.

Visit the Survey123 connector documentation to learn more.

Vocean

Vocean, where co-creation meets next-level innovation, offers a powerful platform for open innovation and idea generation. Vocean enables effortless collaboration and use of the collective intelligence to drive innovation and achieve your organization’s full potential, further increased by the seamless Teams integration. With Vocean Copilot, our advanced AI-powered assistant, ideas can be refined, hidden patterns uncovered, and valuable suggestions for improvements revealed – leading to groundbreaking solutions. The Vocean connector for Power Automate empowers seamless connectivity between the Vocean platform and other apps, further enhancing the innovation process.

Visit the Vocean connector documentation to learn more.

Meisterplan

Meisterplan is a portfolio-level resource management tool that helps portfolio and resource managers manage people across teams and initiatives whether your work is traditional, agile or hybrid.

With the update to the Microsoft Power Automate Connector for Meisterplan, you can now read and update data of Financial Actuals. Additionally, we have added actions to read Meisterplan user data.

Visit the Meisterplan connector documentation to learn more. 
Power Textor

Power Textor is the ultimate game-changer for businesses looking to elevate their SMS game within Power Automate. The powerful SaaS tool helps businesses integrate SMS functionality to trigger flows relating to sending SMS and MMS to customers and receiving push notifications when a text message is received. This enables businesses engage with their audience through one-to-one conversation, tapping into the heart of their customer base.

Power Textor supports various text messaging options, including on-demand SMS, scheduled SMS, event reminders, and Google Review requests. All of it helps businesses build long-term brand loyalty with their customers.

Power Textor connector is currently available in the USA, Sweden, UK, and Canada and can be integrated with Power Automate, Logic Apps, and Power Apps to automate messaging.

Visit the Power Textor connector documentation to learn more.

Converter by Power2Apps

The Converter by Power2Apps allows you to easily convert common data formats to others (JSON to CSV, CSV to XLSX, File to PDF and many more). The focus here is on user-friendliness, in which the data structure is automatically detected.

In addition to better integration with Power Apps, many new actions have been added. These new actions cover 4 topics:

• Image conversions (Format conversions, Rotation, Compress).
• QR and barcodes (Create/read)
• PDF editing ((Un)-Protect, Merge, get Metadata)
• Add content to DOCX (Images, Text and Tables)

Visit the Converter by Power2Apps connector to learn more.

SMSAPI

SMSAPI is a global professional SMS provider and a part of the mobile industry-leading LINK Mobility Group. We excel at providing easy and powerful SMS gateway, API, ready-to-use integrations, and Microsoft Power-Up has become one of them. This connector enables adding SMS as a channel to your Microsoft workflows. It automates sending messages like SMS reminders, marketing, notifications, and one-time passwords.

To use the official SMSAPI Connector, register first at www.smsapi.com. Create a free test account, and we will add extra points to kickstart your journey with SMS communications.

Visit the SMSAPI connector documentation to learn more.

Data Activator Early Access

Data Activator is a no-code experience in Microsoft Fabric for automatically taking actions when patterns or conditions are detected in changing data. It monitors data in Power BI reports and EventStreams items, for when the data hits certain thresholds or matches other patterns. It then automatically takes appropriate action such as alerting users.

Using the Data Activator Power Automate connector, you can generate actions in external systems when your Data Activator triggers activate. This can be useful for sending notifications, creating action items in ticketing systems, or calling line-of-business apps from within Data Activator.

Click here to learn more about Data Activator.

(** Please note that Data Activator is currently in private preview, so you will need to be signed up for the private preview in order to use the Data Activator Power Automate connector.)

Visit the Data Activator Early Access connector documentation to learn more.

InEight

“Allowing for the seamless exchange of data between your existing back-office applications and InEight’s integrated project controls platform, InEight Connector brings proven project certainty to your business without all the hassle. Eliminating manual data entry and providing robust real-time analytics across your applications, the connector gets you one step closer to realizing complete project visibility and confidence. With over $1 trillion worth of construction projects around the world relying on InEight’s integrated project controls, you have full confidence in InEight on your projects. “

Author: Catie Williams, Vice President Product

Visit the InEight connector documentation to learn more.

Plumsail HelpDesk

Plumsail HelpDesk helps you to turn your SharePoint site into an efficient and user-friendly HelpDesk. In this update, we have added a new region. Now you can select a region while installing HelpDesk. It allows you to achieve better compliance with regional and industrial regulations.

Visit Plumsail HelpDesk to learn more.

ArcGIS

ArcGIS connects your automated workflows to resources from your ArcGIS organization. Access geoenrichment, geocoding, and routing services to add demographics and location information to your data. You can also use the ArcGIS connector to create feature layers and fetch data from existing feature layers in your ArcGIS organization. The ArcGIS connector works seamlessly with all the connectors in the Power Automate library. Further, it enables you to create automated flows leveraging triggers and webhooks based on record or attachment changes in your feature layer. The ArcGIS connector helps you easily maintain records and attachments through CRUD-based actions (insert, update, delete) in near real-time allowing you to fetch changes when you need them most.

Visit ArcGIS to learn more.

ArcGIS Enterprise

ArcGIS Enterprise connects your automated workflows to resources from your ArcGIS organization. Access geoenrichment, geocoding, and routing services to add demographics and location information to your data. You can also use the ArcGIS Enterprise connector to create feature layers and fetch data from existing feature layers in your ArcGIS organization. The ArcGIS Enterprise connector works seamlessly with all the connectors in the Power Automate library. Further, it enables you to create automated flows leveraging triggers and webhooks based on record or attachment changes in your feature layer (currently in Preview). The ArcGIS Enterprise connector helps you easily maintain records and attachments through CRUD-based actions (insert, update, delete) in near real-time allowing you to fetch changes when you need them most.

Visit ArcGIS Enterprise to learn more.

New Connectors released by Independent Publishers include:

Interested in submitting an Independent Publisher connector? Visit our documentation and our GitHub repository to learn how to get started.
Calendarific by Andras Fordos

Calendarific is a developer-friendly, worldwide service giving you access to public, local & bank holidays and observances; and spanning over 230 countries, 3,300+ states and 100+ languages.

View this connector in GitHub.
Leap-Ai by Chandra Sekhar

LeapAi image recognition service.

View this connector in GitHub.
MessageBird SMS  by Troy Taylor

Messagebird’s SMS service allows you to send and receive SMS messages to and from any country in the world.

View this connector in GitHub.
Microsoft Partner Center by Oleksii Skirko, Innoware Ukraine LLC

This connector allows you to connect to MPC API and collect some information including customer details, orders and subscriptions.

View this connector in GitHub.
Monster API  by Troy Taylor

With Monster API, you can effortlessly access powerful generative AI models such as Stable Diffusion for text to image and image to image.

View this connector in GitHub.
ScreenshotOne by Troy Taylor

ScreenshotOne is a scalable and straightforward screenshot service to cover all your needs by making screenshots. It converts any given URL or HTML to PNG, PDF, etc.

View this connector in GitHub.
SolarEdge by Richard Wierenga

The SolarEdge connector gives you the opportunity to display system data in other applications.

View this connector in GitHub.
Threads by Troy Taylor

Threads is a Slack replacement designed for makers. Threads provide a simple, focused canvas for sharing your work and getting rich feedback in return.

View this connector in GitHub.
io by Troy Taylor

Improve operational efficiency with the world’s leading enterprise-grade weather service. Use our hyper-accurate weather data for endless use cases across all industries.

View this connector in GitHub.
dev  by Troy Taylor

Create a short, temporary, self-destructing link to a website or message.

View this connector in GitHub.
WhatIsMyBrowser by Troy Taylor

The WhatIsMyBrowser.com service provides an easy way for your website or system to get detailed information about the technology that your visitors are using to browse your website. There are lots of uses for it, but some of the most popular ones include using this information to personalize the content and advertising on your site for each visitor, help identify “strange” or risky activity on your site, and to gather general demographic information about the visitors to your site.

View this connector in GitHub.
io by Troys Taylor

APlace is a service that allows you to simply integrate powerful geolocation tools into your application, including address autocomplete and reverse geocoding.

View this connector in GitHub
ApyHub by Troys Taylor

ApyHub is the a service utility belt that helps developers save time and boost efficiency. Included are actions for archiving and unarchive files.

View this connector in GitHub.
Daffy by Troys Taylor

Daffy is a not-for-profit community of members who have the commitment to put money aside for those less fortunate than themselves. Find organizations and causes you care about and recommend donations to over 1.5 million charities in the US.

View this connector in GitHub.
Dandelion by Troys Taylor

Dandelion is semantic text analytics as a service. They provide actions for entity extraction, sentiment analysis, keyword extraction, semantic similarity, and Wikisearch results.

View this connector in GitHub.
Fun Translations by Troy Taylor

Have some fun with our language translations.

View this connector in GitHub.
Hashtag API by Troy Taylor

The Hashtag Generator service allows you to generate relevant hashtags for your content based on a given keyword or image.

View this connector in GitHub.
Pixela by Troy Taylor

Pixela is the pixelation service. With this service, you can get a GitHub-like graph that expresses the degree of your various activities on a basis with a vivid gradation.

View this connector in GitHub.
Supportivekoala by Troy Taylor

Supportivekoala allows you to autogenerate images using templates.

View this connector in GitHub.
BKK Futar by Andras Fordos

Get and search planned and real-time information from the BKK FUTAR system – public transportation of Budapest – regarding journeys, vehicles, stops and many more!

View this connector in GitHub.
IP2LOCATION  by Andras Fordos

IP2Location returns geolocation information like country, region, city, latitude & longitude, ZIP code, time zone, ASN, ISP and so on for an IP.

View this connector in GitHub.
IP2WHOIS by Andras Fordos

Obtain domain information and WHOIS record by using a domain name, such as creation date, updated date, expiration date, etc.

View this connector in GitHub.
Sunrise-Sunset by Andras Fordos

Sunrise-Sunset provides sunset and sunrise times for a given latitude and longitude, including twilight informations. Attribution required.

View this connector in GitHub.
Updown by Andras Fordos

Updown is an online service that checks your website’s status by periodically sending an HTTP request to the URL of your choice. It then notifies you by email, sms or even a webhook, when your website is not responding correctly.

View this connector in GitHub.
Wayback Machine by Andras Fordos

The Wayback Machine is a digital archive of the World Wide Web and it allows the user to go \”back in time\” and see how websites looked in the past.

View this connector in GitHub.
Airlabs by Andras Fordos

Airlabs collects extensive real-time aviation and flight data from thousands of sources to cleanse, aggregate and organize it into comprehensive collections.

View this connector in GitHub.
Anthropic by Troy Taylor

Claude is a large language model (LLM) built by Anthropic. It’s trained to be a helpful assistant in a conversational tone.

View this connector in GitHub.
Mailinator by Troy Taylor

The Mailinator service provides programmatic access to the Mailinator system. This includes fetching and injecting messages into the Mailinator system and creating routing rules for specific message domains within the system.

View this connector in GitHub.
Mime Automation by Andreas Cieslik

Mime Automation provides a way to extract data from a TNEF (winmail.dat) encoded file

View this connector in GitHub.
Reflect by Troy Taylor

Reflect is a beautiful note-taking tool designed to help you think. Mirror the way your mind works by associating notes through backlinks. Reflect builds you a second brain that you can reference anytime.

View this connector in GitHub.
Kroki by Troy Taylor

Kroki provides a service to create diagrams from textual descriptions.

View this connector in GitHub.
Abbreviations by Troy Taylor

The Abbreviations service from STANDS4 enables you to get classified acronyms and abbreviations content for a given term.

View this connector in GitHub.
ai by Troy Taylor

Meet your brainstorming buddy, blank page remover, research assistant, and expert copywriter: Chat by Copy.ai. Use our generative AI platform to work faster, smarter, and anything but harder.

View this connector in GitHub.
Diffchecker by Andras Fordos

Diffchecker will compare your inputs to find the difference between two text files, images, PDFs and many other.

View this connector in GitHub.
Feathery by Troy Taylor

Feathery is transforming the way user interfaces for collecting information are built. We help users build customizable and developer-friendly forms.

View this connector in GitHub.
Hash Generator by Troy Taylor

This hash generator allows you to generate hashes from your input string. You can choose between SHA1, SHA256, SHA512 and MD5.

View this connector in GitHub.
Letterdrop by Troy Taylor

Letterdrop is the only SEO tool that optimizes for people-first content. Beyond SEO, it’s actually a complete content marketing suite designed to help you go from idea to publish as quickly as possible while following best practices. This includes project management, social distribution, and repurposing content.

View this connector in GitHub.
LoginLlama by Troy Taylor

LoginLlama adds an extra layer of customer security without the extra work. LoginLlama uses a number of ranking factors to decide if a login is deemed suspicious. We determine a score for each login based on how ‘suspicious’ it is. We then use Bollinger Bands to determine if the login is suspicious or not.

View this connector in GitHub.
NameAPI by Andras Fordos

NameAPI is a web API to handle people’s names in your software.

View this connector in GitHub.
Pinecone by Troy Taylor

Pinecone makes it easy to provide long-term memory for high-performance AI applications. Pinecone is a managed, cloud-native vector database with no infrastructure hassles. Pinecone serves fresh, filtered query results with low latency at the scale of billions of vectors.

View this connector in GitHub.
PixelMe by Troy Taylor

PixelMe links allow you to track customers across platforms and increase the likelihood of turning clicks into conversions. Deep links direct users straight to a particular website or app page, eliminating the need for them to navigate or re-enter billing details. PixelMe\u2019s deep links open directly in the Amazon app, allowing you to drive customers directly to the Amazon app for better UX, enhanced retention, and higher likelihood of conversion.

View this connector in GitHub.
TLDR by Troy Taylor

TLDR helps you summarize any piece of text into concise, easy to digest content so you can free yourself from information overload. Summarize any URL or text using state-of-the-art abstractive and extractive summarization models.

View this connector in GitHub.
vatcheckapi by Andras Fordos

vatcheckapi is a free and easy-to-use VAT lookup & validation service.

View this connector in GitHub.
VoiceRSS by Andras Fordos

Voice RSS Text-to-Speech (TTS) allows conversion of textual content to speech easier than ever.

View this connector in GitHub.

Learn more about Power Platform Connectors at the following links:

• Connectors overview: Power Platform connectors overview | Microsoft Learn
• Custom connectors overview: Custom connectors overview | Microsoft Learn
• Certification overview: Get your connector certified | Microsoft Learn
• Submit connector for certification: Submit your connector to Microsoft for certification | Microsoft Learn
• Connector auth types: Specifying connection parameters | Microsoft Learn
• Paconn tool: Microsoft Power Platform Connectors CLI | Microsoft Learn

The post ArcGIS, Meisterplan and Microsoft Translator among 60+ new connectors, 50+ connector updates launched to accelerate value from low code appeared first on Microsoft Power Platform Blog.

In this blog, I want to highlight some of the recent updates we are releasing in our platform for custom connectors. These changes are being rolled out, and will provide a better experience to enable a seamless ALM (application lifecycle management) for custom connectors. In Power Platform, Solutions are used to package components and deploy those components to various environment, customizing them as needed. The updates include:

• Users (makers) can now add any existing custom connectors to a Solution
• Users (makers) can create and use Environment variables in custom connectors
• Secrets used for OAUTH settings can be stored securely in Azure Key Vault
• Updated API documentation for custom connectors

With the above features, you can now easily enable end-to-end ALM for custom connectors. Any existing custom connector can now be added into a Solution. You do not have to start building your customer connector anew from inside a Solution. Environment specific values like API endpoints and OAUTH app details, can be externalized now in Environment variables and referenced by custom connectors. You do not need to update your custom connectors in different environments; and apps and flows targeting the custom connectors do not have to be modified in different environments. Finally, you can store your secrets using in your custom connectors in Azure Key Vault and use it via an Environment variable in your custom connector.

Let’s walk through an example.

We will use the Service Now custom connector available in our GitHub repo to illustrate these features, but you can use any custom connector.

First, we need to create the Service Now custom connector. You can sign up for a developer instance from Service Now if you need an instance. The Service Now custom connector supports OAUTH based authentication and there are certain configuration steps you need to do to enable that. It is fairly straight-forward though, and you can follow the documentation of the custom connector. You can watch this short video as well on how you can create the custom connector.

Next, we want to setup the connector so that we can externalize environment specific settings. In our case, we would want to externalize the Service Now Instance, and the OAUTH application details. Typically, if you are developing, you may be working on your own developer instance. In a production or UAT environment, you may want the connector to point to your production Service Now instance, and you may not have the necessary privilege to setup the OAUTH application.

To do that, lets create a Solution called “Snow Connector”, and add our custom connector. You can do that by selecting +Add Existing > Automation > Custom connector. You can see your custom connector in the “Outside Dataverse” category. Select the connector and click Add.

The next step is to create the Environment variables . To do that, select +New > More > Environment variable. Specify a display name, say SnowConnector_Instance, for the Environment variable and add the value which should be the instance name for your Service Now instance.

We need to add two other Environment variables for the OAUTH Client ID and OAUTH Client Secret. Because these are secrets, we will use the recently released feature of using Azure Key Vault as the secret store for these Environment variables. Create an Azure Key Vault account, add your secrets – one for the OAUTH Client ID and another for OAUTH Client Secret. Then, follow the instructions in our documentation to specify an access policy that will provide the Dataverse Application a read permission for secrets.

In your Solution, add a new Environment variable (called SnowConnector_ClientID) for the Client ID, specifying the Data type as “Secret”, the Secret Store as “Azure Key Vault”, and then add a reference to your secret specifying the Subscription Id, Resource Group name, Key Vault name and the Secret name.

Similarly, add another Environment variable (called SnowConnector_ClientSecret) for the Client Secret.

Because we are going to use the values of these Environment variables only in this environment, we want to make sure that the value are removed from the Solution. To do that, select the environment variable, scroll down to the Current value, select … > Remove from this solution.

The next step for us is to use these environment variables in our custom connector. To do that, edit custom connector and use the following formula @environmentVariables(“env_variable_name”). For our case, I updated the values for Host, and OAUTH security settings in our connector. For my Solution, this is:

Instance Name: @environmentVariables(“crd10_SnowConnector_Instance”)
Client ID: @environmentVariables(“crd10_SnowConnector_ClientID”)
Client Secret: @environmentVariables(“crd10_snowConnector_ClientSecret”)

Make sure you replace the Instance name at multiple places (Host, Authorization URL, Token URL and Refresh URL). The Client secret value is masked in the UI. See below:

Save your custom connector. And test to make sure that it is working.

Now, all you need to do is export the solution. For that, you go back to the Solutions list, select the “Snow Connector” solution, and click Export. Click Next > Export. Your Solution will now be exported and automatically downloaded as a .zip file.

You can then login to your test environment and import the Solution. While importing the Solution in the new environment, you can specify the values for the Environment variables. These values need not be the same as the one you used in the developer environment, but can be customized for the specific environment. For the Client ID and Client Secret, you can specify the value in the following format:

/subscriptions/{Subscription ID}/resourceGroups/{Resource Group Name}/providers/Microsoft.KeyVault/vaults/{Key Vault Name}/secrets/{Secret Name}

Once you are done with the import, you should be able to create a connection to your custom connector.

This walkthrough provides an overview of the end to end experience for packaging and deploying custom connectors across environments. You can leverage other ALM features like deploying the Solution from an Azure DevOps CI/CD pipeline by providing a deployment settings file as well.

There are still some limitations at the moment—

• Any change to an EV value is currently not reflected on the custom connector automatically. The changes are reflected only after an update of the custom connector.
• Environment variables in a custom connector can only be referenced from the Host/Base path and the security settings. Specifically, it is not supported in policies or within the operation definition.
• [Edit 2/10/2022] Environment variables using Azure Key Vault secrets can now cannot be deployed from an Azure DevOps and GitHub pipeline. Read the blog here.

Please try these features out, and do share any feedback you may have.

Happy Automating!

The post Easier deployments of Custom Connectors appeared first on Microsoft Power Platform Blog.

Independent Publisher connectors are connectors developed, tested, published, and supported by connector developers that are independent from the end service or API. Independent Publishers include Microsoft employees, MVPs, developers, and other community members focused on helping the community make the best use of Microsoft Power Platform connectors. The primary goal of Independent Publisher connectors is to provide the opportunity for anyone to publish a connector to the official list of Microsoft connectors.

Validation

The Microsoft Certification team performs validations and checks to ensure that the connector is safe to use. We perform the following validations: security validation, swagger validation, verification of the endpoint, and other quality checks. Learn more about how we validate all our connectors here.

All connectors are licensed under the MIT license.

User Experience within Power Automate

You can search for the connector like any other connector. All Independent Publisher connectors have the same icon and have an “(Independent Publisher)” label within their title.

View the publisher, statement about Independent Publisher connectors, connector overview, last updated date, link to the documentation, and GitHub repository. Once you hit “Accept,” you can use this connector anytime.

You can learn more about the connector by viewing the dedicated connector page.

Support

Please note that the connector is provided “as is” and is not owned or supported by Microsoft or the end service. If you have any issues with the connector, please submit the issue directly in GitHub here.

In the next two weeks, we will be adding an “Submit an Issue” button to all Independent Publisher connector pages so that users will not have to go into GitHub. The experience will submit the issue on your behalf!

If you have any feedback or questions, please reach out to connectorpartnermgmtteam@microsoft.com.

The post New connectors through the Independent Publisher connector program appeared first on Microsoft Power Platform Blog.

Prior to this program, Power Platform only accepted submissions from owners of the underlying service behind their connector. Over the years, we heard feedback from MVPs and developers regarding this limitation over the years and have addressed it through this program.

Have a connector in mind that you’d like to submit? Continue reading below!

Benefits

Here are just some of the few of the benefits of this exciting program:

• Gain visibility across Power Platform products and documentation. As an Independent Publisher, your name and brand will gain visibility directly from within our Power Platform products, documentation, and marketing content, including demos, videos, blogs, and social media posts.
• Maintainer rights on your connector. Your connector will be supported by you and the entire community of Independent Publishers.
• Share and collaborate on building custom connectors. Use GitHub to collaborate on making a fantastic connector!
• Receive the official stamp that your connector has been validated and certified. The Microsoft Certification team will run swagger validations, manual endpoint validations, and security validations.
• Open-source contribution. If you’re a Microsoft MVP, your contributions will also count as an open-source project contribution!

Soon, we will be providing a way to view usage metrics and reviews for your connector.

Getting Started

Going through the Independent Publisher program is easy! Once you build and test all operations in your custom connector, export the files and make all the necessary edits mentioned in the documentation here. After that, all you have to do is create a PR here in our GitHub repository. As part of your submission, be sure to include the necessary screenshots to prove that you’ve tested this connector. The Microsoft Connector Certification Team will then run automated validations, provide comments to help you improve the quality of your files, and then deploy your connector to Power Platform.

Once your connector is deployed, you can update it anytime in GitHub! Your update will undergo the same validations in addition to a breaking change validation to ensure that your change will not break existing flows, apps, or logic apps.

We’re excited to see what connectors you will submit!

This program was founded with the help of extraordinary project coordinators who graciously volunteered their time: Ahmad Najjar, April Dunnam, Daniel Laskewitz, Fausto Capellan, Jr., Paul Culmsee, and Rebekka Aalbers. If you’re interested in becoming a project coordinator to shape the future of the program, please take a look at our manifesto.

The post Submit a connector to Microsoft Power Platform as an Independent Publisher appeared first on Microsoft Power Platform Blog.

In related news, we’re very quickly approaching the milestone of 500 connectors available on the platform. It’s been great to see the growth of connectivity to these fantastic services and we’re excited for what’s to come.

Do check back next month for the monthly installment of connector releases!

Flotiq headless CMS

“Flotiq is the only headless Content Management System that features a Power Automate connector. With this – Flotiq now enables endless possibilities for integrating with existing enterprise systems, makes data migration easier and fits perfectly in existing environments. Using Flotiq and the Power Platform enterprises can now accelerate their adoption of headless content management and the modern API-based application development paradigm.”

Visit the Flotiq headless CMS documentation to learn more.

Resco Cloud

“Resco Cloud provides you with all-in-one mobile business solutions that are highly customizable, secure, feature-rich, and above all, 100% offline-ready, no compromises. The connector brings cutting edge mobility to any third-party systems and applications that support Power Automate integrations. Connect Resco Cloud with your solution via Power Automate – seamlessly, without any coding.” -Peter Sartoris, Tech-Lead Developer, Resco

Visit Resco Cloud documentation to learn more.

RiskIQ

“RiskIQ gives you back visibility and control across the extended enterprise, providing researchers, analysts, and teams on the ground visibility into their digital presence from every angle. It also provides CISOs and security management visibility into how attackers are targeting the organization. This real-time intelligence derived from both the enterprise attack surface and adversary infrastructure is key to prioritizing, analyzing, and triaging the new breed of pervasive, massive-scale threats currently wreaking havoc on the global community. RiskIQ PassiveTotal connector allows organizations to enrich event data with context to more efficiently and effectively respond to alerts, events, and incidents.”-Brandon Dixon- VP of Strategy

Visit the RiskIQ documentation to learn more.

intelliHR

“intelliHR is a People Management and Analytics platform that empowers organizations to work strategically, not just administratively. The intelliHR connector allows streamlined and automated solutions for continuous performance management, employee engagement and wellbeing, core human resources processes including onboarding and compliance, and more. Take control of your HR and people management activities and build a thriving culture that gets the most out of your most important asset: your people.”-Rob Bromage, CEO intelliHR

Visit the intelliHR documentation to learn more.

Asite

“The Asite connector allows users to transfer files bi-directionally between Asite and other business systems, enabling organizations working on capital projects to come together, plan, design, and build with seamless information sharing across the entire supply chain. Here, valuable metadata that is assigned to files in Asite can also be transferred, this includes system and custom metadata. The connector opens Asite up to an array of solutions on Microsoft Power Automate and is part of the wider Asite Ecosystem which works to further enhance our platform offering and provide our users with all of the tools they need to connect and build better.” – Denis Antony, Senior Vice President Global Product Management, Asite

Visit the Asite documentation to learn more.

Captisa Forms

“Create free online forms with workflows, conditional logic, duplicate detection rules, multi-level select, lookup, repeating panels, tabs, accordions. Add views and filters use them to analyze your data using charts or pivot grids, and then present them in dashboard. Automate document creation using Captisa Word Template, send PDF documents as email attachments, download PDF or Word documents. Generate multiple custom PDF or Word documents from a single form or linked forms. Share multiple forms with people outside of your organization with Portals.”

Visit the Captisa Forms documentation to learn more.

The post 6 New Connectors in April appeared first on Microsoft Power Platform Blog.

Unfortunately, many times documents are the bottleneck of workforce productivity. Often, people will perform manual processes like printing and scanning when there are digital ways for them to do that with PDFs. For example:

• Sign them with an electronic signature
• Combine them together into one document
• Convert Word, PowerPoint, and other files into PDFs
• OCR documents so that they can be searchable in SharePoint
• If a PDF is your only copy of a document, then convert them back into document formats like Word, PowerPoint, etc.

Fortunately, Adobe as the inventor of PDF and strategic partner with Microsoft, has brought many of these types of tools directly into Microsoft Power Automate to help you streamline and automate many of your document workflows. Through these connectors, all Adobe connectors are also available in Power Apps, Power Virtual Agents, and Azure Logic Apps to build integrated custom document workflows within the Microsoft ecosystem.

Adobe connectors in Microsoft Power Automate

Adobe has offered integrations for Microsoft Power Automate since 2017 with tools to help with document automation and has continued to expand and update the connectors with new features and templates:

Adobe Sign

Adobe Sign connector enables you to take your Word, PDF, PowerPoint, and other formats and route them for electronic signature. Using Adobe Sign connector with Power Automate allows you to dynamically route documents for approval based on data.

Some useful examples include:

• Send a selected file in SharePoint for signature.
• Send a selected record in Microsoft Dataverse for signature and merge data into fields.
• Create PowerApps with an e-signature
• Dynamically route documents for signature based on data and Azure. AD profiles.
• Automatically storing signed agreements and contracts in Microsoft SharePoint after they are signed.

Adobe Sign has over 30 templates and triggers pre-created for you to get started quickly.

Adobe PDF Tools

For people familiar using Adobe Acrobat for creating, editing, and manipulating PDF documents, the new Adobe PDF Tools connector these tools to your flows such as:

• Convert your Word, Excel, PowerPoint, and other formats automatically into PDF
• Convert PDFs back into editable formats like Microsoft Word, PowerPoint, Excel, and other formats
• OCR your scanned PDFs
• Convert HTML and data into PDF

Adobe PDF Tools connector has over 30 templates and triggers pre-created for you to get started quickly.

Quick Start example

Let’s walk through a quick example of how you can use some of the different connectors. We will use this template to demonstrate how you can use Adobe Sign and PDF Tools connectors together in the same workflow. In the example below, we will show how you can compress and optimize your PDFs using Adobe PDF Tools connector and then send them out for signature using one of the templates available.

Get your Adobe PDF Tools API credentials

If you haven’t already created credentials to use with Adobe PDF Tools API, you can create them here. PDF Tools API provides a 6-month trial to get started for free.

Once you provide a name and description, your client credentials will be generated. Keep this window open; you will need this information to create a connection in Microsoft Power Automate.

IMPORTANT NOTE: Adobe PDF Tools is a Premium connector so you will need to have the proper Microsoft Power Automate license to use the connector.

Get your Adobe Sign account

To use Adobe Sign connector, you will need to have an Adobe Sign for enterprise subscription. If you don’t and just want to give it a try, sign up for a developer account.

Create a new flow from a template

In this scenario, the flow has us taking a PDF, compressing it, and sending it for signature using Adobe Sign. Because sometimes PDFs can be large with huge images, we are going to have it compress the PDF first using Adobe PDF Tools and then send it for signature using Adobe Sign.

1. Go to this template.
2. Create a new connection for Adobe PDF Tools. You will need the Client ID, Client Secret, Organization ID, Technical Account ID, and Private Key from when you setup your key.
3. When you have entered all your credentials, click Create.
   
4. For Adobe Sign, create a new connection.
5. You may be prompted to choose what authentication level you want to connect as. Choose whether you would like the scope to be for you as an individual Adobe Sign user, group admin (i.e. access agreements within your user group you are an admin for), or account admin (you have full privileges across users).
   
6. You will then be prompted to log in with a pop-up to Adobe Sign using your credentials. Login and Allow Access.
   
7. When all your connections are created, click Continue to create your connection.

Configure SharePoint settings

Because the trigger for this template is a selected file in SharePoint, we need to set each of the SharePoint actions.

For the For a selected file, Get file properties, Get file content and Get file metadata actions, set the Site Address and Library Name to your desired SharePoint site.

PDF Services connector action

The condition in the flow is to determine whether the document is a PDF or not. It determines this based on the file extension. If it is a PDF, it will skip to the end. If it is not, then it will convert the document to a PDF.

The “Convert document to PDF” will take whatever document you have selected and convert it into a PDF.

You will notice that the action, like all the Adobe PDF Tools connector actions, have mainly two inputs:

• File Name: The name of the file of the input. It is important to have a file extension so that it knows which format to convert it from.
• File Content: The file content of the document you want to convert to PDF.

The file content is coming from the file contents of the selected file. Previously in the flow, the file content is stored in the FileContent variable. You don’t have to do it this way, but it is how this template is setup. You can also have it passed directly from Get File Contents with SharePoint.

After the condition, you will then see there is another action called Create Searchable PDF using OCR. This is used to OCR any PDF in case it is a scanned document that needs to be optimized. Like the previous action, we can see that it asks you to input the File Name and File Content. These values are coming from the output of the previous PDF step.

Why is it using variables?
The reason that there are variables is because of the condition. If the document is a PDF, then it is skipping the condition. But if it is not a PDF, it needs to get converted which will change the input going into the Create Searchable PDF using OCR action. By using variables, it makes it easier to change the values going into that action.

Adobe Sign connector actions

After the Create Searchable PDF using OCR action, there are two Adobe Sign connector actions. Let’s walk through what each of them do.

Upload a document and get a document ID
When you want to send a document for signature using Adobe Sign, you need to upload it to Adobe Sign as what is called a transient document, which returns a Document ID. The reason for this is it also allows you in other scenarios to upload a document once to Adobe Sign and then send it multiple times without having to upload a document every single time.

Like Adobe PDF Tools, you need to provide a File Name and a File Content value. In this template, these are passed from the Create Searchable PDF using OCR action.

Create an agreement from an uploaded document and send for signature

Once the document is uploaded to Adobe Sign, now you can send an agreement for signature.

Document ID the documents you would like to include with the agreement you send for signature. You can attach many by clicking “Add a new item”. The input is the Document ID from the Upload a document and get a document ID action.

Next, we need to add a recipient. Click on Add new item under Signature Type. This will expose a few settings. First is the email address which you can pass. For this example, we will set a static example email address, but you can use Dynamic content to pass the email address from a previous action.

Participant Order specifies in which order the recipient is signing. You can specify recipients to be in a parallel order or sequential order.

Participant Role allows you to specify what type of role the recipient needs to be such as Signer, Approver, Certified Recipient, Form Filler or Form Filler. If you want to learn more about the roles, you can learn about that here.

Message field is the message that will show up in the email to the recipient.

Expiration Time allows you to set limit for a recipient to sign a document. Once that passes, then the link to view and sign will no longer be active.

Reminder Frequency allows you to set how often Adobe Sign will send email reminders to the recipient.

Document Password allows you to encrypt the final PDF with a password.

Form Fields allow you to pass field values into a document. Adobe Sign allows you to merge form field values into fields in a document. You need to specify the Name (which corresponds to the name in the document) and the value you want to pass. This is also an array so you can add many. For more information on adding form fields to your document see the Adobe Sign Text Tag documentation.

Redirect Delay and Redirect URL allow you to specify which address to redirect a signer after they sign.

Once you trigger the agreement, the recipient(s) will receive an email with a link for them to view and sign an agreement.

Other Helpful Scenarios

There are several other scenarios that can be helpful for document processes:

Store signed agreements into SharePoint
OCR PDFs as they are imported into SharePoint
Password protect a new file in OneDrive and email as an attachment

What’s Coming Next

Adobe is only getting started with these connectors in Microsoft Power Automate. Coming soon, Adobe will be bringing additional features from its Adobe Document Services to Power Automate. Here are a few of the highlights:

Adobe Document Generation API

Document Generation API enables you to dynamically generate documents based on JSON data. Document templates are creating in Microsoft Word, and there is even an Add-In for Microsoft Word to allow you to easily tag your documents based on data. Whether it is data from Microsoft Dataverse, SharePoint, Excel, or other sources, you will be able to dynamically generate your documents, which also includes some of these features:

• Simple and easy template creation in Microsoft Word
• Support for complex data sets, so you can push data from your Power Automate actions directly in, even if there are complex data structures.
• Dynamically change and import images.
• Set conditional text and paragraphs based on data and conditions.
• Numerical calculations to calculate sum, average, etc. Inline from arrays of data inline in the template.
• Dynamically populate tables with data values.
• Integration with Adobe Sign to create tagged documents ready to be sent for signature.
• Export in multiple file formats such as Word or PDF.

An overview of the highlights are available here.

Adobe PDF Extract API

A lot of data is stored inside of PDFs, but it’s often difficult to reliably extract that data for use elsewhere. PDF Extract API converts PDFs into JSON data to reliably capture content structure, element positions, and relationships, which can be parsed and placed into data systems, republished in other platforms, or for search and analysis. Some the key benefits are:

• Reliable extraction of tables, even if they cross pages
• Reliable reading of columns of data and understand when related paragraphs span across columns or pages
• Understand and tag data into structures such as titles, headers, paragraphs, tables etc.

Final Thoughts

Adobe has provided a number of great connectors to help with document automation using Microsoft Power Automate. In addition to Power Automate connectors, Adobe PDF Tools and Adobe Sign also have add-ins for other Microsoft applications such as Adobe Acrobat for Microsoft Teams, Adobe Sign for Microsoft Teams, Adobe Sign for Word, Adobe Sign for SharePoint, Adobe Creative Cloud for Word and PowerPoint, and many others. These can be a great addition to the automated flows you create in Power Automate.

The post Automating document workflows with Power Automate and Adobe appeared first on Microsoft Power Platform Blog.

While it was previously possible to set up a trigger in a personal mailbox for when a received email was also sent “To:” a group email, there were several limitations to this experience and a dependency on the personal mailbox. With this feedback, we have been working on a Groups mailbox connector which works independently from a single user’s personal mailbox.

We are excited to announce the release of a new connector which unlocks these key scenarios – the Office 365 Groups Mail connector! This connector contains operations which work with a specified Group mailbox and unblocks many business scenarios around automating workflows with Group mailboxes. The connector works off the Microsoft Graph API, and uses terminology (conversation, thread, post) specified in the Graph API Groups documentation.

Read the connector documentation and look up the operations of the connector here.

Here is a sample scenario that this new connector makes possible:
Save attachments sent to an Office 365 Group to a SharePoint folder

1) Search for the new Office 365 Groups Mail connector.

2) Start off a new flow by adding the trigger for “When a new email arrives to a group” and creating a connection.

3) Select a specific Group from the provided dropdown menu. The dropdown should contain all Groups the account associated with the authenticated connection is a member of. You can also opt to specify a custom Group ID to access any Public Group within your organization; see the connector documentation for instructions on how to do so.

4) Attachments are located within the thread post data. To use the “Get a thread post” operation, in addition to the Group ID, we need the Thread ID, and Post Id which is returned when the original trigger fires.

5) When specifying the Conversation thread ID, Power Automate will automatically convert the operation in to an “Apply to each” loop operation to handle the threads. This is done as there could be more than one new thread for Power Automate to handle.

6) Simply reopen the operation dialog to enter the Post Id, and similarly, Power Automate will convert the operation to a loop to handle the posts.

7) Now that we have the post, we are ready to extract the attachment and save it to SharePoint. We can do this using the “Create file” operation of the SharePoint connector. Within the inner loop, add a “Create file” operation and select the SharePoint site and folder path. We can use the post data from the previous action to select the File Name (Attachment name) and File Content (Attachment content bytes). When you select the “Attachment name”, Power Automate will convert it into another loop to handle all the attachments. Your final flow should look like this.

As you can see, when a new email arrives to a Group mailbox, for every new post in every new thread, the flow will take each attachment and create a new file in SharePoint.

We are excited to hear how you use this connector to deliver impact in your businesses!

The post Use our new Office 365 Groups Mail Connector! appeared first on Microsoft Power Platform Blog.

Starting May 1, 2020 we’ll be rolling out changes that will potentially impact your flows that use the Gmail connector due to policy changes by Google. In line with Google’s data security and privacy policies, customers using a Gmail consumer account (email addresses ending with @gmail.com or @googlemail.com) will have certain limitations on the set of connectors that can be used along with the Gmail connector in a flow.

If you are using a G-Suite business account (email addresses with a custom domain), your flows will not be impacted, and there is no restriction on the use of the Gmail connector.

Under this policy, the Gmail connector, when used with a Gmail consumer account, can only be used with a limited set of Google-approved services. We will continue to work with Google to add more services to this list. For now, the set of Google-approved connectors that can be used with the Gmail connector in the same flow include:

• • Built-in actions and triggers: Control, AI Builder, Data operations, Date Time, Number Functions, Power Virtual Agents, Power Apps, Request, Schedule, Text Functions, Variables, Flow button, Location, Content Conversion Service
  • Google services: Gmail, Google Calendar, Google Contacts, Google Drive, Google Sheets, Google Tasks
  • Approved Microsoft Services: OneDrive, SharePoint Online, Excel Online, Dynamics 365, Microsoft Teams, Office 365, Planner, Outlook, OneNote, Word Online
  • Customer managed data sources: FTP, SFTP, SQL Server, HTTP, SMTP, RSS

NOTE: This list is subject to change. Going forth, we’ll post the complete and and up-to-date info in our documentation.

If you have an existing flow that will be impacted by the changes, we will also notify you via email to let you know of the impacted flows.  Starting June 9, 2020, any flow that is not compliant will be disabled. You will need to ensure that you use only one of the approved connectors in your flow before you can enable your flow again.

What can you do if your flow is impacted?

You may need to use the Gmail connector with a Gmail consumer account in a flow with some of the non-approved connectors.  In this case, we have rolled out an option to use your own Google application for personal or internal use in your enterprise.

To enable that, you will need to:

• Create an OAuth client application using Google’s API Console
• Use the settings of your client application in the Gmail connector

For details on the steps, you can read the instructions here in the Gmail connector reference documentation.  Briefly, you can use Google’s setup tool and follow the steps to create an OAuth Client application.  Here’s some useful information—

• Add the Gmail scope (https://mail.google.com)
• Add “azure-apim.net” as one of the authorized domain
• Use “https://global.consent.azure-apim.net/redirect” for Redirect URI

The finished screen will look like below:

To use the app in your Gmail action or trigger, select “…” > + Add new connection to create a new connection. Select “Bring your own application” as the Authentication Type and specify the value of “Client ID” and “Client secret” from your Google app.

When you click on “Sign in”, you will see that the login screen reflects the app you created.  In case you are using a Gmail consumer account, you may see a screen that the App is not verified by Google.

Now you should be able to use the Gmail connector in your flows without restrictions.

The post Upcoming changes to the Gmail connector appeared first on Microsoft Power Platform Blog.

Using the trigger is straightforward.  Select the appropriate trigger.  Create your connection (if you have not already) or select an existing connection.  Then, select the table from the drop-down. [If you don’t see your table, see the notes below.]  You can also choose to further limit the rows returned by specifying a filter.

Once you configure the trigger, you can now use the output from the trigger in any action in your Flow or Logic App.  The trigger will make available the columns of the selected tables.

You can now save the flow, and it will kick off whenever a row is added to (or modified in) the selected SQL Database table.

That’s it.  You now have a working flow that you can use to monitor and automate whenever rows are added or modified in your SQL table.

Limitations

The triggers do have the following limitations:

• It does not work for on-premises SQL Server
• Table must have an IDENTITY column for the new row trigger
• Table must have a ROWVERSION (a.k.a. TIMESTAMP) column for the modified row trigger

A Brief note on the design and on the limitations

Some of you might have noticed that this feature has been available for some time now as a limited preview feature of Logic Apps in the East US 2 region.  Designing and implementing a trigger is more complex than adding actions.  This is because, the trigger needs to monitor and track changes.  In the case of SQL Databases, unfortunately, there is no mechanism of tracking changes that will work for all tables.  Therefore, specific tables must have specific column types which are designed for change tracking.  In order to track changes like addition or modification of rows in a table, the table must have a column whose value is unique and whose value increases (or decrease) monotonically each time such a change is made.  This is satisfied by having an IDENTITY column for tracking creation, and ROWVERSION (a.k.a. TIMESTAMP) column for tracking modification .

So, what happens when there is no such column in a table?  Those tables will not be listed when you try to use the trigger.  And, it will not work if you do try to type the table name manually.  The only workaround then is to externalize the state yourself and use the “Get rows” action to query for the changes.

We would, of course, like to hear your feedback.

The post Introducing triggers in the SQL Connector appeared first on Microsoft Power Platform Blog.

Let’s look at a quick example to learn more. Imagine that you have a SharePoint list to track Travel requests. This list has the following fields. Notice how it’s a mix of Text, Date and Time, Choice, Person, and Lookup. 

Let’s now create an approval flow for incoming travel requests using this template and point it to the Travel Requests list.

In the Yes branch, let’s add a new action, SharePoint – Update item, and point it to the same site and list as the trigger. Notice how the Update item action now includes all editable fields from the list. The same applies to the Create item action also.

Furthermore, the list of possible values for the Choice (Approval Status) and Lookup (Team) fields are the same as those presented in SharePoint. For the Person field (Backup Engineer), you’ll have to type in a valid email address.

We hope you can make use of these new additions as you build out new flows and enhance existing ones.

Known issues

There are two known issues with this release that we will be addressing in the coming weeks.

1. Once you have created your flow, if you add a new Person, Choice, or Lookup field to your list, attempting to edit and save your Flow will result in an error at runtime. To work around this issue, you must delete and recreate the Update item or Create item action in your flow.

Note – This applies only if you edit your Flow, otherwise the flow will continue to run.

2. To write to a Person field, you must enter a valid email address for an individual in your organization.

Coming soon

We continue to invest in our SharePoint + Flow story and want to ensure that Flow is a worthy successor to SharePoint Designer workflow. Some of the upcoming features on our connector roadmap include:

• Support for Managed Metadata fields (aka Taxonomy)

• Support for document library metadata

• Support for multi-values fields

• Support attachments for list items

• Support content publishing workflows

Share your feedback using the comments below. Have a question or an idea? Head over to the Microsoft Flow Community.

The post Setting SharePoint’s Person, Choice, and Lookup fields appeared first on Microsoft Power Platform Blog.