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.
@jose00033
Жыл бұрын
This is what I’ve been searching for 🔥 thanks man!!! Please don’t stop posting your knowledge
@ShoebKhan.Official
Жыл бұрын
Thank you so much, you have explained it so well that I succeeded in first attempt.
@juliovilaca2120
Жыл бұрын
Just a Quick question, and if the Excel file excluded a row, how can this exclusion be reflected on SP? Great work many thanks
@adi0rban
3 жыл бұрын
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!
@LernenTech
3 жыл бұрын
For further queries do WhatsApp message on --> +91 9557196693 or mail us to
@SrikantRZradio
2 жыл бұрын
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
@LernenTech
2 жыл бұрын
Ok, Sure.
@richg7264
2 жыл бұрын
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.
@williamlee4809
2 жыл бұрын
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.
@tonytseng7780
2 жыл бұрын
Did you ever solve this issue? I'm getting the same error with repeat rows.
@LernenTech
2 жыл бұрын
I will create same video with updated MS option and keeping your issues in mind as well…sorry for late reply
@joelleaboytez4030
2 жыл бұрын
@@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
@gamingescape5824
3 жыл бұрын
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 .
@rickbartleson5538
4 жыл бұрын
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).
@LernenTech
4 жыл бұрын
Thanks for writing, please message on our facebook page.
@narendrakumarpappu6621
Жыл бұрын
it is not at all working
@MM-cq8jz
Жыл бұрын
I've followed every step but the list will not update. Any idea or common mistakes ?
@thewanderingcouple8378
3 ай бұрын
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
@paulsauve3691
3 ай бұрын
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.
@marosa1801
3 жыл бұрын
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?
@LernenTech
3 жыл бұрын
Yes as table.
@sebastiandeipenbrock9793
Жыл бұрын
When I add the "length" formula I get a different formula (length(outputs('Get_items')?['body/value'])) resulting in an error. Any idea?
@bintenasir7
2 ай бұрын
Hi, how did you resolve it?
@dianamendoza8387
9 күн бұрын
Someone resolved this error?
@sininv1
3 жыл бұрын
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.
@0markaria0
2 жыл бұрын
My exact problem, both of them. Have you solved this?
@surangmasharma8159
4 жыл бұрын
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.
@LernenTech
4 жыл бұрын
yes you can! For further queries do WhatsApp on --> +91 9557196693
@ofejiroederhi834
2 жыл бұрын
Thanks, great video. I followed steps in video and it worked on first try. Gracias.
@LernenTech
2 жыл бұрын
Great to hear!
@catecorp3171
2 жыл бұрын
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.
@RachelSirois
2 ай бұрын
On the "List rows present in table" excel step click the 3 dots, choose settings and enable pagination.
@dcm9058
4 жыл бұрын
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
@LernenTech
4 жыл бұрын
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.
@johanvandyk6532
4 ай бұрын
Do you perhaps have an example where a Document Library metadata is updated from an Excel file?
@kuuuyajim
2 жыл бұрын
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!
@raivolution
2 жыл бұрын
Hi how would you delete rows that have been removed from the original excel but still exist in SharePoint?
@ryanedwards5390
3 жыл бұрын
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!
@LernenTech
3 жыл бұрын
Not yet!, will post soon.
@sexyberlam
3 жыл бұрын
@@LernenTech that would be great!
@joejoesto
Жыл бұрын
@@LernenTech ok where is the video tutorial
@anwarkrg9292
5 ай бұрын
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.
@piacorpuz
Жыл бұрын
Thank you! Been searching for this for days! Short and precise. :)
@isBessem
Жыл бұрын
Old but gold!!! Thanks a million.
@nathanbrown1917
3 жыл бұрын
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?
@anniekostadinova7915
2 жыл бұрын
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.
@lucayi9138
2 жыл бұрын
HI! Nathan, I also got the same problem as yours, Have you take any solution? Can you share to me ? Thanks !
@GarthShaner
3 жыл бұрын
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?
@LernenTech
3 жыл бұрын
change the pagination setting you will be good.
@ironkaicer
3 жыл бұрын
@@LernenTech Sorry where can i change this? Because my sp list its open, but its the flow that it stops
@sheryll9966
4 жыл бұрын
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!
@bryankendig3989
Жыл бұрын
Are there any changes required if the excel file from which data must be taken is hosted by Sharepoint rather than OneDrive?
@chriscoslett6459
Жыл бұрын
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!!!!
@wilfredmanahan
2 жыл бұрын
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.
@nathandounel769
2 жыл бұрын
how do you update the pagination to 5000?
@peterjournalism8526
2 жыл бұрын
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!
@seemahemant8070
2 жыл бұрын
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.
@VIKRANTSINGH1991
2 жыл бұрын
It seems it's not possible between Excel and SharePoint 2016 update, via Power Automate. Any help would be appreciated.
@shredder5849
2 жыл бұрын
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.
@rubyhutson
Жыл бұрын
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!
@LernenTech
11 ай бұрын
plese drop an email
@sarathbabu2616
2 жыл бұрын
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
@nathalievandegenachte6246
2 жыл бұрын
can you update from an excel with more than 1 sheet?
@joaofigueiredo2327
3 жыл бұрын
Hi there, Great job, i ´m trying to link (to do a 2 way sync) From Sharepoint Excel , and i m stuck, when i test it i ve a error: The Expression "Ref ETC eq OASP2004A4-KIT" is not valid. Creating query failed. , can anyone help me? the field Ref ETC is the sharepoint Key, and the OASP2004A4-KIT is the the Ref ETC in the first row in Excel. Thanks.
@joaofigueiredo2327
3 жыл бұрын
Hi, Can You help me?
@nathanface8225
2 жыл бұрын
Yes I need the same thing. Has anyone found a way to do this?
@natalijanalcakar7241
2 жыл бұрын
The video is good but my flow doesn't work because "apply to each" automatically appears in "if no" scenario. Maybe any ideas how to get rid of it? Simple dragging doesn't help unfortunately...
@nathalievandegenachte6246
2 жыл бұрын
Can you update from an Excel wich contain more than 1 table?
@ibrahimmaradey3372
2 ай бұрын
Thanks for this great Class!!!
@danyell12345
8 ай бұрын
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???
@MINNE_BEAMON
2 жыл бұрын
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.
@mat6997
Жыл бұрын
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?
@MrBabysillah
4 жыл бұрын
This is Awesome! Thank you for making this tutorial.
@LernenTech
4 жыл бұрын
Glad it was helpful!
@MrBabuji123
3 жыл бұрын
Awesome video. Works well. except add new item. In my case , it is updating but not appending new data .
@LernenTech
3 жыл бұрын
it will
@shivabkumar7999
Жыл бұрын
Great work, Prakash. Keep it going. Nice
@carloshumbertocallejalopez9105
4 жыл бұрын
If you add rows to your excel, then run the flow Will the new rows get added to the list?
@LernenTech
4 жыл бұрын
that's depend on the trigger
@arvind_ch
3 жыл бұрын
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
@ericalvo1
4 ай бұрын
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.
@MrMattsimmo
4 жыл бұрын
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.
@LernenTech
3 жыл бұрын
change flow setting
@onionman2117
3 жыл бұрын
@@LernenTech I get the same issue, IF I set the top limit to 21000 . It still only does 256 lines.
@fyuksel
2 жыл бұрын
@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.
@erlanggasatrioaa7080
11 ай бұрын
@@fyukselthis method get the maximum 5000 row from excel, but thank you for advances
@amycairo2
3 жыл бұрын
Thank you for putting together this video...very helpful
@LernenTech
3 жыл бұрын
Glad it was helpful!
@lambo4ever
3 жыл бұрын
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?
@hizke1
3 жыл бұрын
always short and to the point with great examples !
@LernenTech
3 жыл бұрын
Glad it was helpful!
@Carlog5290
4 жыл бұрын
Thank you so much for the tutorial. It made my life easier.
@Carlog5290
4 жыл бұрын
Hi, I think there's a limitation. I am copying 50,000 records but it only copied 256 records.. Any thoughts? Thanks.
@Carlog5290
4 жыл бұрын
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?
@LernenTech
4 жыл бұрын
Glad it helped!
@LernenTech
4 жыл бұрын
enable pagination and change the limit
@LernenTech
4 жыл бұрын
will create a video on that soon
@chairutsirirut5787
Жыл бұрын
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?
@memoparra851
4 жыл бұрын
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
@LernenTech
4 жыл бұрын
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/
@omsingh8765
3 жыл бұрын
Thanks for the useful guide its really helped.
@HeyJack13
Жыл бұрын
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'.
@LernenTech
Жыл бұрын
Please check my latest video on dates part
@sininv1
3 жыл бұрын
Hi Lernen, are you able to teach how to delete too? Thanks
@Samirovisc
2 жыл бұрын
Man, you rock. Thanks a lot for this explanation, amazing
@Doenerpaul
Жыл бұрын
How can I resolve the issue, that when my list contains multiple items with the same title the loop mixes the items up?
@unbiasedUBR
2 жыл бұрын
How to delete all rows in table or how to replace the old data with new data
@AnuarKZAst
4 жыл бұрын
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?
@LernenTech
4 жыл бұрын
For further questions and queries mail us to lernentech@gmail.com or drop a message to our Facebook page - facebook.com/Lernentech/
@Dakshu_Talks
Жыл бұрын
Pls let me know what is best approach for adding data to list without third party tool
@joelleaboytez4030
2 жыл бұрын
@William Lee - did you ever get an answer? I am having the same issue :( Thank you!
@paulsinner890
Жыл бұрын
Does this also work with document libraries?
@syedsiddique8343
Жыл бұрын
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.
@Bren4000
3 жыл бұрын
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
@LernenTech
3 жыл бұрын
For further queries do WhatsApp message on --> +91 9557196693 or mail us to
@RowDogSA
3 жыл бұрын
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.
@LernenTech
3 жыл бұрын
Sure will try.
@Jneto52
3 жыл бұрын
Hello, nice video. Help me so much but, when start my flow only use 256 elements and I have 300+. Any advice?
@LernenTech
3 жыл бұрын
chnage flow thrashold limit
@harrybhmra6813
4 жыл бұрын
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
4 жыл бұрын
Create a table name excel offline and upload
@harrybhmra6813
4 жыл бұрын
@@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
@eslikekana7427
Жыл бұрын
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
@kanjankav
2 жыл бұрын
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
@ankushparit
3 жыл бұрын
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 ?
@LuisGonzalez-dj3bh
4 ай бұрын
What if I want to create items into my List and filters out rows from excel that have empty values for a specific column?
@LuisGonzalez-dj3bh
4 ай бұрын
So it only creates list items if the excel data has a title and a value in the specific column
@sciphan
2 жыл бұрын
"Excel Online (Business)" does not appear as an option for me in Power Automate. Can you explain why?
@biosrmarun
4 жыл бұрын
Hi Sir, so thankful for your lesson when i tried i am getting the below error not sure what is the problem but i am get data updated in the list after that the flow has been failed "Unable to process template language expressions for action 'Condition' at line '1' and column '24757': 'The template language function 'length' expects its parameter to be an array or a string. The provided value is of type 'Null'".
@LernenTech
4 жыл бұрын
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/
@pollosos88
6 ай бұрын
Hello, its a very useful tutorial, just when im trying to do the same, i receive the following error on the condition yes: InvalidTemplate. Unable to process template language expressions in action 'Update_item' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'. Could you help to solve?. thanks a lot.
@tumuji3167
3 жыл бұрын
This is what I am looking for! 🙏 thx
@jessicaho7555
3 жыл бұрын
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?
@rakiiirak9943
3 жыл бұрын
Hello is there any way to add new column in excel and the same to sharepoint using the same flow you have created.
@LernenTech
3 жыл бұрын
not sure
@VincentTepper
Жыл бұрын
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?
@LernenTech
Жыл бұрын
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
@KATERINEJULIO-ko3lm
Жыл бұрын
@@LernenTech Please I don't know why duplicates everytime I run the flow.
@scottpedro6092
3 жыл бұрын
Thanks! But can it also sync when I delete a row in excel? It seems the item is still remained in my SharePoint list..
@LernenTech
3 жыл бұрын
deletion is something a complex one.
@DuncanCunningham
4 жыл бұрын
Does this solution also work for Google Sheets? I've put together a flow, like yours but I'm struggling to get it to save as I've done something wrong with the flow it says: Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The repetition action(s) 'Apply_to_each_2' referenced by 'inputs' in action 'Get_row' are not defined in the template.'.'. so I"m trying to apply this to a Google Sheet solution but not hitting the right commands. Have you got something like this but for Google Sheets?
@LernenTech
4 жыл бұрын
not tested yet
@zimands5
4 жыл бұрын
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?
@LernenTech
4 жыл бұрын
It should
@ashvinsaini01
4 жыл бұрын
Hi, thank you for valuable video. Can we add ms form excel attachement data on another excel file which stored in SharePoint.
@LernenTech
4 жыл бұрын
not sure what you are looking for?
@matthewwaldron5488
4 жыл бұрын
I have a few questions that I am having difficultly finding the answers to... 1) Is it possible to set up a logic that prevents the flow from pulling over duplicate information? 2) Can you set it up where it will not pull over information without a specific cell in a row being filled out? 3) One of the cells I want to pull over has a date, but when it pulls to the SharePoint list, it converts the date to a number, and when I set up the column to be formatted as a date, it prevents the flow from running because Excel is exporting the number, not the date. How can I have the date transfer over?
@LernenTech
4 жыл бұрын
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/
@KATERINEJULIO-ko3lm
Жыл бұрын
@@LernenTech Hello there, I'm experiencing an issue with duplicate values in my SharePoint list despite using an ID column in both the SharePoint list and Excel file. I've tried running the flow multiple times, but the problem persists. Additionally, I've attempted to connect through WSP and Facebook but haven't received a response. Could you please assist me with this issue? Thank you
@jackdavis874
Жыл бұрын
This video is a god-send
@prasadredkar
3 жыл бұрын
I get error at filter query. Yours Title is my Vessel , it says " The expression "Vessel eq 'vessel name'" is not valid. Creating query failed." but i have that column present there. Thanks in advance
@LernenTech
3 жыл бұрын
check the latest video on this topic.
@miharold
2 жыл бұрын
I really appreciate your help.
@luismagana3815
Жыл бұрын
what about if I have a blank cell.... I got error? do yuo know how to fix the issue?
@dcm9058
4 жыл бұрын
Hi Lernen Tech :), i tried using this Flow and twas nice but then it is sending multiple emails everytime i change something in the excel file...i mean is there a flow that would send an email only once the excel file has been closed? so that the email is sent only once. Thanks!
@LernenTech
4 жыл бұрын
For further questions and queries mail us to lernentech@gmail.com or drop a message to our Facebook page - facebook.com/Lernentech/ or do a Whatsapp message on - +91 9557196693
@manisarakositchaiwat9520
4 жыл бұрын
Hello, I did follow as demo and Run flow has succeeded but no data upload to Share Point. And no error indicated, I am very curious.
@LernenTech
4 жыл бұрын
For further queries do Whatsapp message on --> +91 9557196693
@michag1982
4 жыл бұрын
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?
@michag1982
4 жыл бұрын
Any ideas for documents library?
@LernenTech
4 жыл бұрын
For further questions and queries mail us to lernentech@gmail.com or drop a message to our Facebook page - facebook.com/Lernentech/
@javierzuzuk6121
Жыл бұрын
I would like to replicate excel into Sharepoint list? How can I do this? Thanks
@uciluis8013
3 жыл бұрын
Hello! i have only 20 row why only 3 row can copy to sharepoint list? hopefully you can answer thankyou :)
@LernenTech
3 жыл бұрын
chnage flow get items settings
@staceyscarcella
4 жыл бұрын
Is there a way to only update rows that have changed? in the condition to update it appears to modify all the records in sharepoint...
Пікірлер: 339