Answered

Problem with running Word as a variable

(0) Share

Report

Posted on by AlexPower

Hi everyone,
I'm having trouble indicating the variable that is the path to the Word file to be opened. I've tried various ways, but I'm making a mistake somewhere.

The first element of the flow is the custom form. It selects which subflow to run. Here, everything works correctly.
The corresponding selection starts the subflow, which starts by selecting the World file to be analysed. This is where the problem arises. An error appears that the file was not found.

I tried the change in Run word program:

%CustomFormDataW['Wordinput']%
%CustomFormDataW.Wordinput%
%CustomFormDataW['Wordinput'].data%

I've run out of ideas ;/

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@AlexPower
I understand. It seems that Power Fx was enabled(Its preview feature) when you created your flows. To resolve this issue, please disable it and recreate your flow from scratch and follow the same syntax as mentioned above. it will work now.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
AlexPower 37 on at

Like
a
(0)

Report
Copy link

Link copied!

@Deenuji Very quickly response 😉
Thank you, this could be a good option, but not in this case.
I use Power Fx in other sections of my flow. I cannot give it up

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@AlexPower

I would not recommend to use power fx enabled flow for any live projects as it has so many limitations and current supporting datatype not much clear on MS document. Please refer below:

https://learn.microsoft.com/en-us/power-automate/desktop-flows/power-fx#known-issues-and-limitations

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Verified answer

kinuasa 801 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
@AlexPower wrote:

I use Power Fx in other sections of my flow. I cannot give it up

Please try it:

=CustomFormDataW.Wordinput

Was this reply helpful? Yes No
AlexPower 37 on at

Like
a
(2)

Report
Copy link

Link copied!

@kinuasa
It worked!
The file has been opened and can be further processed, e.g. by reading data from the Word.
Thank you for help @kinuasa , thank you @Deenuji .

I have another idea for getting around this error. Automatically convert docx documents to PDF and then read the data. But this is not needed at the moment.

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@AlexPower

Btw, I have another work around as well. Transform the custom object into JSON, then utilize a scripting language such as PowerShell or .NET to extract the necessary key values. And at the end of the day, I appreciate your unwavering attitude never to give up.

@kinuasa - You're consistently impressive! I'm not sure how I overlooked testing this syntax, but it's been a good learning experience for me as well.

Was this reply helpful? Yes No