![Encodian](/img/default-banner.jpg)
- 82
- 147 144
Encodian
United Kingdom
Registrace 29. 03. 2018
Populate Microsoft Excel templates with Power Automate | 💡 Learn with Encodian
In this tutorial, Sophie will show you how to use Encodian Flowr's 'Populate - Excel' to do just that! Automate the building of Excel spreadsheets to save yourself time and money, and reduce human error!
JUMP TO...
0:00 - Intro
0:43 - Dataverse & Power App
7:26 - Power Automate Flow (1/3)
9:55 - Excel Template
13:26 - Power Automate Flow (2/3)
14:16 - 'Populate - Excel' action
14:36 - Power Automate Flow (3/3)
15:29 - Results
16:29 - Roundup
📝 Check out Sophie's companion blog post: www.encodian.com/resources/blog/convert-pdf-to-png-with-power-automate/
NEED AN ENCODIAN FLOWR ACCOUNT?
We've got a free 30-day trial, and even a free plan!
👉 Start automating today: www.encodian.com/products/flowr/
Stuck and need more info? You've got options:
1. WANT TO BUILD YOUR FLOW YOURSELF?
Reach out to our incredible support team:
📧 Email support@encodian.com
2. WANT US TO BUILD YOUR FLOW?
Reach out to our award-winning Professional Services team:
📧 Email sales@encodian.com
JUMP TO...
0:00 - Intro
0:43 - Dataverse & Power App
7:26 - Power Automate Flow (1/3)
9:55 - Excel Template
13:26 - Power Automate Flow (2/3)
14:16 - 'Populate - Excel' action
14:36 - Power Automate Flow (3/3)
15:29 - Results
16:29 - Roundup
📝 Check out Sophie's companion blog post: www.encodian.com/resources/blog/convert-pdf-to-png-with-power-automate/
NEED AN ENCODIAN FLOWR ACCOUNT?
We've got a free 30-day trial, and even a free plan!
👉 Start automating today: www.encodian.com/products/flowr/
Stuck and need more info? You've got options:
1. WANT TO BUILD YOUR FLOW YOURSELF?
Reach out to our incredible support team:
📧 Email support@encodian.com
2. WANT US TO BUILD YOUR FLOW?
Reach out to our award-winning Professional Services team:
📧 Email sales@encodian.com
zhlédnutí: 76
Video
Generate an Image/Picture QR Code using Power Automate and Power Apps | 💡 Learn with Encodian
zhlédnutí 18Před 10 hodinami
In this tutorial, Sophie will teach you how to generate a picture QR Code using Power Apps and Power Automate. She'll also introduce you to Encodian Flowr's 'QR Code - Create' action, too! JUMP TO... 0:00 - Intro 0:13 - Power App (front end) 1:35 - Power App (back end) 4:20 - Power Automate (1/2) 5:00 - QR Code - Create action 6:43 - Power Automate Flow (2/2) 8:07 - Results 8:39 - Round up 📝 Ch...
Convert PDF to PNG with Power Automate
zhlédnutí 35Před 21 dnem
In this tutorial, Sophie will review how easily you can convert a PDF to PNG using Encodian Flowr’s 'Convert PDF to PNG' action. She will also be showing you how to use the 'Split PDF' action too! JUMP TO... 0:00 - Intro 0:31 - SharePoint Library (scenario) 1:44 - Power Automate Flow (1/2) 4:20 - Split PDF action 6:00 - Convert PDF to PNG action 7:30 - Power Automate Flow (2/2) 7:54 - Test 8:30...
Get Text from Word with Power Automate
zhlédnutí 49Před 21 dnem
For this tutorial, Sophie explores how to extract text from a Word document using Encodian Flowr's 'Get Text from Word' action to determine languages with Power Automate. JUMP TO... 0:00 - Intro 0:25 - SharePoint Library 0:59 - Power Automate Flow (1/2) 1:30 - Get Text from Word Action 2:28 - Power Automate Flow (2/2) 4:51 - Test 5:32 - Results 5:56 - Round up 📝 Check out Sophie's companion blo...
Merge Approved Microsoft Word Documents with Power Automate | 💡 Learn with Encodian
zhlédnutí 100Před měsícem
Sophie's latest video explores how to merge 'Approved' Microsoft Word documents into a single file before converting the merged file into a PDF document. When merging the Word documents, we must also ensure that the table of contents has automatically updated to include any new pages. Fancy reading Sophie's how-to? www.encodian.com/resources/blog/merge-approved-word-documents/
Convert JSON to Microsoft Excel with Power Automate | 💡 Learn with Encodian
zhlédnutí 92Před měsícem
This post will explore how to convert JSON to Microsoft Excel using Encodian Flowr's Convert JSON to Excel action. This action converts JSON and produces a Microsoft Excel file.
Remove Watermarks from Microsoft Word with Power Automate
zhlédnutí 32Před měsícem
For this video, Sophie, Encodian's Technical Evangelist, will explore removing a watermark from a Word document using Encodian's Flowr. The solution uses two of Flowr's actions: Remove Watermark from Word, and Convert to PDF The scenario for this example is that the sales team uploads Word working (draft) documents to a SharePoint folder containing a 'Draft' watermark. Once a document is comple...
Create and digitally sign PDFs from Power Apps | 💡 Learn with Encodian
zhlédnutí 132Před 2 měsíci
This video demonstrates how to create and sign PDF documents using Power Apps, Power Automate, and the Encodian Flowr Power Automate connector. We will look at a simple Power App for employees to add their sickness details after a sick day. Once they have filled out the form, the details are generated in a signed PDF document stored against the record in Dataverse. This scenario shows you how t...
Delete Rows from Microsoft Excel with Power Automate | Automate Excel series
zhlédnutí 390Před 2 měsíci
In the Automate Excel series video, Sophie will look at deleting rows from Microsoft Excel and CSV files using the Encodian Flowr 'Delete Rows from Excel' action. Your data doesn't need to be in table format to use this action; it works with structured and unstructured data! Read Sophie's companion blog for a step-by-step guide: www.encodian.com/resources/blog/delete-rows-excel/
Merge Rows in Microsoft Excel with Power Automate | Automate Excel series
zhlédnutí 171Před 2 měsíci
In this instalment of our Automate Excel series, we will examine how to merge rows across different worksheets in Excel. Consider the following scenario: sales data is split across three different regions (North, South, and Midlands). We need to merge this data to create one combined National worksheet. To achieve this, we will use Encodian Flowr's 'Merge Rows in Excel' action. Read Sophie's co...
Update Rows in Microsoft Excel with Power Automate | Automate Excel
zhlédnutí 670Před 3 měsíci
In this Automate Excel series video, we will look at how to update rows in your Excel files using Flowr's 'Update Rows in Excel' action. The action allows you to update rows in your Excel files in data tables and rows that aren't contained in a table format! For a step-by-step guide, check out Sophie's companion blog: www.encodian.com/resources/blog/update-rows-excel/
Encodian Indxr Guide - Automation
zhlédnutí 51Před 3 měsíci
A step by step guide for configuring Encodian Indxr to automatically run on a defined schedule to automate OCR'ing PDF files in SharePoint Online Reference: support.encodian.com/hc/en-gb/articles/11289553468828-Automate-Indxr-Executions
Encodian Indxr Guide - Run Indxr
zhlédnutí 39Před 3 měsíci
A step by step guide for running Encodian Indxr, the bulk OCR tool for SharePoint online. Reference: support.encodian.com/hc/en-gb/articles/11275303028508-Perform-OCR-Configuration
Encodian Indxr Guide - Authentication
zhlédnutí 23Před 3 měsíci
A step by step guide for authenticating Encodian Indxr to a SharePoint Online Tenant. Reference: support.encodian.com/hc/en-gb/articles/11454530223388-Authentication-Options
Add Rows to Excel with Power Automate | Automate Excel
zhlédnutí 668Před 3 měsíci
Learn how to automate the adding of rows with Encodian Flowr's 'Add Rows to Excel' action in Sophie's latest video in our Automate Excel Series. Made possible through Microsoft's Power Automate. Prefer to read a step-by-step guide? Check out Sophie's Companion blog: www.encodian.com/resources/flowr/add-rows-to-excel-with-power-automate/
Remove duplicate entries from Excel and CSV files in Power Automate
zhlédnutí 731Před 4 měsíci
Remove duplicate entries from Excel and CSV files in Power Automate
Get Rows from Microsoft Excel | Automate Excel with Power Automate
zhlédnutí 1,7KPřed 4 měsíci
Get Rows from Microsoft Excel | Automate Excel with Power Automate
Using Customer AI Prompts in Microsoft Power Apps and Power Automate
zhlédnutí 483Před 4 měsíci
Using Customer AI Prompts in Microsoft Power Apps and Power Automate
Redact Sensitive Data from PDFs | Microsoft Power Automate's AI Builder and Encodian Flowr
zhlédnutí 328Před 4 měsíci
Redact Sensitive Data from PDFs | Microsoft Power Automate's AI Builder and Encodian Flowr
Check text contains a value with Power Automate
zhlédnutí 507Před 5 měsíci
Check text contains a value with Power Automate
Split text values (strings) in Power Automate
zhlédnutí 286Před 5 měsíci
Split text values (strings) in Power Automate
Replace values in text using Power Automate
zhlédnutí 464Před 6 měsíci
Replace values in text using Power Automate
Power Automate's New Designer Explained
zhlédnutí 534Před 6 měsíci
Power Automate's New Designer Explained
Remove Text between Values in Power Automate
zhlédnutí 353Před 6 měsíci
Remove Text between Values in Power Automate
Format by Example - Using Power Automate and AI to format numbers, dates and strings
zhlédnutí 202Před 6 měsíci
Format by Example - Using Power Automate and AI to format numbers, dates and strings
Add and Remove Watermarks from PDF Documents
zhlédnutí 256Před 6 měsíci
Add and Remove Watermarks from PDF Documents
Process Mining Analytics: Discover how to start improving your cloud flows
zhlédnutí 52Před 7 měsíci
Process Mining Analytics: Discover how to start improving your cloud flows
How to proportionally watermark an image with Power Automate
zhlédnutí 169Před 8 měsíci
How to proportionally watermark an image with Power Automate
This looks different now
Hey! Thank you for this very helpful video. Is it also possible to integrate this Flow into PowerPages so that this process would work with extern users?
Hi! I'm glad you found the video helpful! If you contact support@encodian.com, they may be able to help with your query.
Excellent video. Thank you so much! Is there a different "Redact PDF" Flowr? Encodian requires signing up and is costly. Their website is terrible, I couldn't even signup for a trial.
Hi @kevennguyen3507, we apologise if you found our website difficult to use and couldn't start your free trial. Hundreds of people sign up every day without issue, so your case is rare! All you need to do is head to our Flowr page (www.encodian.com/product/flowr) or Try Now page (www.encodian.com/try-now/) to get your API, and you're ready to start automating! We try our best to make sure automation is accessible to all, which is why we have a free Flowr plan which costs no money at all. (You will automatically switch to this after your Free Trial unless you upgrade.) If you need help setting this up, please contact our award-winning support team via our support site or by email at support@encodian.com. Thanks for your feedback, and I hope you get this issue resolved. - Ev
Thanks.. totally was able to generate the code and copy/paste, but on testing it, I receive a "Status" '404' error for "message" "file not found clientRequestID: This occurs in the "GET FILE CONTENT" step and I have no idea why. The tigger and trigger condition worked correctly upon modifying the list item, but not sure why it cannot "Get File Content" or what this error means. Any ideas on how to correct? Thanks!
Thank You master :)
This is terrific! Could you please export the template/solution? Or walk us thru each step in more detail?
Hi! We're glad you found our tutorial valuable. You can find Sophie's companion blog here: www.encodian.com/resources/flowr/get-rows-from-excel/ If you still have more questions, please email support@encodian.com, and they should be able to support you further. Thanks!
Thank you so much for this!! Is there any way that you can delete the duplicated cases based on a specific column? For example when the email addresses are duplicated, delete the whole role sth like that. Thank u!
Hi! We're glad you found our tutorial valuable. If you email support@encodian.com, they should be able to support you with your question. Thanks!
Great video thanks
was looking for how to remove a specefic row
You can do this with the 'Delete Rows from Excel' action (which also supports CSV files) - support.encodian.com/hc/en-gb/articles/9936160309148
Is it possible to parse multiple tables from a single html file?
Edited: By default the action will return the data from the first table found. To target other tables use the 'Table Index' or 'Table ID' properties
Anyone knows if it is at all possible to populate several images with the repeating control in Word? If I define at table as repeated and insert an image control - when in Powerapps I cannot assign value to the image, only the text controls.
You cannot do this with the native 'Word Online' premium connector, you can do this with Encodian 'Populate Word' action, example of working with multilpe images is also provided here: www.encodian.com/blog/add-sharepoint-list-item-data-to-a-document/
@@encodian I tried using encodian but was asked for API key, connection name and region... so I figured this is something I'm not allowed to use at work...
@@s961201 - You simply need to register for an API Key @ www.encodian.com/apikey
Thank you . Help me a lot to solve a issue
Do youknow how to edit an older flow? I get a message 'New designer cant be used for this flow yet' but it wont allow me to change to the classic and edit?
Just add this to the URL which disables the new designer &v3=false
But what if i just want to dismiss the fist page and keep the rest?
This is pretty simple; split the document using the following page array configuration: [1-1],[2-999999] .This should create two documents, and either loop through using a foreach loop to get the 2nd document or reference directly with an expression, noting that arrays are zero based indexes so the 2nd document is 1. Filename property: outputs('Split_PDF')?['body/documents'][1]?['fileName'] and File Content property: outputs('Split_PDF')?['body/documents'][1]?['fileContent']
@@encodianThanks, i'll try it
@@encodianIt worked, thanks
How do I get the convert option
You need to install the Encodian Vertr SharePoint App - support.encodian.com/hc/en-gb/articles/10873157536541-Deploy-Vertr-to-all-SharePoint-Online-Sites
Do we have a top right option in the orientation field?
This is not an option currently but feel free to raise a feature request via our community forums located - support.encodian.com/hc/en-gb/community/topics/360000062053-Feature-Requests
Can you remove any watermark or just the ones created with Encodian?
@@plamendimitrov9097 - The action will remove all watermarks, not just those created by Encodian
@@encodian Thank you! This is exactly what I need!
Hi can we make the orientation top right?
Hi! If you contact support@encodian.com, they should be able to help with your query! Thanks
Hi! its a good explanation, I have a doubt, Im trying to create a flow to assign a person who will lead the team meeting that occurs Monday, Wednesday and Friday, each day should be different person and there are 25 members on the department, Is there any way I can automate the meeting to assign a moderation role with different person until everybody has been moderator? do you have any example of how can I do this? Thanks in advance!!!
Hi! If you contact support@encodian.com they may be able to help with your query! Thanks!
Hi, I have DOB column in my SharePoint list and a Age text column, where I would like to populate no of age using power automate flow once a day, please advise
Hi! If you email support@encodian.com, they should be able to help with your query!
Thanks. I am using power automate desktop. I like to extract a webpage with 250+ rows. I like to put all rows in ' live web helper' popup , but it is taking only 20 rows. I am trying to get ' Extract entire HTML table" after right clicking on entire web selected on 'live web helper'......BUT, " Extract entire HTML table" is not showing!!! Any clue , please . ( I am beginner in power automation )
Hi @liakat26! If you're still struggling with this we suggest getting in touch with our friendly support team 👉 support@encodian.com They can ask you more about your scenario and help you directly!
how to escape all characters? like '\'?
I'd suggest contacting support@encodian.com - its not clear what you are trying to escape... if you are trying to escape speech marks / double quotes please review - www.encodian.com/blog/escape-double-quotes-in-json-using-power-automate/
If I insert wrong email address still showing result true.
This action is validating the format of the email address using a regex. You can tweak the regex in the advanced settings as needed if there is an outlier you need to cover. The regex is not 100% aligned to the RFC but acknowledged as one the concise versions which provides good coverage.
Hi Jay - Nice - assume this uses 2 Encodian credits?
Hi Rory - Thanks, yes a credit is consumed everytime you call an Encodian action.
Thanks! Can you please do a video on repeating paragraphs with hanging indentations? Used allow carriage option in plaintext but new line is always starting as indented
The engine will repeat the exact data contained within the <foreach> tag... if a carriage return is being added it must be present within the repeating paragraph.
How did you format the Evidence field to read the image? Is there any watermark added? When I type the text <<image [evidence] -keepRatio>> Power Automate returns the error "The following error occurred populating the word document provided: Tag 'image' is not well-formed. Tag 'image' must be located within an image "
same here. do you have any updates about that?
well i've figured it out, thanks
@@YasintaKurnia99 nice ;)
The image tag would only ever insert an image into the document, adding a watermark is a totally different amendment to the document which can be performed with the 'Add Text Watermark to Word' action - support.encodian.com/hc/en-gb/articles/4411284008593-Add-Text-Watermark-to-Word Please refer to the following documentation which provides a visual guide on how to configure the word document and Encodian image token - support.encodian.com/hc/en-gb/articles/10401460927388-Images
Erro recebido: The response is not in a JSON format.
Please contact support@encodian.com. Please review the full Output from the action, the error message 'The response is not in a JSON format' is a generic Power Automate message, the actual issue will be detailed in the Output of the action. Noting, this will be an authentication issue (incorrect API key) or you have ran out of actions.
@@encodian more details: "Body" { "error": { "code": 401, "source": "flow-apim-europe-002-northeurope-01.azure-apim.net", "clientRequestId": "cc9a67f8-cea8-4754-914f-f907d07740df", "message": "The response is not in a JSON format.", "innerError": "The API Key provided is not valid" } }
Hi Sir, is that a dynamic QR code?
All QR codes are dynamically generated based on the data and configuration supplied
Hi, is there any way to remove blank row (last blank row) from CSV?
Sure, you can do this with the 'Delete Rows from Excel' action - support.encodian.com/hc/en-gb/articles/9936160309148-Delete-Rows-from-Excel
Love it! Soooo clearly explained 😄
Thanks, Tina! Glad we could help!
The pdf is blank
This will be caused by the data you are passing to the action, please contact support@encodian.com if you need advice configuring your flow.
I'm filtering the data based on their extensions and then converting it into pdf. This is giving me an error Name and Content bytes of type Array must be a primitive type.
Hi ,i am getting error route did not match status :400 can u plz help I want to populate image attachment to word template any help much appreciated!!!
Please contact support@encodian.com, a 400 error is generated when invalid data is sent for processing.
Can this be done for mail merge from excel to word and save the file?
This method I assume is free connectors avoiding the premium associated with connecting in to word? If so This looks great for what I need!
The Encodian connector is a 'Standard' connector and does not require Microsoft Power Platform premium licences
Very helpful, Many thanks
Hello, I have a doubt, I need to populate a Word with at least 5 attachments and also want the names to be displayed on top of the image it will generate. What would be the correct form to write the word document?
Please refer to the following post which provides a detail example of how to do this - www.encodian.com/blog/add-sharepoint-list-item-data-to-a-document/
can it used on powerapps?
Yes, just pass the data from your PowerApp to Power Automate 😎
Does this work for tables with multiple records?
Sure does, check out - support.encodian.com/hc/en-gb/articles/360020426438-Tables
Thanks, a great explanation and you answered my question in under 3 minutes.
Is there a way to modify a document like deleting a chapter based on a condition?
@josephus - Yes, you can use conditional expressions to control the data added to a document - support.encodian.com/hc/en-gb/articles/360020512538-Conditional-Expressions
It doesn't work for me. No matter what I do, some random backslashes are added, so using your example, I get: [{\"Team\":\"Aston Villa\", ... etc
The backslashes are not random, it is simply escaped JSON. The Encodian action is not returning the data escaped... depending on the size and how you are viewing the data, Power Automate may display the data in an escaped form. This is explained further in this blog post: www.encodian.com/blog/parsing-json-returned-by-encodian-actions/
Nice work. Interesting!!!
Hi! using this action is it possible to set a transparent background for the QR code? Thanks
No, we do not support this but a transparent background would allow the background to become part of the QR code, thus corrupting the QR code itself.
Great approach. Very useful!
Hello, Encodian Team. I would like to apply an image to a fillable PDF. I was trying to send that image as base 64 format but I don't see that image in my pdf file. Could you give me a tip for visualize my image (base 64) in my PDF? Thanks for your help. Regards!
Please refer to the following article on our 'Fill a PDF Form' action which covers this requirement - support.encodian.com/hc/en-gb/articles/360008556077-Fill-a-PDF-Form
Hi , can you please elaborate the expression which is used in "Get Attachment Content " action
We're using the Power Automate first() expression to return the first item in an array. examples: www.encodian.com/blog/get-the-first-item-or-first-file-from-an-array-in-power-automate/
Thank you very much!
I'm a complete newbie to Power Automate, and this answered my question exactly. Thank you!
great video, thank you!
you are a legend
Hello i have a problem with the output, im trying to generate a qr code and the error says " Bad Request" and in the output code at the error field it says "The Data field is required."