User Profile
A_Henriquez
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: Excel Online to Sharepoint List using PowerAutomate and including Time Values
Sandy Ussia Hi Sandy I have an existing sharepoint list and I want to be able to add in bulk, using excel. I just want to set this up to give folks a taste of working in an online environment. Something as simple as each group saving an excel file to a shared folder, that I can then move into a sharepoint list. The list can then be used for calendars, and possibly planner or project. I'm also working only with excel online and power automate online - wanting to just roughly test this out. If it works, then the next advice is we seek a consultant for a more comprehensive setup. Especially because all I have figured out so far is how to add, but not actually delete or update existing items. AND - I have actually figured this date/time issue out. I came back here to delete my post - feeling foolish, but I saw your reply. I am so grateful to these communities and others with the most helpful blog and video posts. I followed the method herehttps://normyoung.ca/2020/07/20/import-excel-data-into-an-existing-sharepoint-list-using-power-automate/and was finally successful. It took me a LONG time to figure out how to apply this in detail - but I finally got it. phew. Thank You for the help, A HenriquezExcel Online to Sharepoint List using PowerAutomate and including Time Values
I've read through a handful of posts talking about how excel and powerautomate arent the easiest to work with for date time values. I still believe I can set up this flow, and have cobbled together something of the correct formulas but still cant get to the create item successfully. I have an excel table stored in a sharepoint folder, simple event list with a start date and time column. currently formatted as date time. I'm trying to import the excel data into a sharepoint list. addseconds('1899-12-30',int(formatNumber(mul(variables('VarDate'),86400),'0','en-us')),'M/dd/yyyyh:mmtt') formatDateTime(variables('EventDate'),'g') I have no idea what I am doing. Just testing various things out. Thank you for any advice you can offer.
