Hi Krishna - I wanted to drop a note to say thank you for this. I needed a way to create a table in an Excel source file that gets updated daily and is of indeterminate length and your thought process here was very helpful. Thanks again for giving your knowledge!
This is exactly what I needed. The office script one, which is also cool, just seems so insane. They should just have a Excel Read Worksheet as Table Action Item that sort of does all this for you and assumes first row is columns or allow for addition...but hey, when in Rome.
Hi Krishna, this is brilliant and I have been following your videos, thank you. I have a question, can we open a file that will be password protected and do the same as what you just did. let us assume the password never changes and we need to provide that to open then create the table and move it to the SP list appropriately. Please advise if this is possible and it will be great if you can make a video for that.
PLEASE HELP Thanks for the great tutorial but I got stuck...! At 16:00 - you added "mapped all the other columns accordingly" but did not show how you did it - I could not replicate or figure it out, as clicking on dynamic value icon only gave me When a File is Created in a Folder or Apply to Each - none contained the columns names. Can you please explain how to map in the values for the column names? For beginners that do not know Python, HTML or how to build Create Item values.
Hello I have a question if the sharepoint list that I want to add this is a newly created one (also created through the flow) how can I separate the columns and populate that into the sharepoint list?
You can SharePoint API’s in power automate to drop the columns on list-1 and create the same columns and in list-2. After that you can populate the date appropriately!
This post is useful for me .. but when I'm setting the range of 50000 while creating the table it's working. List rows I applied the filter query one of my column which is ne '' but list rows is telling the request resources doesn't exist
Thanks for this video. I followed the steps and the first step has successfully tested my Create file from attachment, but when I try to test the next step Create table I get an error.
"status": 404, "message": "The resource could not be found. clientRequestId: c38760a2-8d80-4aa0-95eb-72682f7ebacb serviceRequestId: 3912652e-4fe1-4913-8fe5-3f0c828a9955", "error": { "message": "The resource could not be found." },
The File Id is being called from the previous Create File action, which tested successfully - but it now can't find the item for this step. Any ideas what could cause this as I've found a few similar posts in forums, but no concrete solutions? Thanks
I get the same, first run it OK but after that you get the error. Only way to clear is to map to the file again. But again only for first run ... so not so helpful :(
it is because of the file being direct to name. File ID is updated each time modified or new. So we need to do the steps before in using the dynamic ID
Man, you are the god to point out using the JSON expression to pull values.
Thank you it means a lot to me
Hi Krishna - I wanted to drop a note to say thank you for this. I needed a way to create a table in an Excel source file that gets updated daily and is of indeterminate length and your thought process here was very helpful. Thanks again for giving your knowledge!
I am glad it gave an idea for your project
this was amazing! thank you very much
glad worked for you!
This is exactly what I needed. The office script one, which is also cool, just seems so insane. They should just have a Excel Read Worksheet as Table Action Item that sort of does all this for you and assumes first row is columns or allow for addition...but hey, when in Rome.
super. exactly similar requirement. thank you sir
Hi Krishna, this is brilliant and I have been following your videos, thank you.
I have a question, can we open a file that will be password protected and do the same as what you just did. let us assume the password never changes and we need to provide that to open then create the table and move it to the SP list appropriately. Please advise if this is possible and it will be great if you can make a video for that.
TO best of my knowledge this is not possible because there is not way to open a password protected files from Power Platform!
Great video!!! this is an amazing topic many thanks for sharing your knowledge with us! Is it possible to do the same but with a csv file?
Yes very much possible
Thanks for the video, Can you tell me how to create table for multiple sheets in the same excel file?
hmm that is something I need to try Vignesh, may be I will do it as version-2
Hi Krishna this is really amazing. but in my excel sheet there are 3 worksheets how can I create the tables for 3 worksheets.
PLEASE HELP Thanks for the great tutorial but I got stuck...! At 16:00 - you added "mapped all the other columns accordingly" but did not show how you did it - I could not replicate or figure it out, as clicking on dynamic value icon only gave me When a File is Created in a Folder or Apply to Each - none contained the columns names. Can you please explain how to map in the values for the column names? For beginners that do not know Python, HTML or how to build Create Item values.
those columns will be shown automatically with the get item action above so all you need to do is select which column you want to associate
Hello I have a question if the sharepoint list that I want to add this is a newly created one (also created through the flow) how can I separate the columns and populate that into the sharepoint list?
You can SharePoint API’s in power automate to drop the columns on list-1 and create the same columns and in list-2. After that you can populate the date appropriately!
Hey, If I don't know how many columns are in my Excel file then how to define column value?
This post is useful for me .. but when I'm setting the range of 50000 while creating the table it's working. List rows I applied the filter query one of my column which is ne '' but list rows is telling the request resources doesn't exist
this is fine but i get an error message when using 'list rows' for system bandwidth usage going out.
Not very clear elaborate more understand it is a generic issue I have explained in video or your project level error
it tell me could not overwrite? are you sure this working
Yes it was a proven approach and validated multiple times
Thanks for this video.
I followed the steps and the first step has successfully tested my Create file from attachment, but when I try to test the next step Create table I get an error.
"status": 404,
"message": "The resource could not be found.
clientRequestId: c38760a2-8d80-4aa0-95eb-72682f7ebacb
serviceRequestId: 3912652e-4fe1-4913-8fe5-3f0c828a9955",
"error": {
"message": "The resource could not be found."
},
The File Id is being called from the previous Create File action, which tested successfully - but it now can't find the item for this step.
Any ideas what could cause this as I've found a few similar posts in forums, but no concrete solutions?
Thanks
I have to review the flow because this has been implemented by many makers!
I get the same, first run it OK but after that you get the error. Only way to clear is to map to the file again. But again only for first run ... so not so helpful :(
it is because of the file being direct to name. File ID is updated each time modified or new. So we need to do the steps before in using the dynamic ID
I'm getting the same error messages. No table was found with the name 'Table1'.
who to work with date in the Excel gving error.
Didn’t get your question clearly!