📊⤵️EXPORTING SHAREPOINT DATA TO EXCEL - A Step by Step Guide
Vložit
- čas přidán 17. 09. 2022
- Today's video is inspired by a comment from a subscriber. The request was to create a workflow for exporting data from a #sharepoint List to a new #excel file on a weekly basis. After the document has been populated with the data, the #workflow will empty the list for it to be filled again in the new week.
To make it a bit more errorproof, #powerautomate will check if the file has been successfully created, otherwise it will send a notification email to the owner of your choice.
If you want to learn more about Power Automate in cooperation with SharePoint, you are welcome to follow the channel and subscribe to the playlist here: / @enea
Feel Free to follow me on other social media platforms as well:
linktr.ee/EneaLicaj
Buy me a pizza 🍕- bmc.link/enealicaj - Věda a technologie
This was great! I really like your approach to videos. Thank you!
Thank you very much! 😊
really in depth video love it! struggling though with the tiny little functions and code snippets you paste. in the future could you include them in the description or something? currently working on reproducing this and PA is very picky so the smallest typos obviously create lots of issues xD
Sorry for that, I will try to make the functions a bit more visible. The video description box is very limited to how many characters I can use 😒. Let me know if there is something that you cannot see at all
This is Genious :-) After 3 days of &?**$&?*&? , I found you and this video. You save my day. Thanks
Happy I could help 😊
Hey Question, sharepoint export shows additional two columns called Item and Path. but they are not display in sharepoint list items. when export to excel only it will be added. how to configure that part
What do you want to configure there? Those are internal columns that cannot be changed, as of my knowledge
Thanks for detailed steps, how can i attach this new file in my email?
Thanks! After creating the file and filling it with the data, you can do a "Get file" and "Get file" content action with the ID of the newly created file. That you can then use in a "Send an email" action. Makes sense?
The "add row into a table failes, due ´to the "A value must be provided for item. clientRequestId: 1ca8dc9d-5dab-4bec-9ee8-a960dd37f219" Does it mean this will fail if there are some empty values?
Probably, you can add a condition checking if the value is empty first to catch the error
Hi, will it work with a picture in a sp column ?
I haven’t tried to be honest but I imagine you would just get the url of the image, not the file itself.
Hello mate, it's a great video. Can you please create a video which can explain unpivot SharePoint list and export data to excel directly to our desktop instead of saving in SharePoint files section.
Thank you so much!!
Hi! Your desktop needs to be synced with OneDrive for Power Automate to be able to access it. Otherwise its not possible, you would need Power Automate Desktop to do that. Can you explain what do you mean by unpivot SharePoint List?
@@Enea I have a SharePoint list containing columns as product type, product name, Sunday, Monday, Tuesday, Wednesday etc., now I need to extract this SharePoint list to excel with columns product type, product name and sales. Column wise data need to convert into row wise data in excel.
Thank you.
Cool idea, I will check and let you know :)
How do i add a row into excel from SP lists that contain Person column with 2 or more people in one item without duplicating the rows in excel ?
You can initiate an array variable at the beginning of your flow and then append the Name or the email from the multiselect person column in it in an apply to each loop. Then you can concatenate the values in the array into a single string split by semicolon or dash or whatever you want. And that is what you use in excel step. This way you would prevent it from creating a row for each person in an item
@@Enea Any Chance of a video for this totally need help ?
@@jonathanmartin3883 I dont have one but I was looking for an idea anyways, thinking of doing a short one on this topic on the weekend.
@@Enea That Would be great thanks
What is the Filter Query at 12:14, file ref?
FileLeafRef
Thanks for the detailed explanation... I tried to create a new flow by following the steps you have mentioned in the video. However, I am getting only one error. Request you to help me to resolve this error (Get_tables --> body --> value is coming blank). Thank you.
unable to process template language expressions in action "Set_variable_2" inputs at line '0' and column '0': 'The template expression 'outputs('Get_tables')?['body/value'][0]['Name'] cannot be evaluated because array index '0' cannot be selected from empty array.
It looks like your Excel has no tables. Have you formatted you data in Excel in a table format?
@@Enea Thank again for your swift response. Exactly, I have done the same mistake. I have formatted the data in Excel in a table format and it's working fine now. This video is very helpful :)
The empty row issue is coming from your template, if you look at 18:54, there is a row under you headers. Delete that row, but keep the table, that'll solve the problem.
I thought I tried that. Thanks for commenting! :)