This video is really great and I'd love to try it on my current project. However, I cannot successfully import the BatchSharePoint_1_0_0_5.zip from your portfolio. :(

Blog post is corrupt. Cannot download.

Great video for beginners. I cant find the zip file on the link though. plz help

Thank you! Any chance you can re upload the zip ? Microsoft nuked their community site this week

mind blowing but am unable to download the list and solution

hi, i dont see the zip packege. How could I download it?

The link to the community thread download takes me to a page that does not display a download. It looks like Microsoft rolled out an update that may have killed the link to the download.

Hello Tyler, Thank you for the tutorial; it is exactly what I have been looking for for a long time. I did exactly what you proposed, but my Power Automate is limited, so I used version B. However, when I run the flow, which runs without error, it does not identify any changes, additions, or deleted rows. I have checked the unique ID key, and it is correct, and I configured the columns the same as in my spreadsheet, setting ID, Category, and Status to change, add, or delete to identify. However, when I make changes, they are not found in the input or output. What could be happening? Thank you in advance.

I’m having trouble finding the download link. Is it still up?

Hello, how do I find the zip file?

Hello! The downloadable packages are missing on the referenced page. Is there another way to download the flow templates?

Hello! The downloadable packages are missing on the referenced page. Is there another way to download the flow templates?

Can the source data be from Dataverse and the destination be excel?

thanks for the video also how can I send the modified rows before and after to see the change as an email?

Hi, I’m really stuck on the whole check for column changes section. Please could you share the expressions that are being used in the create CSV, The Linebreak and the condition Also, what is type of action is ‘Linebreak’ and what is this doing? Thanks!

Hi Tyler, thanks for the great tutorial! I'm currently following this tutorial and there is one part I would like to clarify. In the timestamp of 11:07 of this video, where you described the "Condition If Users edited during table read stop and let later flow run" action, you have this fields: "Modified" "is greater than" "Modified". I would like to know the expression for the "Modified" for the left operand before the "is greater than" and the "Modified" at the right operand after the "is greater than" because these fields were not mentioned in your tutorial. Thanks!

Hi Tyler, i downloaded the same file as you, but when i go to solution > Import Solution > Browse > Select the file > Next at this point i'm getting an error "The solution file is invalid. The compressed file must contain the following files at its root: solution.xml, customizations.xml, and [Content_Types].xml. Customization files exported from previous versions of Microsoft Dynamics 365 are not supported."

Great set of instructions. I'm trying to adopt this now and have 2 questions: 1) While the flow executes is skips the step "Load previous table version copy before updating to the most recent table copy" shows 'skipped' when testing. Why? and 2) the email recipient in your example is static. How can I get a dynamic email looked up based on the value in a column of the spreadsheet?

Great Video Tyler! It was extremely helpful! Do you mind sharing your expertise with me for a bit? 1. In the HTML email for modified rows, would it be possible to include two tables: one for the previous values and the other for the modified values? 2. I have about 10 tables in one workbook and would like to build 10 different workflows. Would it be possible to built the condition in the early of the flow to check if a specific table is updated, then run the flow? currently I can only find "When an item or a file is modified". Thanks!!!

Is there an updated version of this?

I am getting an error indicating "The compressed file must contain the following files at its root:solution.xml,customizations.xml, and [content_types].xml. Customization files exported from previous versions of Microsoft dynamics 365 are not supported.

I followed but I get failed messages and I am not able to fix it.

This is helpful and valuable thank you! I am just starting this path and I am not a technical person my background is mostly in business. I am getting this error: Selected column name 'ID' not found in Excel table. clientRequestId: 3486357b-6173-4973-90b4-47e90dd4521d serviceRequestId: f483af1d-1f97-4f24-8403-2faae7c4641f;e9d5c58c-e4b0-41fc-9502-cb2d827bb46d;3269ab32-1e6e-4e8c-86be-e0c8d2da9571 I am supposing this is a table format error, Do you have a different video of how to set up this kind of tables or excel documents to work properly? Thanks a lot PD: Sorry if its a really basic/dumb question!

I am having problems with the post, Bulk Row Upload to Dataverse from Power Automate, how do you save information in a lookup type column that comes from another data table, or a date column of (MM/dd/yyyy)

How can i use parallel braching for same snerio to create data in different list from different sheet please help me this If i am Creating parallel branch but not able to create data in list getting failed second branch

Hi Tyler ,thank you for sharing this amazing video. I encountered an errot with the package version 1.7, which gives the error message: "The 'Create text with GPT' action doesn't have a content approval action after it." I did not add anything to the package. Could you please advise what might be going wrong?

If I was trying to change how the date was pulled from the excel file how and where would I put in that step? I know it can be changed to ISO 8601 but is there a step I can put in for a specific format without breaking the flow?

Hi Tyler, great video and very helpful. What is the benefit with this flow using GPT vs AI Builder invoice reading? Also should a business be concerned with vendor data flowing through GPT services? Thanks!

This is great stuff. Thank you for sharing. I have about 25000 records that need to be uploaded to SPList but it only took 16000 over. Would you know why it did not complete the upload?

when sharepoint list have 1 milion records. can app show data it well?

hi, i tried this exact method and this is not adding any rows to my excel. it is only adding 1 row with the empty values. can you show me the data format in the action "Filter array Get records not found in table " that we take as input array to create the rows. because I have in the format [ {col1row1 : val1, col2row1 : val2}, {col1row2 : val1, col2row2 : val2} ]

