Forum Discussion

A_Henriquez's avatar
A_Henriquez
Copper Contributor
May 30, 2021

Excel 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 s...
Microsoft Flow
PowerApps
sharepoint
Sandy Ussia's avatar
Sandy Ussia
MVP
May 31, 2021

Hi A_Henriquez 

 

I'm just wondering first whether there's a reason you're not able to use SharePoint's feature to create a list from an Excel sheet? I think DateTime fields should come through properly in that scenario, as long as you specify the column as DateTime during the list creation.

 

Or do you mean the list already exists with other entries in it, so you're trying to create additional items?

 

Sandy

  • A_Henriquez's avatar
    A_Henriquez
    Copper Contributor
    Jun 01, 2021

    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 here https://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 Henriquez

     

Resources