I have a model Driven form with a field where users can add a document to a record, the field name is 'Documents'. I have a flow with some approval actions. Upon approval I want to change a Word document and store it in either a SP library or One Drive.
I've got the Convert action but it fails. I thought it would be a matter of adding the field name from my record to the convert action field? I remember doing the same in SP a few months ago and having to have some other actions. I guess that after the file is converted it's a case of adding a 'Move File' action? Any guidance would be gratefully received!
What exactly is in the Documents field (property) - usually a document/file would have the properties Filename and File content (or similar) and what you want to convert is the File content.
Another important part is that your convert file action is working from OneDrive, so your document must be present on the OneDrive first.
Try adding a Compose action after our trigger and add the Document field in it - that will allow you to see what is in there.
Hope this helps you on the way 🙂
Kind regards, John
Thanks @JohnAageAnderse . Looking at my fields again I noticed that I was pointing at the wrong field! Doh!
The actual field is called 'Add documents' - cr1b0_adddocument - which is attachment field where a user uploads files to the record. I can't find that field when I search for it in Create or Convert file actions. So my question now is how to convert that file to a PDF after it's been uploaded. I guess it's stored somewhere in the CDS?
I am not using CDS, so can't help with that. Hope someone knowledgable will reply. One thing though is that I usually use a Compose action to see what a property contains when I am unsure and that may also help you in this situation.
Kind regards, John
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Fill out a quick form to claim your user group badge now!