Power Automate Adding & Updating from Excel to Sharepoint List

  Рет қаралды 35,893

Happy To You

Happy To You

3 жыл бұрын

Пікірлер: 43
@nikhilmatere5838
@nikhilmatere5838 Ай бұрын
Very precise and perfect explaination.
@user-wd2up9un1z
@user-wd2up9un1z 2 ай бұрын
I was trying to do this but cannot locate the value option in dynamic content instead its showing body/value.
@paulhaine6131
@paulhaine6131 2 жыл бұрын
Very helpful and clear. I was able to produce a working flow in a few hours having never used Power Automate before.
@user-ob6th2vu8b
@user-ob6th2vu8b 2 жыл бұрын
i find this by lomg times, very helpful , thank you
@KasunNiroshana
@KasunNiroshana 2 жыл бұрын
Mate could you share the code that you copied to the Length content at 5.31. cant see the complete code. Thank you
@danfirmalino4196
@danfirmalino4196 Жыл бұрын
nice vid! what if i have a multiple file with one table name and i want to make a custom list? is it possible?
@mrkrab389
@mrkrab389 Жыл бұрын
hello can i ask a question, how if have empty data on my raw data, for example in your data if title5 in column market is empyy, but i want updating this to my sharepoinntlist, i try this one use your script doesnt work. anyone can help me to show the way?
@ghanakumaran
@ghanakumaran 9 ай бұрын
What happens if one of the excel columns is empty. Does the flow still run?
@abenoliquino2959
@abenoliquino2959 2 жыл бұрын
thank you for the shared ideas. just and maybe you can help on how to add data on same row between 1 and 2. every added data will be created just below the header. Thanks in advance
@happytoyou4332
@happytoyou4332 2 жыл бұрын
Add data on same row? Do u mean edit the item?
@saikirannallani1516
@saikirannallani1516 8 ай бұрын
I have hyperlinks column in my excel sheet, I have to copy and paste from excel to lists. I tried creating column header with hyperlink data type and tried pasting hyperlinks to lists. Data is pasted in lists but all hyper links shows errors in Lists. Can you please help what is best way to copy and paste or transfer hyperlinks data from excel to lists?
@xaviergonzalez7047
@xaviergonzalez7047 Жыл бұрын
It is not working on the step: Get Items in Filter Query. I entered exactly the same, but I got this error: Unable to process template language expressions for action 'Condition' at line '0' and column '0'. Anyone can help?
@Tabarnac2010
@Tabarnac2010 4 ай бұрын
If I erase one line in Excel, would it erase it in SharePoint List too?
@SrikantRZradio
@SrikantRZradio 2 жыл бұрын
hello - My friend . I could not hear your voice . too low . Condition for YES . was it length(outputs('Get_items')?['body/value']) . Please explain , regards
@toystoys6793
@toystoys6793 4 ай бұрын
After updating or creating rows, flow process stops at row 222, anyone knows what could be the reason?
@einz3503
@einz3503 2 жыл бұрын
Hello po. Thanks for sharing this. It helped me a lot. My only concern is whenever I update my excel sheet, it also updates my share point list but it has spaces in between each item. Could you help me with this please. Thanks.
@1M1U5RA
@1M1U5RA 5 ай бұрын
I followed this but didn't work as same as yours.  SharePoint Update list needs items, but it didn't appear.
@kolaborasimusicindonesia9871
@kolaborasimusicindonesia9871 2 жыл бұрын
Equal to symbol??
@nitishjha6705
@nitishjha6705 Ай бұрын
I have exactly done the same , create item error
@vamsimantripragada
@vamsimantripragada Жыл бұрын
Hello Sir, can you make a video to add data from Macro files like. Xlsm to share point list?
@MrGrimii
@MrGrimii Жыл бұрын
You can't do xlsm. I had my xlms move all the data to a xlsx (with vba) then connected tl sharepoint list like the video.
@sanprasa1
@sanprasa1 Жыл бұрын
sooooo ammmmmm
@neilianmergenio2863
@neilianmergenio2863 5 ай бұрын
hi can you help me on my problem in power automate please.
@luismagana3815
@luismagana3815 Жыл бұрын
All is excellet but..... if the cell is blank the flow got error?
@justrhuna2263
@justrhuna2263 Жыл бұрын
From the last condition create item you can try write it null if rows are blank.
@johnarkdelossantos9406
@johnarkdelossantos9406 Жыл бұрын
Boss paano pag hindi lumalabas ung link ng sharepoint dun sa iniput ko?
@kennyliboon3411
@kennyliboon3411 Жыл бұрын
boss pinoy ka po ba? may FB k po ba na pdeng ifollow?
@BoyTukaness
@BoyTukaness 2 жыл бұрын
Kabayan! Good day! I saw your KZbin tutorial in Power Automate, maybe you could help me with my problem, its updating an Existing Excel file from SharePoint list but with specific columns only.
@happytoyou4332
@happytoyou4332 2 жыл бұрын
Exel file on sharepoint list? Do u mean uploaded excel file from sharepoint site?
@BoyTukaness
@BoyTukaness 2 жыл бұрын
@@happytoyou4332 The excel file is in the SharePoint library, I need to update it with selected columns only but I dont know how.
@happytoyou4332
@happytoyou4332 2 жыл бұрын
You need to update from? And what is the trigger?
@BoyTukaness
@BoyTukaness 2 жыл бұрын
@@happytoyou4332 From Power Automate -> Manual trigger then Extract Selected Columns in SharePoint -> Update Existing Excel File.
@happytoyou4332
@happytoyou4332 2 жыл бұрын
I dont know why u need to extract the file where the 2 datasource is in the web itself.
@sofienemhiri6690
@sofienemhiri6690 16 сағат бұрын
ca marche pas
@milemen7539
@milemen7539 2 жыл бұрын
so hard :(
НРАВИТСЯ ЭТОТ ФОРМАТ??
00:37
МЯТНАЯ ФАНТА
Рет қаралды 8 МЛН
Amazing weight loss transformation !! 😱😱
00:24
Tibo InShape
Рет қаралды 62 МЛН
How Many Balloons Does It Take To Fly?
00:18
MrBeast
Рет қаралды 196 МЛН
Я обещал подарить ему самокат!
01:00
Vlad Samokatchik
Рет қаралды 8 МЛН
Power Automate - Bulk Add Excel data to SharePoint List
9:11
DS TechMirror
Рет қаралды 29 М.
Add & Update Excel Data to SharePoint List using Power Automate
9:54
Power Automate: Add and update data in bulk
30:58
Daniel Christian
Рет қаралды 47 М.
Quickly Import CSV Data to a SharePoint List with Power Automate
10:49
A Creative Opinion
Рет қаралды 25 М.
A MS Flow to automatically update SharePoint List using excel in Hindi
32:53
Technical Knowledge Beta
Рет қаралды 20 М.
НРАВИТСЯ ЭТОТ ФОРМАТ??
00:37
МЯТНАЯ ФАНТА
Рет қаралды 8 МЛН