Hi, my Excel file gets generated, and the flow runs. But I get this error in my result Excel file in the last cell of my table after closing the foreach. "Error! Can not copy or remove contents between the specified range. The operation is allowed only for text ranges within a single cell, textbox, chart title, or chart series name and row ranges within a single worksheet. " I have no idea what this means; please help in understanding this.
@1066sgp6 күн бұрын
Very useful. Thanks
@chrisjanowski753610 күн бұрын
Saved me!
@huhuhao18 күн бұрын
Hi Encodian, how many actions to be counted in this video? Does convert non-PDF to PDF and merge count as 2 separate actions?
@jennafischer4497Ай бұрын
This looks different now
@PieceFairyАй бұрын
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?
@encodianАй бұрын
Hi! I'm glad you found the video helpful! If you contact [email protected], they may be able to help with your query.
@kevennguyen3507Ай бұрын
Excellent video. Thank you so much! All worked out well for me and I'm trying out the trial.
@encodianАй бұрын
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 [email protected]. Thanks for your feedback, and I hope you get this issue resolved. - Ev
@jaredwaterman5868Ай бұрын
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!
@szaitisАй бұрын
Thank You master :)
@jasontellone72852 ай бұрын
This is terrific! Could you please export the template/solution? Or walk us thru each step in more detail?
@encodian2 ай бұрын
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 [email protected], and they should be able to support you further. Thanks!
@Daniel-us8kf12 күн бұрын
I feel like your glossing over the point of the video at 2:04. How do you use it as an input? Get a Row from Excel still specifies a file and table. How do I switch it to grab the data made in the previous step?
@cometred97812 ай бұрын
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!
@encodian2 ай бұрын
Hi! We're glad you found our tutorial valuable. If you email [email protected], they should be able to support you with your question. Thanks!
@Aamiraps3 ай бұрын
Great video thanks
@jonaskarlsson4774 ай бұрын
was looking for how to remove a specefic row
@encodian4 ай бұрын
You can do this with the 'Delete Rows from Excel' action (which also supports CSV files) - support.encodian.com/hc/en-gb/articles/9936160309148
@prithvi2135 ай бұрын
Is it possible to parse multiple tables from a single html file?
@encodian5 ай бұрын
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
@s9612015 ай бұрын
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.
@encodian5 ай бұрын
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/
@s9612015 ай бұрын
@@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...
@encodian5 ай бұрын
@@s961201 - You simply need to register for an API Key @ www.encodian.com/apikey
@lucasbarna61766 ай бұрын
Thank you . Help me a lot to solve a issue
@jenniferdinero5856 ай бұрын
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?
@encodian5 ай бұрын
Just add this to the URL which disables the new designer &v3=false
@user-rk5vo4rc7j6 ай бұрын
But what if i just want to dismiss the fist page and keep the rest?
@encodian6 ай бұрын
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']
@user-rk5vo4rc7j6 ай бұрын
@@encodianThanks, i'll try it
@user-rk5vo4rc7j6 ай бұрын
@@encodianIt worked, thanks
@ivantchangam45636 ай бұрын
How do I get the convert option
@encodian6 ай бұрын
You need to install the Encodian Vertr SharePoint App - support.encodian.com/hc/en-gb/articles/10873157536541-Deploy-Vertr-to-all-SharePoint-Online-Sites
@komailbutt29986 ай бұрын
Do we have a top right option in the orientation field?
@encodian5 ай бұрын
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
@plamendimitrov90975 ай бұрын
Can you remove any watermark or just the ones created with Encodian?
@encodian5 ай бұрын
@@plamendimitrov9097 - The action will remove all watermarks, not just those created by Encodian
@plamendimitrov90975 ай бұрын
@@encodian Thank you! This is exactly what I need!
@komailbutt29986 ай бұрын
Hi can we make the orientation top right?
@encodian6 ай бұрын
Hi! If you contact [email protected], they should be able to help with your query! Thanks
@user-dr3gd8is9f6 ай бұрын
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!!!
@encodian6 ай бұрын
Hi! If you contact [email protected] they may be able to help with your query! Thanks!
@sanprasa17 ай бұрын
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
@encodian6 ай бұрын
Hi! If you email [email protected], they should be able to help with your query!
@liakat269 ай бұрын
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 )
@encodian9 ай бұрын
Hi @liakat26! If you're still struggling with this we suggest getting in touch with our friendly support team 👉 [email protected] They can ask you more about your scenario and help you directly!
@sheikhmuzammil899 ай бұрын
how to escape all characters? like '\'?
@encodian5 ай бұрын
I'd suggest contacting [email protected] - 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/
@bhaveshmore35909 ай бұрын
If I insert wrong email address still showing result true.
@encodian9 ай бұрын
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.
@DataSpinners11 ай бұрын
Hi Jay - Nice - assume this uses 2 Encodian credits?
@encodian11 ай бұрын
Hi Rory - Thanks, yes a credit is consumed everytime you call an Encodian action.
@viewmaja11 ай бұрын
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
@encodian5 ай бұрын
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.
@Tomaszrobin11 ай бұрын
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 "
@YasintaKurnia999 ай бұрын
same here. do you have any updates about that?
@YasintaKurnia999 ай бұрын
well i've figured it out, thanks
@Tomaszrobin9 ай бұрын
@@YasintaKurnia99 nice ;)
@encodian5 ай бұрын
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
@drbadiodefora Жыл бұрын
Erro recebido: The response is not in a JSON format.
@encodian Жыл бұрын
Please contact [email protected]. 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.
@drbadiodefora Жыл бұрын
@@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" } }
@geniffreybote3480 Жыл бұрын
Hi Sir, is that a dynamic QR code?
@encodian5 ай бұрын
All QR codes are dynamically generated based on the data and configuration supplied
@AU-1120 Жыл бұрын
Hi, is there any way to remove blank row (last blank row) from CSV?
@encodian5 ай бұрын
Sure, you can do this with the 'Delete Rows from Excel' action - support.encodian.com/hc/en-gb/articles/9936160309148-Delete-Rows-from-Excel
@TinaDerby01 Жыл бұрын
Love it! Soooo clearly explained 😄
@encodian Жыл бұрын
Thanks, Tina! Glad we could help!
@user-wy3ol9ny8o Жыл бұрын
The pdf is blank
@encodian Жыл бұрын
This will be caused by the data you are passing to the action, please contact [email protected] if you need advice configuring your flow.
@hemantsahu475711 ай бұрын
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.
@a.trip.around.the_sun Жыл бұрын
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!!!
@encodian5 ай бұрын
Please contact [email protected], a 400 error is generated when invalid data is sent for processing.
@cedrictay3679 Жыл бұрын
Can this be done for mail merge from excel to word and save the file?
@davidoddy4668 Жыл бұрын
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!
@encodian5 ай бұрын
The Encodian connector is a 'Standard' connector and does not require Microsoft Power Platform premium licences
@ashrafshorman6113 Жыл бұрын
Very helpful, Many thanks
@shamirnostasayala4676 Жыл бұрын
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?
@encodian Жыл бұрын
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/
@SystemPRM Жыл бұрын
can it used on powerapps?
@encodian Жыл бұрын
Yes, just pass the data from your PowerApp to Power Automate 😎
@jb-yc7oc Жыл бұрын
Does this work for tables with multiple records?
@encodian Жыл бұрын
Sure does, check out - support.encodian.com/hc/en-gb/articles/360020426438-Tables
@chrisparker7016 Жыл бұрын
Thanks, a great explanation and you answered my question in under 3 minutes.
@josephusmelegrito7201 Жыл бұрын
Is there a way to modify a document like deleting a chapter based on a condition?
@encodian Жыл бұрын
@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
@moomoo7946 Жыл бұрын
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
@encodian Жыл бұрын
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/
@raslaankhan51462 жыл бұрын
Nice work. Interesting!!!
@robergj2 жыл бұрын
Hi! using this action is it possible to set a transparent background for the QR code? Thanks
@encodian5 ай бұрын
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.
@stuartharrod40072 жыл бұрын
Great approach. Very useful!
@alomarvelazquez2 жыл бұрын
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!
@encodian2 жыл бұрын
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
@saikiran48202 жыл бұрын
Hi , can you please elaborate the expression which is used in "Get Attachment Content " action
@encodian Жыл бұрын
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/