cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: MS Word Connector

oh ok, and I don't know where to insert that code?

 

I was in this moment trying to add a "Field" in my word document that get the value from the SPL and then converts, something like this, but is not working also.

{=Table1\Matching \# "$#,##0.00;($#,##0.00)}

!Undefined Bookmark, MATCHING

 

 

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: MS Word Connector

I am testing with MS Word, what I did was to create a table in my word template. 

I added another column and in formulas I set that cell to sum(left), I get the correct value but I had to right click and "Update Field". 

Not receiving the file via flow with the field updated.

 

Capture.PNG

Highlighted
Dual Super User II
Dual Super User II

Re: MS Word Connector

Glad you found a solution for the formatting issue



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: MS Word Connector

Thank you, is not a perfect solution because I have to open the word document and update the fields but is something to start.

 

Thank again for your valuable help, you should create a tutorial about this.

 

🙂

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: MS Word Connector

Hi there, just to provide a quick infor here.

 

I was finally able to achieve this but with a minor modification, which is no the great solution but it does the work and I am happy with it.

 

What I did was to create additional columns in my Share Point List "Calculated Column" using this formula: =DOLLAR
([ColumnName],2), assign a name to easy identify with my flow i.e "Flowcolumn1", etc. then I have inserted that column into my Flow and it creates my MS word document with the Dollar $ and decimal values.

 

Thank again !

 

Capture1.PNG

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: MS Word Connector

@Pstork1 , Hi there. 

 

Sorry to bother you again, for some reason I start getting this error: BadRequest, in this step:

Convert Word Document to PDF

 

tatus
Failed
Error
Action 'Convert_Word_Document_to_PDF' failed
Error Details
There was an error accessing the file. Please try again or select a different file.
clientRequestId: 58509c17-cc8d-4f85-9799-f305c4735a
 
could you please let me know what I am doing wrong?
 
Thanks nce
 
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: MS Word Connector

Hi,

 

It seems like Ovedrive was acting weird. I have recreated the flow and is working fine now. However I would like to ask you a quick question?

 

In this particular flow I am creating a word file form a template using the data in my Share Point list and also creating a PDF of the same file and also sending an email in the PDF file. sounds complicated I know, but is working. As you can see I have added two delays: 1 Minute and 2 minutes, 1 minute before covert the word to PDF, just in case Onedrive is not responding, and two minutes after everything is fine to delete the word file created in previous steps.

 

Could this be simplified or this is the way?

 

Thanks in advance for any advice,

 

Regards.

 

Capture.PNG

 

Highlighted
Kudo Kingpin
Kudo Kingpin

Re: MS Word Connector

@Pstork1 ,

 

Good morning, I hope everything is OK!.

 

I just have a quick question and I hope you could point me in the right direction.

 

Do you know how to insert pictures into the word template using the MS word connector, flow and power apps?

 

What I am facing now is:

 

I have finally my app working fine, with a click I can produce my word template using the word connector and MS Flow. but I would like to insert a single picture or the pictures form my collection associated with an specific record splease send me a link for somebody who has this done already?

 

Thanks in advance for your help.

 

Regards.

Highlighted
Dual Super User II
Dual Super User II

Re: MS Word Connector

Sorry, I don't know how to do that. I know that normally to insert a picture into a Word document requires converting the picture to a string representation and inserting that into the document, but I have no idea how that would work here.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: MS Word Connector

Thank you very much for your prompt response.

 

I will continue searching. If I find something I will let you know.

 

Kind regards,

 

Highlighted
Dual Super User II
Dual Super User II

Re: MS Word Connector

I would suggest posting this as a new question.  Most people won't see it when you tack it on to a question that is marked as solved.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (9,005)