I have followed this tutorial to the letter but it is not creating new items. Only updating the matched one. Is it possible anything has changed since this was uploaded which would stop this from working? Thank you.
I used this video to create a SP list which is syncing with an Excel table with 0 Flow experience. Well, maybe not zero, but anyway, very very little, as couldn't understand all the words and had to learn the hard way, by googleing and looking at other sources as well. But in the end, it's simple and does the job. Now I need to start doing something with that list. Thank you for this!
This is great video . just a humble suggestion to improve this further , Kindly talk little more about get Items columns vs list rows present in table columns . A beginner can easily mix up and not get desired results
I really appreciate you tutorials on this channel. I have found several solutions that work that I have not found elsewhere. I do have a question regarding this flow. I'm using the current version of O 365 and I followed your instructions to the letter. The only difference is that my source is sharepoint not onedirce. However, have a few issues: 1 - When I run the flow all of the entries repeat themselves and have to force to flow to stop after several minutes. 2- I'm unable to create the filter query as there is not a "Title" field in my selections. 3 - The condition results are always true even when I perpusfully duplicate entries to test the update. I look forward to you feedback.
Great video, I"m just diving into Power automate for work. trying to cut down the number of clicks, copy/paste, and de-duplicate functions on a daily tracker.
This is an easy to follow video. I'm just curious if this is going to work with SharePoint even though it's not a List. I guess I'll have to try but if it doesn't work, we'll see if we can transition to the new Microsoft Lists instead. Thank you!
Great Stuff! I see a few comments below regarding the deletion of an item from the SP list if it is removed from Excel. Have you yet, or will you soon post a video on how to remove items from the SP list that have been removed from excel? or even mark those items as "Removed?" - Thanks!
This is exactly what I looked for today for almost 4 hours... and I copied how you did it step by step and worked! My only initial mistake was I grabbed the SP data for each row instead of the table data, but easy fix for a lot of columns :) Thanks for taking the time to do this for us! Do you have one where no matter the file name you can update the same master file? Example - 9 managers post a file into the same folder but all named differently but each has the same content and columns? I am doing a workaround and just copying the logic 9 times and changing the file name in each but pointing to the same list in SP. (SharePoint).
Hi @Lerne Tech, can you also add in the delete from excel and auto delete in SP list? and also the Date column if it's a DATETIME how to pick up in flow. Thank you.
Great vid! Does the raw data have to be stored on OneDrive for SharePoint to know if new data exist on it and will reflect those on the SharePoint list? Thanks!
This video is exactly what ive been looking for!! followed step by step but unfortunately my run failed but as not a whiz with technology i am unsure how to rectify it! this video is create but is pretty fast. any help would be massively appreciated!
Thanks for a great well explained video. I have a perfect application for this, unfortunately, the Update Item step doesn't work. I configure it to update a list column with an Excel value. But when I run it (successfully) no update occurs and when I edit the Update Item step, the Excel value has been changed to a Sharepoint value. Any idea why? Thanks.
Hello! great video, helped me a lot. Just one question, apply what you put, but when creating a new one with data in my table, it doesn't update me, but it doesn't show an error either... the flow runs without problems... I made sure that all the fields passed as text. ..and the list that you create in sharepoint use the "create list from an Excel" option, then I try to update the data and it works, but when creating a new row it doesn't.
Hi, Thanks for creating this video. I just want to know is it possible to only import few columns and not all from excel to SP and if yes can you please guide me to a helpful video of yours.
Thank You! Work very good. I have a question. How can I make the list refresh as a donation on the home page? Currently, it is only released in the LISTS tab. And if the list is added as an element on the main page, it only refreshes if I refresh the browser.
This was really useful. I'm running into one problem though: When I run the workflow, if there are ten lines to be added to the SP List, the workflow produces 100 lines (each line 10 times) even though I have the Top Count set to 1 in the Get Items step. What would cause this?
I had the same issue and realized that I need to have an extra column on my excel file specific for ID. In my case, I used student numbers and the repetitive lines stopped. Make sure the ID field is not blank. I had N/A on some of the students' # and it was repeating the same name every time the flow run. Hope this helps.
Hi, thanks for sharing. I have a daily schedule download excel file where it automatically saved to sharepoint folder. I would like to add a unique column in this excel file, rename and save it and connect it to another excel file every time a new file added to the folder. How to automate this flow in Power Automate? appreciate your help.
I tried this however this flow is only adding new row and not updating . I added a row in sharepoint and then modified a column however in excel it is adding new row for modified also instead of just updating the record. also, what needs to be done for deletion of record as if I delete a record from list it should also delete it from excel .
This is EXACTLY what I needed for an issue we were trying to solve. My only problem is I have 285 rows in my Excel table, but the flow stops at 256. Any ideas why that happens?
this is perfect to add date from excel to the sharepoint list....how do i set this flow up to delete are row from the list when i delete it in excel......like update delete?? thanks!!!!
Fantastic guide, thank you. Just what I was after :). Is there a limit to how many rows you can have in the excel table? I have 50k but when I run the flow it only does 256 items. Thanks.
@Anderson Nobre click to three dots to open the menu of "list rows present in a table". Select settings. Turn on paging (the first option). Enter the row count you want to fetch. Save.
I also suggest that you update the Pagination to 5000 in the Settings. By default only 256 rows will be retrieved from Excel. Thus updating this will help you when your data grows bigger.
Hi there, great video! I have a question: When I get to If yes, Update item, I'm only getting the Title Column to fill in (My other columns aren't showing up). Any ideas on what's going on? Thanks!
Hi, is it possible to create a Flow that whenever a new row or record is created or added into an excel file the Flow automatically creates a new item in SharePoint? Thanks
Nice video. I have a trouble creating item in SharePoint list from a list rows present in a table which is filtered from another list rows present in a table's column. Do you have any suggestion?
Thanks. If I add new rows in Excel e.g. Employee 6 and Employee 7, will it add them to the Sharepoint list? Also, if I delete an Employee in Excel, will it delete the employee in SharePoint? I can see this working with a condition checking a column called "Employment Status" whether the employee is "Active" or "Inactive". Would love a tutorial on this.
Can you pls help..I want to use MS form for filling the data, then needs to get approval using power automate..once approved it should save the data in Excel with approver name and also his comments..thanks
Hello, can you create a video on how to Delete Items on Excel File when Items on the SharePoint list gets deleted? Do this without using the "When Items get Deleted" trigger and use a recurrence action?
Good video, but a little complex to follow, specially because the options are not exactly the same, I had to replay the video like a million times to get this done.
Thanks for the video. Really helpful. For some reason when I use an employee number in my filter query it doesn't find it. I'm not sure what I am doing wrong? any help? This is the error it gives me: The expression "Employee Nr eq '1002'" is not valid. Creating query failed. clientRequestId: 6feb3f87-f395-417e-aed8-d9664abcce11 serviceRequestId: 6feb3f87-f395-417e-aed8-d9664abcce11 I'm trying to search our employee data in excel to see if there were any changes made and to update those changes in the employee data base list
Hi thank you so much for making this tutorial! I am successfully uploading entries from my excel table to my SharePoint list and updating entries. However, I am getting duplicate entries in my Sharepoint list. Do you have any suggestions on where I went wrong and how to fix this?
Hi, thank you for your tutorial. I saved my file in sharepoint and named table as you said, but when I created flow with "List rows present in a Table" and linked the EXCEL file it cannot find the table. Could you please help ? What could be the reason?
It works thanks! only have one problem if I include a Date format cell I get OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/PublishingDate' is required to be of type 'String/date-time'. The runtime value '"43938"' to be converted doesn't have the expected format 'String/date-time'. Any Idea
For further queries do Whatsapp message on --> +91 9557196693 or mail us to lernentech@gmail.com or drop a message to our Facebook page - facebook.com/Lernentech/
Hi can you help on capturing data in Excel once excel file is created in SharePoint with column name as file name, date and month and finally the name created.
Awesome it works perfectly!!!!! but it only lets me import/ update 256 registries :( and my Excel has more than 1500 rows. Any recomendations from your expirience??
Great tutorial but i'm getting some weird behavior. My list isnt pulling through all of the entries. When i look at the entries that havent bene added in flow it reports ActionBranchingConditionNotSatisfied. The execution of template action 'Create_item' skipped: the branching condition for this action is not satisfied. Any ideas?
Thanks for this video. My flow runs successfully the 1st time, but from 2nd run, it updates SP list with data of last row Excel data onto all items in SP list. So my Excel list has 6 rows, and after 2nd run SP list has 6 identical lines. What am I doing wrong?
it's been 2year now, nut i am gona create new video on this topic very soon, so stay tuned to channel. i will address al the challanges from this video
Hi, this is very useful but is it possible to do similar power automate but not on list bun on library? I have excel file with some data (with a column file name). I'd like to add files to library and automatically build columns with information from the file using file name as a key. I the video it works for list is it possible to do it for library?
Hi, Is there anyway to make the table name static as I am getting error, no Table was found with the table name 'Table1' and GUID is keep getting updated.
@@LernenTech well I have tried it but looks to me excel connector does not hold it up and throwing error. Is it possible you can share the offline excel table method that will be wonderful. I am struggling with this from month now. Thanks
if there is multiple tables how we can fetch the data into sharepooint list.Example there are 4 sheets in 1 excel file ecery sheets has one table in that 1 column is common so i want that 4 table into 4 sharepooint list. kindly make the video.
Thank you for the instructions! The flow works but it keeps saying that it failed. I'm not sure what I did wrong. Also is it normal for the flow to run for more than 2 minutes?
Goodday, Thank you for the guide on the flow! I tried implementing this solution but I want to import date format data from Excel to list. Somehow this does not work, resulting in an error that it cant convert it. Have you tried this with dates?
Hi @Lerne, Can you kindly advise the flow was successful run but the data did not show in SP list? I removed the Top Count and have it empty as I need to update all the item in Excel to SP. Created show green tick and update has show expression false didn't go .. where did I do wrong? Pls help? Thanks.
How do I get a date to go in? I have fields for when a customer was contacted and need a date, but I keep getting an error on my flow when it tries to write that. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_1' is required to be of type 'String/date-time'. The runtime value '""' to be converted doesn't have the expected format 'String/date-time'.
What if I put this on a day timer and changes test 1 to test 16, will it change the whole row? I want it to be exact like my excel file, even if an item is removed from the excel file, I want them to be removed from the SharePoint too
@@LernenTech What I want is this: Maybe delete everything inside first, then paste the whole excel file back in, however, this is around 6000 rows so I do not know if it is possible. It is also possible to check if the first column matches the excel ones, if they dont the row can be deleted. I could only find 1 video on how to do this but he didn't explain how he did it sadly.
would this method work, if I just wanted to update a small number of items from a sharepoint list? example: i have a list of 100 items, but only about 10 need to be updated. So the excel data has only 10 lines. Will the filter query work to just select the 10 items from the sharepoint list that i want to update, and leave the other 90 alone?
i followed the same steps, but am facing an error as InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '25823': 'The template function 'lengthoutputs' is not defined or not valid.'. could you pl help to resolve
I have followed this tutorial to the letter but it is not creating new items. Only updating the matched one. Is it possible anything has changed since this was uploaded which would stop this from working? Thank you.
This is what I’ve been searching for 🔥 thanks man!!! Please don’t stop posting your knowledge
Thank you so much, you have explained it so well that I succeeded in first attempt.
I used this video to create a SP list which is syncing with an Excel table with 0 Flow experience. Well, maybe not zero, but anyway, very very little, as couldn't understand all the words and had to learn the hard way, by googleing and looking at other sources as well. But in the end, it's simple and does the job. Now I need to start doing something with that list. Thank you for this!
For further queries do WhatsApp message on --> +91 9557196693 or mail us to
Just a Quick question, and if the Excel file excluded a row, how can this exclusion be reflected on SP? Great work many thanks
This is great video . just a humble suggestion to improve this further , Kindly talk little more about get Items columns vs list rows present in table columns . A beginner can easily mix up and not get desired results
Ok, Sure.
I really appreciate you tutorials on this channel. I have found several solutions that work that I have not found elsewhere. I do have a question regarding this flow. I'm using the current version of O 365 and I followed your instructions to the letter. The only difference is that my source is sharepoint not onedirce. However, have a few issues: 1 - When I run the flow all of the entries repeat themselves and have to force to flow to stop after several minutes. 2- I'm unable to create the filter query as there is not a "Title" field in my selections. 3 - The condition results are always true even when I perpusfully duplicate entries to test the update. I look forward to you feedback.
Did you ever solve this issue? I'm getting the same error with repeat rows.
I will create same video with updated MS option and keeping your issues in mind as well…sorry for late reply
@@LernenTech thank you so much for your time and help - this flow will save me so much time and effort! PS - I am not tech savvy at all lol
Great video, I"m just diving into Power automate for work. trying to cut down the number of clicks, copy/paste, and de-duplicate functions on a daily tracker.
This is an easy to follow video. I'm just curious if this is going to work with SharePoint even though it's not a List. I guess I'll have to try but if it doesn't work, we'll see if we can transition to the new Microsoft Lists instead. Thank you!
Thanks, great video. I followed steps in video and it worked on first try. Gracias.
Great to hear!
Great Stuff! I see a few comments below regarding the deletion of an item from the SP list if it is removed from Excel. Have you yet, or will you soon post a video on how to remove items from the SP list that have been removed from excel? or even mark those items as "Removed?" - Thanks!
Not yet!, will post soon.
@@LernenTech that would be great!
@@LernenTech ok where is the video tutorial
This is exactly what I looked for today for almost 4 hours... and I copied how you did it step by step and worked! My only initial mistake was I grabbed the SP data for each row instead of the table data, but easy fix for a lot of columns :)
Thanks for taking the time to do this for us!
Do you have one where no matter the file name you can update the same master file? Example - 9 managers post a file into the same folder but all named differently but each has the same content and columns?
I am doing a workaround and just copying the logic 9 times and changing the file name in each but pointing to the same list in SP. (SharePoint).
Thanks for writing, please message on our facebook page.
it is not at all working
Thanks for the guide! Does the Excel data have to be formatted as a table in Excel or can it just be rows/columns of data without it being a table?
Yes as table.
Hi @Lerne Tech, can you also add in the delete from excel and auto delete in SP list? and also the Date column if it's a DATETIME how to pick up in flow. Thank you.
My exact problem, both of them. Have you solved this?
Thanks for this wonderful tutorial. It worked, but I had to change get item top count so its working.. I made the top count as 5000
Great vid! Does the raw data have to be stored on OneDrive for SharePoint to know if new data exist on it and will reflect those on the SharePoint list? Thanks!
Great work, Prakash. Keep it going. Nice
Thank you! Been searching for this for days! Short and precise. :)
This video is exactly what ive been looking for!! followed step by step but unfortunately my run failed but as not a whiz with technology i am unsure how to rectify it! this video is create but is pretty fast. any help would be massively appreciated!
plese drop an email
Thanks for a great well explained video. I have a perfect application for this, unfortunately, the Update Item step doesn't work. I configure it to update a list column with an Excel value. But when I run it (successfully) no update occurs and when I edit the Update Item step, the Excel value has been changed to a Sharepoint value. Any idea why? Thanks.
Hello! great video, helped me a lot.
Just one question, apply what you put, but when creating a new one with data in my table, it doesn't update me, but it doesn't show an error either... the flow runs without problems... I made sure that all the fields passed as text. ..and the list that you create in sharepoint use the "create list from an Excel" option, then I try to update the data and it works, but when creating a new row it doesn't.
On the "List rows present in table" excel step click the 3 dots, choose settings and enable pagination.
Hi, Thanks for creating this video. I just want to know is it possible to only import few columns and not all from excel to SP and if yes can you please guide me to a helpful video of yours.
yes you can! For further queries do WhatsApp on --> +91 9557196693
Thank You!
Work very good.
I have a question. How can I make the list refresh as a donation on the home page? Currently, it is only released in the LISTS tab. And if the list is added as an element on the main page, it only refreshes if I refresh the browser.
This was really useful. I'm running into one problem though: When I run the workflow, if there are ten lines to be added to the SP List, the workflow produces 100 lines (each line 10 times) even though I have the Top Count set to 1 in the Get Items step. What would cause this?
I had the same issue and realized that I need to have an extra column on my excel file specific for ID. In my case, I used student numbers and the repetitive lines stopped. Make sure the ID field is not blank. I had N/A on some of the students' # and it was repeating the same name every time the flow run. Hope this helps.
HI! Nathan, I also got the same problem as yours, Have you take any solution? Can you share to me ? Thanks !
Awesome video. Works well. except add new item. In my case , it is updating but not appending new data .
it will
Hi, thanks for sharing. I have a daily schedule download excel file where it automatically saved to sharepoint folder. I would like to add a unique column in this excel file, rename and save it and connect it to another excel file every time a new file added to the folder. How to automate this flow in Power Automate? appreciate your help.
Old but gold!!! Thanks a million.
I tried this however this flow is only adding new row and not updating . I added a row in sharepoint and then modified a column however in excel it is adding new row for modified also instead of just updating the record. also, what needs to be done for deletion of record as if I delete a record from list it should also delete it from excel .
This is EXACTLY what I needed for an issue we were trying to solve. My only problem is I have 285 rows in my Excel table, but the flow stops at 256. Any ideas why that happens?
change the pagination setting you will be good.
@@LernenTech Sorry where can i change this? Because my sp list its open, but its the flow that it stops
this is perfect to add date from excel to the sharepoint list....how do i set this flow up to delete are row from the list when i delete it in excel......like update delete?? thanks!!!!
Thanks 😊 do you give any courses on Power Automate?
Not yet
Fantastic guide, thank you. Just what I was after :). Is there a limit to how many rows you can have in the excel table? I have 50k but when I run the flow it only does 256 items. Thanks.
change flow setting
@@LernenTech I get the same issue, IF I set the top limit to 21000 . It still only does 256 lines.
@Anderson Nobre click to three dots to open the menu of "list rows present in a table". Select settings. Turn on paging (the first option). Enter the row count you want to fetch. Save.
@@fyukselthis method get the maximum 5000 row from excel, but thank you for advances
Do you perhaps have an example where a Document Library metadata is updated from an Excel file?
When I add the "length" formula I get a different formula (length(outputs('Get_items')?['body/value'])) resulting in an error. Any idea?
Hi, how did you resolve it?
Someone resolved this error?
always short and to the point with great examples !
Glad it was helpful!
I also suggest that you update the Pagination to 5000 in the Settings. By default only 256 rows will be retrieved from Excel. Thus updating this will help you when your data grows bigger.
how do you update the pagination to 5000?
Hi there, great video! I have a question: When I get to If yes, Update item, I'm only getting the Title Column to fill in (My other columns aren't showing up). Any ideas on what's going on? Thanks!
Hi,
is it possible to create a Flow that whenever a new row or record is created or added into an excel file
the Flow automatically creates a new item in SharePoint?
Thanks
well i am not sure about that. i will have to see that as there is no as such trigger option we have as of now i guess.
Thank you so much for your video. It works great for me. Can I run the flow if I have only Edit permission?
Yes
@@LernenTech Awesome! Thank you so much!
Thank you for putting together this video...very helpful
Glad it was helpful!
Nice video.
I have a trouble creating item in SharePoint list from a list rows present in a table which is filtered from another list rows present in a table's column. Do you have any suggestion?
Great video, thanks for sharing!
I would be grateful if you could let us know how to delete items from the list which are no longer in the excel table
For further queries do WhatsApp message on --> +91 9557196693 or mail us to
Man, you rock.
Thanks a lot for this explanation, amazing
Hi Lernen, are you able to teach how to delete too? Thanks
Thanks for the useful guide its really helped.
how to i edit this flow if i want it to check for updates throughout each cell in the excell sheet and to overwrite old data and update new???
Are there any changes required if the excel file from which data must be taken is hosted by Sharepoint rather than OneDrive?
Hi how would you delete rows that have been removed from the original excel but still exist in SharePoint?
Hi, thank you for valuable video.
Can we add ms form excel attachement data on another excel file which stored in SharePoint.
not sure what you are looking for?
Thanks. If I add new rows in Excel e.g. Employee 6 and Employee 7, will it add them to the Sharepoint list? Also, if I delete an Employee in Excel, will it delete the employee in SharePoint? I can see this working with a condition checking a column called "Employment Status" whether the employee is "Active" or "Inactive". Would love a tutorial on this.
Sure will try.
Great video! Thank you. What we have attachments, how would that work?
in Excel?
Can you pls help..I want to use MS form for filling the data, then needs to get approval using power automate..once approved it should save the data in Excel with approver name and also his comments..thanks
I've followed every step but the list will not update. Any idea or common mistakes ?
This is Awesome! Thank you for making this tutorial.
Glad it was helpful!
Hello, can you create a video on how to Delete Items on Excel File when Items on the SharePoint list gets deleted? Do this without using the "When Items get Deleted" trigger and use a recurrence action?
Does this also work with document libraries?
will it work if my excel has more than 5000 rows? Even if I change settings of my "List rows present in Table", the max I can go for is 5000.
Can you update from an Excel wich contain more than 1 table?
Good video, but a little complex to follow, specially because the options are not exactly the same, I had to replay the video like a million times to get this done.
How to delete all rows in table or how to replace the old data with new data
Thanks for the video. Really helpful. For some reason when I use an employee number in my filter query it doesn't find it. I'm not sure what I am doing wrong? any help? This is the error it gives me:
The expression "Employee Nr eq '1002'" is not valid. Creating query failed.
clientRequestId: 6feb3f87-f395-417e-aed8-d9664abcce11
serviceRequestId: 6feb3f87-f395-417e-aed8-d9664abcce11
I'm trying to search our employee data in excel to see if there were any changes made and to update those changes in the employee data base list
can you update from an excel with more than 1 sheet?
It seems it's not possible between Excel and SharePoint 2016 update, via Power Automate. Any help would be appreciated.
Hi thank you so much for making this tutorial! I am successfully uploading entries from my excel table to my SharePoint list and updating entries. However, I am getting duplicate entries in my Sharepoint list. Do you have any suggestions on where I went wrong and how to fix this?
Do a WhatsApp message on - +91 9557196693.
@@LernenTech I have the same problem on duplicates, what is the solution please?
Thank you so much for the tutorial. It made my life easier.
Hi, I think there's a limitation. I am copying 50,000 records but it only copied 256 records.. Any thoughts? Thanks.
It looks like my issue is about the "Flow Run Time" wherein the maximum flow frequency of my flow license is 5 minutes. Is this upgradable?
Glad it helped!
enable pagination and change the limit
will create a video on that soon
Sir.if the Excel Title Is edited Means it will not update instead in will create new item in the list ... will you reply please this
Good video, helped. Is there one for deleting duplicate items in a SP List?
Not yet
@@LernenTech Is there one now?
Thanks for this great Class!!!
This is what I am looking for! 🙏 thx
Hi, thank you for your tutorial. I saved my file in sharepoint and named table as you said, but when I created flow with "List rows present in a Table" and linked the EXCEL file it cannot find the table. Could you please help ? What could be the reason?
For further questions and queries mail us to lernentech@gmail.com or drop a message to our Facebook page - facebook.com/Lernentech/
Pls let me know what is best approach for adding data to list without third party tool
It works thanks! only have one problem if I include a Date format cell I get OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/PublishingDate' is required to be of type 'String/date-time'. The runtime value '"43938"' to be converted doesn't have the expected format 'String/date-time'.
Any Idea
For further queries do Whatsapp message on --> +91 9557196693 or mail us to lernentech@gmail.com or drop a message to our Facebook page - facebook.com/Lernentech/
I really appreciate your help.
@William Lee - did you ever get an answer? I am having the same issue :( Thank you!
Hello is there any way to add new column in excel and the same to sharepoint using the same flow you have created.
not sure
Hi can you help on capturing data in Excel once excel file is created in SharePoint with column name as file name, date and month and finally the name created.
Awesome it works perfectly!!!!! but it only lets me import/ update 256 registries :( and my Excel has more than 1500 rows. Any recomendations from your expirience??
check out my other video
try this. hit the "..." next to list rows in table and settings then change threshold to whatever
Awesome! How do I do this if my Excel file is in SharePoint library, instead of OneDrive?
I have a similar question. :) I wonder if it should just be on OneDrive for the file and the list to communicate properly.
In the "List rows present in a table" step (step 2) you can specify the location as your sharepoint site
Wonderful Stuff! Thank you for sharing your knowledge!
My pleasure!
Great tutorial but i'm getting some weird behavior. My list isnt pulling through all of the entries. When i look at the entries that havent bene added in flow it reports ActionBranchingConditionNotSatisfied. The execution of template action 'Create_item' skipped: the branching condition for this action is not satisfied. Any ideas?
Many Many thanks for this video :)😇
How can I resolve the issue, that when my list contains multiple items with the same title the loop mixes the items up?
Thanks for this video. My flow runs successfully the 1st time, but from 2nd run, it updates SP list with data of last row Excel data onto all items in SP list. So my Excel list has 6 rows, and after 2nd run SP list has 6 identical lines. What am I doing wrong?
it's been 2year now, nut i am gona create new video on this topic very soon, so stay tuned to channel. i will address al the challanges from this video
@@LernenTech Please I don't know why duplicates everytime I run the flow.
Hi, this is very useful but is it possible to do similar power automate but not on list bun on library?
I have excel file with some data (with a column file name). I'd like to add files to library and automatically build columns with information from the file using file name as a key. I the video it works for list is it possible to do it for library?
Any ideas for documents library?
For further questions and queries mail us to lernentech@gmail.com or drop a message to our Facebook page - facebook.com/Lernentech/
Hi, Is there anyway to make the table name static as I am getting error, no Table was found with the table name 'Table1' and GUID is keep getting updated.
Create a table name excel offline and upload
@@LernenTech well I have tried it but looks to me excel connector does not hold it up and throwing error. Is it possible you can share the offline excel table method that will be wonderful. I am struggling with this from month now. Thanks
if there is multiple tables how we can fetch the data into sharepooint list.Example there are 4 sheets in 1 excel file ecery sheets has one table in that 1 column is common so i want that 4 table into 4
sharepooint list.
kindly make the video.
Thank you for the instructions! The flow works but it keeps saying that it failed. I'm not sure what I did wrong. Also is it normal for the flow to run for more than 2 minutes?
Goodday, Thank you for the guide on the flow! I tried implementing this solution but I want to import date format data from Excel to list. Somehow this does not work, resulting in an error that it cant convert it. Have you tried this with dates?
Video is coming in next 1 or 2 days.
@@LernenTech Thank you! I will be on watch for it!
@@LernenTech Have you posted the video yet? Struggling to convert dates!
Hi @Lerne, Can you kindly advise the flow was successful run but the data did not show in SP list? I removed the Top Count and have it empty as I need to update all the item in Excel to SP. Created show green tick and update has show expression false didn't go .. where did I do wrong? Pls help? Thanks.
please connect over whatsapp.+91 9557196693
@@LernenTech I don 't hv int data. anyother way to contact? Also how about delete from excel to update into SP too. thx
Thanks for this great video.
What if I want to create items into my List and filters out rows from excel that have empty values for a specific column?
So it only creates list items if the excel data has a title and a value in the specific column
Could you please tell me, how will flow work for .xlsm file
muy bueno!! explicas muy bien
How do I get a date to go in? I have fields for when a customer was contacted and need a date, but I keep getting an error on my flow when it tries to write that.
The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_1' is required to be of type 'String/date-time'. The runtime value '""' to be converted doesn't have the expected format 'String/date-time'.
Please check my latest video on dates part
What if I put this on a day timer and changes test 1 to test 16, will it change the whole row? I want it to be exact like my excel file, even if an item is removed from the excel file, I want them to be removed from the SharePoint too
you will have to create delete action for that.
@@LernenTech What I want is this:
Maybe delete everything inside first, then paste the whole excel file back in, however, this is around 6000 rows so I do not know if it is possible. It is also possible to check if the first column matches the excel ones, if they dont the row can be deleted. I could only find 1 video on how to do this but he didn't explain how he did it sadly.
Thank you so much. This works perfectly for me!
Glad it helped!
would this method work, if I just wanted to update a small number of items from a sharepoint list? example: i have a list of 100 items, but only about 10 need to be updated. So the excel data has only 10 lines. Will the filter query work to just select the 10 items from the sharepoint list that i want to update, and leave the other 90 alone?
It should
i followed the same steps, but am facing an error as InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '25823': 'The template function 'lengthoutputs' is not defined or not valid.'.
could you pl help to resolve
I keep getting a flow time Run error. It's running for 20 min or 30 min. Do you know what the issue may be?
I have tried but in excel when we update in Shear Point , flow create another line item in excel
not update existing one !
What to do ?
If you excel tab add couple new records of 'Test 6, 'Test 7' and 'Test 8'', will these new records be added to Sharepoint list?
Yes it works. But I try to add 500+ records. it only added 257. Is there any limitation of how many records can be added to the list (each run)?
updates is not there from excel sheet.