If you found this video helpful check out the video I uploaded today on how you can automate creating a table in Excel using the Run Script action in Power Automate! If you import data from Excel to SharePoint often-this will be a time saver! Check it out: ua-cam.com/video/GNLhPqP1cjM/v-deo.html
Thanks a lot for your sharing. I just started using simply power automate. May I ask if you can make a video how to copy data from Excel A to Excel B (data is the same as Excel A, but columns and rows are arranged in a different way from Excel A.), please?
Thank you-that was super helpful! I am trying to create the same flow, and all the columns are working except one that contains a type currency value from Excel. I also have my SharePoint list for that column as type currency. The flow runs successfully; it just leaves that column blank. Is there anything else I would need to do to pass through a type currency from Excel to SharePoint?
Your content is always helpful! Get file properties has helped me with (later in the flow) referencing a worksheet and table names. This way a flow can cycle through a workbook without having to hardcode the table or worksheet names. The one that throws me off is when a table has no data (for a filter query to apply to), or when a random worksheet has no tables (eg. worksheet 1 & 3 have tables but not 2).
Thanks for watching! I just uploaded a video that covers how to create a table using a script in Excel and running that script from within Power Automate 👉 ua-cam.com/video/GNLhPqP1cjM/v-deo.html. You might find it helpful for your scenario. Let me know if that helps or if you have any more questions! I'd be happy to try and help you troubleshoot your issue.
hi, i have spreadsheet with 3000 linies in now. i would to use this function. Will Power Automate able to handle that amount data. Btw excel sheet is growing each day
Thanks for watching! There isn't a single action that would do this. You would need to build a flow that would check your file and cross reference it against your items in SharePoint. I cover how to do that in the first section of this tutorial: ua-cam.com/video/HVAf1aTEQNg/v-deo.html
If you found this video helpful check out the video I uploaded today on how you can automate creating a table in Excel using the Run Script action in Power Automate! If you import data from Excel to SharePoint often-this will be a time saver!
Check it out: ua-cam.com/video/GNLhPqP1cjM/v-deo.html
Thanks a lot for your sharing. I just started using simply power automate. May I ask if you can make a video how to copy data from Excel A to Excel B (data is the same as Excel A, but columns and rows are arranged in a different way from Excel A.), please?
Great video. This is going to help a ton of people!
Thank you!
Thank you-that was super helpful! I am trying to create the same flow, and all the columns are working except one that contains a type currency value from Excel. I also have my SharePoint list for that column as type currency. The flow runs successfully; it just leaves that column blank. Is there anything else I would need to do to pass through a type currency from Excel to SharePoint?
Your content is always helpful! Get file properties has helped me with (later in the flow) referencing a worksheet and table names. This way a flow can cycle through a workbook without having to hardcode the table or worksheet names. The one that throws me off is when a table has no data (for a filter query to apply to), or when a random worksheet has no tables (eg. worksheet 1 & 3 have tables but not 2).
Thanks for watching! I just uploaded a video that covers how to create a table using a script in Excel and running that script from within Power Automate 👉 ua-cam.com/video/GNLhPqP1cjM/v-deo.html. You might find it helpful for your scenario.
Let me know if that helps or if you have any more questions! I'd be happy to try and help you troubleshoot your issue.
hi, i have spreadsheet with 3000 linies in now. i would to use this function. Will Power Automate able to handle that amount data. Btw excel sheet is growing each day
Great video once again. Is there a way to link the excel to the list, so it uploads new lines or amended items?
Thanks for watching! There isn't a single action that would do this. You would need to build a flow that would check your file and cross reference it against your items in SharePoint. I cover how to do that in the first section of this tutorial: ua-cam.com/video/HVAf1aTEQNg/v-deo.html
how do i update atomically if value changes in excel