I know Powerapps just switching things around...but I can't import this thing. Indicates there are dependencies that need downloading.

Hi I'm now stuck at the create prompt part, I've tried using both v1.7 and v3. I use the new "create text with GPT using a prompt". But other than the prompt itself, there is another parameter called "infer request". I could not find any info online on what to put here. And if I choose "output" or something else random, and try to run the flow, the flow would just fail at that part. Would appreciate some help please. Error details: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN""www.w3.org/TR/html4/strict.dtd"> <HTML><HEAD><TITLE>Bad Request</TITLE> <META HTTP-EQUIV="Content-Type" Content="text/html; charset=us-ascii"></HEAD> <BODY><h2>Bad Request - Invalid URL</h2> <hr><p>HTTP Error 400. The request URL is invalid.</p> </BODY></HTML>

Thank you

I am presently attempting your flow but amending with SQL datasource - let me know of any pitfalls I should watch out for with this amendment, otherwise I'll report back on my progress!! (fingers crossed)

Great video! Will this also work for a xlsm format?

Dude! This is amazing. I installed the solution... but I am having a hard time making heads and tails of how to point it towards a different list. I changed the list name to a new list, but I am getting Network Errors 502 Bad gateway when running on start... the new list is in the same site as the SP Large List... Any ideas?

Thank you so much for this valuable video!! You saved me hours of slaving away updating SharePoint list.

I used your upsert flow.It was nice..I got my expected result. Can we delete the items from splist,which is not present in excel?Please give some guidance

thank You so much ! Best regards

Hi Tyler, this was very helpful. Is there a way to add branching to the questions. E.g first question (Name is Project Type) is marked as mandatory, if you select "New Project" then it opens unique questions assigned to the New Project Option, if you select "Existing Project, then it opens unique questions assigned to the "Existing Project Option"

Building on Dustyn2429's question, the flow currently batches the notifications when it runs, sending the same group of change notifications to each person. Is it possible to have each row that is assigned to a specific person only go to that person (rather than all who were in the same batch of changes when the flow triggered)? This is a very useful tutorial but I'm stuck on this tweak. Thanks!

nice content really helpful I have a project that needs to extract info from contracts. I can use this one for automation but may I know if those consumes ai credits with this workflow? another question since its using ocr can it transcribe hadwritten text like dates after a signature?

Thanks Tyler, One quick query - Is it possible to read table rows content continuing from Page 1 to page 2. My use case is below I need to extract information in tabular format from order confirmation pdfs received. Each pdf has multiple items and each item will have a Name, description, Vendor and delivery date. So the table will have four columns: Name , description, Vendor, Delivery Date with each row representing an item. The problem arises when some details for an item are present at the bottom of one page and the remaining details are on the next page. Example : Description in the table continuing in the page 2 from page 1 bottom , So unable to tag these rows which is continuing from page 1 to page 2. For example: if this is the pdf -----some text-------------------------------------------- -----some text--------------------------------------------- code: 1 description: this is first item Vendor: XYZ1 delivery date: 12.01.2024 code: 102 description: this is second item Vendor: XYZ2 delivery date: 13.01.2024 code: 103 description: this is third item -------page 1 ends here--------- -------page 2 begins here-------- description(Continuing from Page): this is third item Continuing Vendor: XYZ3 delivery date: 14.01.2024 code: 104 description: this is fourth item Vendor: XYZ4 delivery date: 15.01.2024 code: 105 description: this is fifth item Vendor: XYZ5 delivery date: 16.01.2024 ---------some text here-------------------------------- ------------------------------page 2 ends---------------------- ------------------------------pdf ends---------------------------- The document cannot be tagged correctly using custom model when page 1 content - Description is continuing on Page 2 . For the above document, the tagged tables look like this Code Description Vendor Delivery Date 101 this is first item XYZ1 11.01.2024 102 this is second item XYZ2 12.01.2024 103 this is third item XYZ3 13.01.2024 Code Description Vendor Delivery Date Some text are continuing from page 1 104 this is fourth item XYZ4 14.01.2024 105 this is fifth item XYZ5 15.01.2024

Hi, would you mind to help, how can i get only the latest duplicate records? Ex: i have 3 latest record, with recordID = 10, how I can i get this 3 records only? Not all listed duplicate. Basically what I want is the latest data only from my list. But latest data may vary time to time

Hey, what you've created is awesome. Thank you. But just one question though, is this still going to work even If I have a giant power automate flow and use this flow at the end? cause from what I see you've composed all your action in one scope and I think my flow is divided into several if conditions in between and so on. Like for example action1->action 2->action 3 ->if condition and likewise

Hi, I have tried the same code, there is no error in the flow, but somehow all the records are not getting created. In the response I could see 500 operation timed out error for few records. Any way to overcome this error?

Anyone concerned about the amount of pages they can feed the model may want to check a new template using GPT 4 Turbo & Retrieval Augmented Generation (RAG) to expand querying to just about any length document here: powerusers.microsoft.com/t5/Power-Automate-Cookbook/Query-Large-PDFs-With-GPT-RAG/td-p/2650178

Excellent video! Trying to reset searchinput (modern text input), with your refresh formula, but gallery not show all items again, how to reset search input and gallery to show all items again?

Can you show us simply trigger a email notification when new Row added with ID Number>