Add & Update Excel Data to SharePoint List with Date Field using Power Automate

This video is about how you can add and update your SharePoint List from Excel Table data using Power Automate. this video will cover Date and number field as well . Power automate will fetch all the excel table rows and then check weather that row already there in the List or not based on UserID field. watch full video to learn in detail.

Expression - addDays('1899-12-30',int(DATE TO CONVERT),'yyyy-MM-dd')

#powerautomate #exceltolist #updateexcel

[georgebringloe]

genius, and in 16 mins, legend, very helpful!!

[claven]

Thank you so much for this tutorial and the one about updating a sharepoint list using power automate so you don't have to copy cell by cell. Total lifesaver

[no.more.official]

Great, Thank you so much...., i was stuck here for the date!!!

[ismailismaili]

Thank you so much for explain it deeply I used to have an issue in my flow every time I make the same flow and it never worked until you showed the date function trick

[diegosousa]

Thanks... You helped me a lot!!! Regards from Brazil

[snehagarwalz]

Great help, your videos are very useful. If u can also share tutorial as to how to send emailer to employees post new item is updated in this process and another email post 30 days from joining date, it ll be very helpful

[cogwheelLearning]

Microsoft really knows how to integrate its tools into a beautiful ecosystem

[annatlima]

Thank you for your help!
I need a similar flow to include or update more than 20, 000 items, you mentioned at the end of the video, that you would do a next video to show how we can do this, do you have any plans to release? 😀

[reyganado]

doesn't work for me. only works if I already have the ID in sharepointlist. But if my list is blank, it doesn't transfer the data from excel to sharepointlist

[AmichaiLevi]

Thanks, that's so helpful!!
I have only one problem: the date field in Excel is not mandatory, and when it's empty, it causes an error. How to avoid this error?
I've tried to apply the condition, but not sure how and when I should write the condition.. could you help with this, please?

[weslyflores]

Great video! But, if a column blank, the flow doesn't create the record in SharePoint list? How to solve that? Thanks!

[pratapgp]

i am trying to do the same but the automate is able to check only for the first row in the excel file...i have 4 items in my excel and i see only first one being executed and the rest is not recognised and i have to do it via mannually.

[sininv]

Hi Lernen Tech, how about delete from excel row and auto update into the list? Can you kindly advise. Thanks.

[sudosaurus]

Hey, thank you so much for posting this! Solved me a massive headache!! :D

[HeyJack]

Is there a way to create a flow that would check if any document in a document library is modified, then add/update item to SharePoint list based on that?

I plan to have 14 similarly named documents (with different last name appended at end), and would like to update a SharePoint list any time one of those documents is modified.

[tusharmehtadxb]

Nice, any suggestions for blank date errors.

[perrettaaa]

In addition to adding and modifying excel data, there are instances where I have rows . Could you add a step to this video to show how to delete a sharepoint row that no longer exists in the excel file? Thanks in advance

[haley]

Hi there, I really need to use this solution, but in my test in the Condition section > If Yes and If no > Apply to each. When using value from Get Items it doesn't load any data to my sheet, and if I use the value from List Rows Present in Table it prints duplicates. Any suggestions as to what I may be doing wrong? for the Get Items I am using the title column as my ID is this causing the issue?

[aaalda]

Hi, can you tell me if this formula works with datetime format? or which one will can use to flow works?

[TheReneporto]

Hi, thanks for the video. I'm having a specific problem could you help me please? When running the flow in the conditional section of creating new items in shaire point a problem occurs. the flow says it completed successfully, however the data is not transferred to the shairepoint list. there are no error messages however, does not work to transfer new data to the list.