84I am having difficulty with the process of referencing a CSV file in my Power Automate Flow. The errors and issues I am describing here have me concerned and I am wondering:
- if I am doing the steps correctly
- what the error messages really mean
- how I can test to see if everything is OK
I am following a YouTube tutorial that I hope will help me load data from a CSV file into a SharePoint list.
Here is what I have. The empty list on SharePoint has already been set up as a blank list with assigned column headers that I have assigned. He csv file has already been loaded with test data and exists locally.
Here is what I have done so far. In Power Automate I click a new flow and I pick the "Instant cloud flow". Then I gave the flow a name I can recognize and I clicked the option to "Manually trigger a flow". And I click the button to "Create".
For reference, the instruction I am following is https://www.youtube.com/watch?v=pmQkeFeSkiw
I added a "Get File Content" step using path as an action. The parameters for this step requested a site address and a file path. For the site address, I used the URL of my company's web site.
I figured I would add the path to my file by clicking on the folder icon, , but when I did I got a large and confusing warning/error message:
When I entered this URL in this message as the Site Address, I still got this message.
I was able to hard code the File Path to my file but somehow I think this is not good enough for this project and I do not know if this step is going to produce the desired action.
There are a couple of Compose actions after this step:
I am concerned about the variable, "Get_file_content_using_path" because I do not see where this variable is declared or assigned and yet it is used as part of the string command, "string(outputs ('Get_file_content_using-path'))"
