xarzu
New Member
- Joined
- Apr 1, 2013
- Messages
- 13
I am attempting a Power Automate tutorial that is intended to read a CSV file into a SharePoint List. The way it is being done is to create a new Power Automate flow and pick the "Instant cloud flow" option and choose to
use the "Manually trigger a flow" as the type. We set up the first step of the flow to request the input data in the form of a CSV file from the user.
Then we add a step. This step is a Compose Data Operation which uses the base64ToString expression. The input to the base64ToString() expression, we add the Dynamic Content and I picked "Upload CSV".
I should mention at this point that my UI is a little different from the UI of the tutorial. I believe we are using different versions of Power Automate. The instructor had a button "Upload CSV" but I had to select this option from a list.
This screen shot shows the code that the generated when the instructor clicked on "Upload CSV".
Notice that the generated string contains what seems to be a part: ['contains(collection, value)'] but it is not sure since we only see a small part of this display.
My experience is different, it lacks this "contains" part:
I mention all this because it might have something to do with the error I get. When I try to test my flow, the error I get says:
The webpage segment mentioned in the error message ( Reference guide for expression functions - Azure Logic Apps ) has an example where the base64-encoded string, "aGVsbG8=" is converted to the string "hello". This might be my problem. I am not sure if this csv file is base64. So, how to I check this and how to I ensure it is converted? Also, what should I make of the missing part of the command I have mentioned?
use the "Manually trigger a flow" as the type. We set up the first step of the flow to request the input data in the form of a CSV file from the user.
Then we add a step. This step is a Compose Data Operation which uses the base64ToString expression. The input to the base64ToString() expression, we add the Dynamic Content and I picked "Upload CSV".
I should mention at this point that my UI is a little different from the UI of the tutorial. I believe we are using different versions of Power Automate. The instructor had a button "Upload CSV" but I had to select this option from a list.
This screen shot shows the code that the generated when the instructor clicked on "Upload CSV".
Notice that the generated string contains what seems to be a part: ['contains(collection, value)'] but it is not sure since we only see a small part of this display.
My experience is different, it lacks this "contains" part:
I mention all this because it might have something to do with the error I get. When I try to test my flow, the error I get says:
The webpage segment mentioned in the error message ( Reference guide for expression functions - Azure Logic Apps ) has an example where the base64-encoded string, "aGVsbG8=" is converted to the string "hello". This might be my problem. I am not sure if this csv file is base64. So, how to I check this and how to I ensure it is converted? Also, what should I make of the missing part of the command I have mentioned?
Last edited by a moderator:
