I´m from germany so sorry for my bad english 🙂
I want to build a flow which gets as input a list of numbers from a csv. For each number I have defined a action in a ERP program.
The loading of the CSV works fine. Even the for each function as itself works fine.
But when I try to use the function "Filling textfield in window" with the numbers of the CSV I get the error message, that the argument "text" needs to be encrypted.
I filled it with that: %CurrentItem%
When I change the setting to "secret text" the program writes the text %CurrentItem% instead of the number I want to have.
What am I doing wrong? Do I use the wrong function?
Thank you already.
Solved! Go to Solution.
Looks like a type mismatch (text vs. numbers?) between source and target. Maybe that helps: https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Argument-Text-Must-be-Encrypted-value-pop...
@AndrePowerAutom are you trying to write entire csv row to the erp app, or a specific cell from CSV.
Is it possible for you to show the structure of your csv file and the powerautomate actions you're using?
I guess you are right. I found that information in the post you showed me:
"Thank you for your help, I found that the input type accepts only number because of that it was not able to enter the value, so I tried converting it as txt to number, then it was able to enter the value into the field."
But I dont get how to do that.
My test csv has only 1 row with the number 291148384.
Here is how is setted up.
You shouldn't need a dedicated variable if you just convert the current item to a number before it's entered into the field: https://docs.microsoft.com/de-de/power-automate/desktop-flows/actions-reference/text#tonumber
But how can I do that? When I write
it doesnt format it. it just writes the text like this:
I even setted it in the csv file as text. Is there a special syntax?
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.