I am new to Power Automate Desktop and Power Automate. Could anyone help me to solve the issues.
I am extracting a data table from website using Power Automate Desktop. Table has rows and columns properly.
The extracted data is being stored in DataTable variable in the form of Data Table.
Now the thing is, I want to send this DataTable to Power Automate Cloud and use the values by particular row and column and fill that data into a SharePoint List.
I am able to extract data but I am not able to send it as a data table to cloud flow. I guess it sends the data in array or string form and I am not sure about that.
If I am using loop to send the data to cloud it is passing only last value from loop.
As you can see in the above SS loop is running but it is sending the NetRate, Unit_Type and Date at the end the loop to cloud flow, But I want it should send the variable values after each iteration to Cloud flow , then go to the next iteration.
OR If I could fill SharePoint directly from Automate Desktop that could also be beneficial
Could anyone help me over this.
Thanks in advance
Solved! Go to Solution.
As far as I understand, attachment files of SharePoint List Item are stored in SQL table, however I don't know if it is possible to retrieve those attachment files via SQL query using OLE DB.
If anyone is having trouble with the SQL method, I also developed a method to bulk import entire files worth of data into SharePoint through Power Automate Desktop & Cloud Flows.
I haven’t tested these methods side by side, but I wonder if my cloud flow is more efficient as it doesn’t use a loop for each row.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!