Tyler Kolota
Tyler Kolota
  • Видео 21
  • Просмотров 211 010
Find & Remove Duplicates - Power Automate
Need to identify and/or remove records in a datasource based on duplicate values in one or more columns?
This template uses a SharePoint list to demonstrate, but this method ultimately pulls in the data from any source as a standard JSON array and processes it to identify all the duplicates based on the selected columns. From there the duplicates can be easily deleted.
Community Thread & Download Page: powerusers.microsoft.com/t5/Power-Automate-Cookbook/Find-and-Remove-Duplicates/td-p/2191403
Microsoft started renovating their community site. They didn't transfer the download files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a...
Просмотров: 6 975

Видео

Read Excel 5X Faster - Power Automate
Просмотров 1,8 тыс.11 месяцев назад
If you're finding the standard List rows present in table Excel action is too limited or too slow, check the method built in this template. It can read in more than 100,000 Excel rows more than 5 times faster than standard List rows actions without any premium connectors. Community Thread & Download Page: powerusers.microsoft.com/t5/Power-Automate-Cookbook/Faster-Excel-Reads/td-p/2523489 Micros...
Filter & Search SharePoint List Fast - Power Automate
Просмотров 2,7 тыс.11 месяцев назад
Flow template for a very fast & customizable way to read, filter, & search on large SharePoint lists. At a high level, it gets the highest & lowest ID numbers from the list, & uses those to calculate how many batches it needs to read in from SP. Then using an Apply to each, concurrently reads those batches in using the SP HTTP action. If there is a search term, it is using the process that appl...
When an Excel row is created, modified, or deleted
Просмотров 18 тыс.Год назад
Power Automate template workaround for "When an Excel row is created", "When an Excel row is modified", and/or "When an Excel row is deleted" triggers. Community Thread & Template Download Page: powerusers.microsoft.com/t5/Power-Automate-Cookbook/When-an-Excel-row-is-created-modified-or-deleted/td-p/2264670 Microsoft started renovating their community site. They didn't transfer the download fil...
No Delegation Limit - SharePoint List Power App
Просмотров 13 тыс.Год назад
Community Thread & Download Page: powerusers.microsoft.com/t5/Community-App-Samples/Large-SP-List-Delegation-Workaround-App/td-p/2330721 Microsoft started renovating their community site. They didn't transfer the download files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from their support team. In the meantime, here i...
(Preview) Delegable Large SP List Power App
Просмотров 1,2 тыс.Год назад
Template Community Thread & Download: powerusers.microsoft.com/t5/Community-App-Samples/Delegable-Large-SharePoint-List-App/td-p/2330721 New full video here: ruclips.net/video/EH-YndEPIiI/видео.htmlsi=MVWUZ-qne6rdkJ9Y Delegable Large SP List App This template app & flow set-up demonstrates a method loading, filtering, & searching a large SharePoint without delegation issues. What is meant by de...
SharePoint Batch Update, Create, & Upsert
Просмотров 13 тыс.Год назад
Download Page & Microsoft Community Thread: powerusers.microsoft.com/t5/Power-Automate-Cookbook/Batch-Update-Create-and-Upsert-SharePoint-Lists/td-p/1365410 Microsoft started renovating their community site. They didn't transfer the download files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from their support team. In ...
GPT PDF & Image Data Extraction (Power Automate)
Просмотров 15 тыс.Год назад
Power Automate Community Thread & Download - Extract Data From PDFs and Images With GPT: powerusers.microsoft.com/t5/Power-Automate-Cookbook/Extract-Data-From-PDFs-and-Images-With-GPT/td-p/2201345 Microsoft started renovating their community site. They didn't transfer the download files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on...
Excel Batch Delete
Просмотров 1,6 тыс.Год назад
Power Automate Excel Batch Delete (40-50x Faster) Power Automate Community Thread & Download: powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Delete/td-p/1634375 Microsoft started renovating their community site. They didn't transfer the download files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from th...
Project Tracker: Microsoft Teams & SharePoint
Просмотров 55 тыс.Год назад
Want to create one source of truth for an entire project or initiative of projects using only standard Office365 & Power Platform applications? This template set-up combines a project log, kanban board, GANTT chart, RACI (role & workload tracking), and project update notifications system into one SharePoint list that is also embedded in a Teams channel. It does not require the hassle of provisi...
Excel Batch Update, Create, & Upsert
Просмотров 19 тыс.2 года назад
Update & Create Excel Records 50-100x Faster Batch Update, Create, & Upsert Excel Template Download: powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706 Microsoft started renovating their community site. They didn't transfer the download files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm wait...
Flow Failure Notifications (Power Automate)
Просмотров 20 тыс.2 года назад
Get email alerts with direct links to the flow run any time your flow fails by adding this set of actions to the end of your flow. Template & Community Thread: powerusers.microsoft.com/t5/Power-Automate-Cookbook/Flow-Failure-Notifications/td-p/1494079 Microsoft started renovating their community site. They didn't transfer the download files from the old site, & I can't manually re-upload any of...
Excel VBA: Webscrape Index Fund PE Ratios
Просмотров 4852 года назад
Using Selenium, the Excel VBA Browser Automation software, to webscrape price and earnings per share data from Yahoo Finance. Excel File & Macro/VBA Code Download [May open in Google sheets, just go to File then Download then Microsoft Excel (.xlms)]: drive.google.com/u/0/uc?id=13_0qxrEDz5Md3b1SCv4zhdmn6zF4Hgsx&export=download ONCE EVERYTHING IS DOWNLOADED & INSTALLED, GO TO Tools then Referenc...
Sending CSV Data To Datasets (Power Automate)
Просмотров 15 тыс.2 года назад
Download & Other Information: powerusers.microsoft.com/t5/Power-Automate-Cookbook/CSV-to-Dataset/m-p/1508191#M584 Microsoft started renovating their community site. They didn't transfer the download files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from their support team. In the meantime, here is a Google drive link t...
Automate Reports From External Datasources (Power Platform)
Просмотров 5 тыс.2 года назад
Automate Reports From External Datasources (Power Platform)
SharePoint Batch Update V1
Просмотров 12 тыс.3 года назад
SharePoint Batch Update V1
Affordable Cities & Buildings (Real Engineering & Marginal Revolution)
Просмотров 1524 года назад
Affordable Cities & Buildings (Real Engineering & Marginal Revolution)
Dutch Factory Paper & Regression Discontinuity Design
Просмотров 1244 года назад
Dutch Factory Paper & Regression Discontinuity Design
Mita Paper & Regression Discontinuity Design
Просмотров 1,3 тыс.5 лет назад
Mita Paper & Regression Discontinuity Design
Institutions & Development - Acemoglu & Robinson Research
Просмотров 3,5 тыс.5 лет назад
Institutions & Development - Acemoglu & Robinson Research

Комментарии

  • @kennethgottfredsen767
    @kennethgottfredsen767 13 часов назад

    Does this work if I want to search on a number column?

    • @tylerkolota
      @tylerkolota 11 часов назад

      @@kennethgottfredsen767 Yes. By default it will search the entire record for any column value or column name matching your input. Including number column values.

  • @tylerkolota
    @tylerkolota День назад

    There is also an alternate Office Scripts method to get a lot of Excel rows. It is more efficient & more flexible than the video’s method & can even get data not formatted as a table. community.powerplatform.com/galleries/gallery-posts/?postid=9f7a7bcf-c88f-ef11-ac20-7c1e525bd67d

  • @dineshtalekar8980
    @dineshtalekar8980 День назад

    @tyler kolota can you please put down details step what all things needs to modify in the flow once we imported the solution. I imported the solution i have record more than 110k but it is not working for me

    • @tylerkolota
      @tylerkolota День назад

      @@dineshtalekar8980 Hello, you should just have to set up the initial List rows action to point to your workbook & table. If for some reason you can’t get this flow working, there is this alternate Office Scripts flow that should be even more efficient & includes set-up instructions community.powerplatform.com/galleries/gallery-posts/?postid=9f7a7bcf-c88f-ef11-ac20-7c1e525bd67d

  • @RommelGerardGalindo
    @RommelGerardGalindo 5 дней назад

    How did you get the ID for each items?

    • @tylerkolota
      @tylerkolota 5 дней назад

      @@RommelGerardGalindo The destination list IDs? It pulls all destination list items, indexes them by the primary key column values, & then the GenerateSPData action is where the source dataset primary key values are used to lookup the ID of the destination list record where the source key value matches that destination item’s key value.

    • @RommelGerardGalindo
      @RommelGerardGalindo 5 дней назад

      I am trying to do filter query using join function so it will do like accountnumber eq 1 or accountnumber eq 2 and so on. Now i got the id in sharepoint list but i cant add it in my array and cant make a batch out of it

    • @tylerkolota
      @tylerkolota 4 дня назад

      @@RommelGerardGalindo You’re trying to do what? Are you trying to do a One to Many update where one source item may be used to update multiple destination items?

  • @Hellocrzywrld
    @Hellocrzywrld 9 дней назад

    Thanks for the great video May I know why did you use the reverse function in flow when joining the data returned from spo http call?

    • @tylerkolota
      @tylerkolota 9 дней назад

      @@Hellocrzywrld The reverse is not crucial in any way, just a very minor performance improvement because there is a later Sort( ) in the Respond to PowerApp actions that must sort the entire set of data in ascending order. So if all the batches were sorted in descending order then that ascending step would take a little longer because it would have to reverse the order within each batch & do it on an action that isn’t working concurrently. Meanwhile reversing the order at the previous step should require less computation & happen concurrently.

  • @davidlattimore663
    @davidlattimore663 11 дней назад

    Can’t seem to get this working. Any insights you can share ? Thanks. Dave

    • @tylerkolota
      @tylerkolota 10 дней назад

      @@davidlattimore663 I’d recommend watching the video & using the template for the newer Upsert V2.7. Then if you run into issues reach out again & we can troubleshoot. community.powerplatform.com/galleries/gallery-posts/?postid=dc95f047-afcc-4a31-bc84-962b240fe6fa

  • @Ben-lj3it
    @Ben-lj3it 18 дней назад

    Thanks for creating this flow, it's working wonders for me. My question is how could you change this so that depending on the cell/column changed, it would send different emails to different people. For example in row 10, columns 2, 4, & 6 change. I want to send an email to Person1 if column 2 changes, Person2 if column 4 changes, and Person3 if column 6 changes.

    • @tylerkolota
      @tylerkolota 17 дней назад

      Roughly I think I'd add a Filter array action inside the relevant Modified Apply to each loop with the Filter From input as the "Last table version" action & the condition set to where the Loop record's primary key matches the Last table version primary key. That should grab the relevant previous version of the record & then you can build conditions checking the values of various columns for changes across the new version & the last version.

    • @Ben-lj3it
      @Ben-lj3it 12 дней назад

      @@tylerkolota Thanks for the help. This worked Another question: For showing both the previous and new values, I copied the code but it's not working for me. The select action is not returning the new value. I tried changing the "select" code but can't figure it out. Code as below Select_Modified Keys "from": "@body('Modified_records')", "select": { "": "@concat(item()?[outputs('Settings')?['KeyColumnName']], if(empty(item()?[outputs('Settings')?['KeyColumnName2']]), '', item()?[outputs('Settings')?['KeyColumnName2']]))" Filter_array "from": "@outputs('Last_table_version')", "where": "@contains(body('Select_ModifiedKeys'),concat(item()?[outputs('Settings')?['KeyColumnName']], if(empty(item()?[outputs('Settings')?['KeyColumnName2']]), '', item()?[outputs('Settings')?['KeyColumnName2']])))"

  • @sg8127
    @sg8127 22 дня назад

    Thank sir

  • @monikk2777
    @monikk2777 23 дня назад

    Thank you so much for this. I am running into an issue with the Select Remove unique ItemInternalId action. I get the following error: The input parameter(s) of action 'Select_Remove_unique_ItemInternalId' contain an invalid reference to 'List_rows_present_in_a_table'. Correct to include a valid reference to 'List_rows_present_in_a_table' for the input parameter(s) of action 'Select_Remove_unique_ItemInternalId'. I was investigating a bit and it seems that the @ symbol in the formula might cause these issues; however, I am not sure if that's the case. Do you have any suggestions?

    • @tylerkolota
      @tylerkolota 23 дня назад

      @@monikk2777 Did you remove or rename a “List rows present in a table” action?

    • @monikk2777
      @monikk2777 20 дней назад

      @@tylerkolota I had renamed it to List rows before but now that you mentioned it, I changed it back, and now I get this error: The input parameter(s) of operation 'Read_the_excel_table_and_only_let_the_flow_run_if_no_edits_during_read' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'Read_the_excel_table_and_only_let_the_flow_run_if_no_edits_during_read'. I'm using the same formula you used: removeProperty( removeProperty( json(replace(string(item()), '@odata.etag', 'odataetag')), 'odataetag' ), 'ItemInternalId' )

    • @tylerkolota
      @tylerkolota 20 дней назад

      @ Is the expression greyed out? You may need to copy it, toggle the map format button on the right twice, & re-enter it in the expression tab.

    • @monikk2777
      @monikk2777 20 дней назад

      @@tylerkolota that worked! Thanks a lot Tyler!

  • @CraigBrown-wj5mk
    @CraigBrown-wj5mk 27 дней назад

    Absoultely great post mate! This is exactly what I was looking for and I really appreciate you taking the time to not only create the video, but to also create the downloads so we could import it easily to get it up and running.

  • @elijahd.spragueph.d8905
    @elijahd.spragueph.d8905 Месяц назад

    I've attempted to upload the V.1 file through legacy power automate import, I've entered my credentials under the Review Package Content. When I click the import I receive this error on the first step: Flow save failed with code 'InvalidPaginationPolicy' and message 'The pagination policy of workflow run action 'List_rows_present_in_a_table' of type 'OpenApiConnection' at line '1' and column '7554' is not valid. The value specified for property 'minimumItemsCount' exceeds the maximum allowed. Actual: '100000'. Maximum: '5000'.'.

    • @tylerkolota
      @tylerkolota Месяц назад

      @@elijahd.spragueph.d8905 You have a lower level license that only allows 5000 pagination on the Excel list rows action. Try version b of the flow import which uses Excel list rows in a loop that pulls in records in 5000 row increments drive.google.com/file/d/1_YDFzkf4QSAeloTv9_zxVuVQBAWlt8kf/view?usp=sharing

  • @nebiyubelete4903
    @nebiyubelete4903 Месяц назад

    Hello, sorry i canot find athe whole files while importing "TemplateProjectTrackerList" its only 6KB when download it. Can some body send me where i can find the whole three files under the zipfolder? txs

  • @AyurvedBenefitsHealthyLiving
    @AyurvedBenefitsHealthyLiving Месяц назад

    Hi, Can you tell me How to change the Date format , I have 3 dates that I want to change from ISO 8601 to MM/DD/YYYY ? Please help

    • @tylerkolota
      @tylerkolota Месяц назад

      @@AyurvedBenefitsHealthyLiving Have you tried the formatDateTime( ) expression?

    • @contreras408
      @contreras408 Месяц назад

      Here's what I did for Date: formatDateTime(items('Apply_to_each')?['Date'], 'MM/dd/yyyy') For time, in 12 hour AM/PM format ( e.g. 08:30 PM) I did this: formatDateTime(items('Apply_to_each')?['Time'], 'hh:mm tt') Just make sure to change the Apply to each and column header in each function to match your flow.

  • @JackDollarss
    @JackDollarss Месяц назад

    Can I setup a Flow in Power Automate Cloud to notify me every time whenever there is an error in Power Automate Desktop? If so then how can I achieve this?

    • @tylerkolota
      @tylerkolota Месяц назад

      @@JackDollarss If you aren’t using the PA Desktop flow inside a cloud flow & thus can’t use the template from the main post, then you can set a subflow in Power Automate Desktop to email you & then set the On Error of every action to trigger that subflow.

    • @JackDollarss
      @JackDollarss Месяц назад

      ​@@tylerkolota That's exactly what I did! I setup a Subflow to send an email which is working fine so far but the issue is that in the On Error settings I have set "Continue Flow" as well which continues even if the flow fails! So If the flow fails then it will first send the mail and then continues the flow! If the flow continues then it fixes it self (I have set it up that way according to my process) so sending an error mail becomes useless! That's why I want to setup in Cloud to set an email when an actual error occurs in PAD!

  • @meyo10240
    @meyo10240 Месяц назад

    Hi Mr.Tyler Kolota, can you make the video make a flow when a file excel on the onedrive is modified or created and sharepoint is automated updated? Thanks for your video

    • @tylerkolota
      @tylerkolota Месяц назад

      @@meyo10240 I think the solution package for this template includes a OneDrive example. Then you would just have to set up the Apply to each loops with SharePoint actions in them.

  • @mantisshrimp314
    @mantisshrimp314 Месяц назад

    Thanks for this video! I was struggling with rate limitations before seeing this.

  • @yashgandhi6128
    @yashgandhi6128 2 месяца назад

    Hey great video but what if i dont have primary key?

    • @tylerkolota
      @tylerkolota 2 месяца назад

      @@yashgandhi6128 Then you can only create items, not update them tachytelic.net/2021/06/power-automate-flow-batch-create-sharepoint-list-items/

  • @Rupasai-j5f
    @Rupasai-j5f 2 месяца назад

    Hello @tyler kudos for the work Can you please share the work flow zip file please not able to download for the link mentioned in description for create and update flow

    • @tylerkolota
      @tylerkolota 2 месяца назад

      I'm able to download the solution file from the link just fine on my laptop: drive.google.com/file/d/1UG3mj9Y-FCZ0ncCfUs3ucGZDdoiZJtgp/view?usp=sharing

  • @arianemedeirossantos4903
    @arianemedeirossantos4903 2 месяца назад

    Thank you very much, this is really fantastic. If I had an additional Value column and wanted to see a total label at the end, how would I sum all the items that appear in the gallery?

    • @tylerkolota
      @tylerkolota 2 месяца назад

      Are you talking about a Gallery in Power Apps? There is a way to reference AllItems for a gallery column & use the Sum( ) expression on it. www.crmonce.com/how-to-calculate-gallery-items-in-power-apps/

  • @arianemedeirossantos4903
    @arianemedeirossantos4903 2 месяца назад

    Thank you very much, this is really fantastic. If I had an additional Value column and wanted to see a total label at the end, how would I sum all the items that appear in the gallery?

    • @tylerkolota
      @tylerkolota 2 месяца назад

      Are you talking about a Gallery in Power Apps? There is a way to reference AllItems for a gallery column & use the Sum( ) expression on it. www.crmonce.com/how-to-calculate-gallery-items-in-power-apps/

  • @romaniadel5585
    @romaniadel5585 2 месяца назад

    Great Video I have duplicated the process for the "Apply to each" step to modify another column, but I'm encountering the following error: Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Modified_referencing_2' at line '1 and column '21598' is invalid. Action 'Apply_to_each_Modified' must be a parent 'foreach' scope of action 'Modified_referencing_2' to be referenced by 'repeatItems' or 'items' functions.

    • @tylerkolota
      @tylerkolota 2 месяца назад

      Do you have an expression somewhere with an items('Apply_to_each_Modified') reference outside the correct apply to each loop?

  • @nguyenmanhtuan1772
    @nguyenmanhtuan1772 2 месяца назад

    Downloaded and already success with my project. Thank you very much, you are my hero!!!

  • @japanlove8249
    @japanlove8249 2 месяца назад

    Tyler thank you for the amazing video, this does exactly what I want!!!

  • @Rob46
    @Rob46 2 месяца назад

    This was really helpful thank you! I need to update my list only where the id from the list matches the id from the excel. Could you or anyone advise how I can do this?

    • @tylerkolota
      @tylerkolota 2 месяца назад

      Hello, Were you not able to specify your id / primary key column names in the template flow & have it batch update based on the matches?

    • @Rob46
      @Rob46 2 месяца назад

      @@tylerkolota thanks for replying! I've managed to sort that issue out now - basically because it was an UPSERT and I just wanted it to an UPDATE so I just removed the UPDATE part. The latest challenge I've got is that I need to update based on the ID and also where another column in the SharePoint list equals let's say 'x'. This value isn't a look up into the excel but just a filter on the SharePoint list

    • @tylerkolota
      @tylerkolota 2 месяца назад

      @@Rob46 I would think you could go to the "Do until Get destination list IDs + keys" loop, add the relevant SP column to the "SharePoint HTTP Get items" select query, then add a Filter array action between the "Set variable LastID" and "Select IDs + Keys" actions to filter the SP records to just those where the relevant column = x, & adjust the "Select IDs + Keys" From input to use the Filter array outputs.

    • @Rob46
      @Rob46 2 месяца назад

      @@tylerkolota thanks I'll give that a go

    • @Rob46
      @Rob46 2 месяца назад

      @@tylerkolota got it to work! Thanks for your help 😃

  • @marek6995
    @marek6995 3 месяца назад

    Hello, could anyone please give me hints on how to modify this to update a dataverse table from an excel source ?

    • @tylerkolota
      @tylerkolota 2 месяца назад

      Hello, I do have a post on Dataverse batch actions here: community.powerplatform.com/galleries/gallery-posts/?postid=1ee689f5-81e0-4fb0-9155-a4387fc1598c Alternatively you may also be able to use Dataflows to connect Excel data to Dataverse: learn.microsoft.com/en-us/power-query/dataflows/sync-excel-cds-dataflow

  • @nikhilvalaboju1492
    @nikhilvalaboju1492 3 месяца назад

    Hey @Taylor This means a lot, helped me so much. What if I want to just upload items from excel to sharepoint? I don't want to update, or check if items already exist in sharepoint, I just want to create. How can I modify this flow ? Thank you again. :)

    • @tylerkolota
      @tylerkolota 2 месяца назад

      Hello, If you just want to batch create SharePoint items, then Paulie's original blog on Batch Create may be helpful: tachytelic.net/2021/06/power-automate-flow-batch-create-sharepoint-list-items/

  • @NicholasCoughlin-e2q
    @NicholasCoughlin-e2q 3 месяца назад

    I am so happy this exists. I was doing this the long and wrong way around for nearly 25,000 items. What was months of data entry has been reduced to minutes.

  • @ekoiswinarso
    @ekoiswinarso 3 месяца назад

    Hi, your works are very cool and impressive! 👍Wonder if we can add the pagination function on top of this, both on the Power Automate (with offset and limit) and Power App side so the data load can be reduced? I'm sure most of the users only want to search less than first 100 records to check?

    • @tylerkolota
      @tylerkolota 3 месяца назад

      @@ekoiswinarso the way this is designed, I don’t see paging reducing load times much on the Power Automate side. It still has to load all the items into the flow before it then applies the page cut-offs.

    • @ekoiswinarso
      @ekoiswinarso 8 дней назад

      Hi@@tylerkolota, are there some method on getting list data with combination of offset and limit in power automate, similiar with Odata filter?

    • @tylerkolota
      @tylerkolota 8 дней назад

      @@ekoiswinarso I gather offset & limit in Power Automate would refer to the Top count & Skip count. That’s the thing, the Excel connector / calls include both a Top & Skip, but the SharePoint connector / calls only include a Top parameter. To do something like a Skip in SP I think you need to actually make a call to SP, get the items, & take the ID of the last item to then in the next SP call get items where ID is greater than the previous last ID. The set up for this template doesn’t even use that type of set-up, instead it uses a faster method of concurrently pulling all items at once.

    • @tylerkolota
      @tylerkolota 8 дней назад

      @@ekoiswinarso There is an option to use pagination links, but the set-up requires a slower Do-until loop, just like the other slower ID method I mentioned. We want something that works with a faster, concurrent Apply to each loop. www.matthewdevaney.com/get-over-5000-items-from-a-sharepoint-list-in-power-automate/#Initialize-Variables-For-List-Items-and-SharePoint-URI

    • @ekoiswinarso
      @ekoiswinarso 7 дней назад

      Hi @@tylerkolota , very appreciate for your replies 👍😊. The "Skip" clue is very interesting, unfortunately it only works for Excel. And also yes, I already read that link. However, back to my requirement for pagination, I won't rely on ID at all since user will have capabilities to sort and search, thus the IDs will be randomly sort as the query result as well, not in ascending order anymore.

  • @birtukangizachew2792
    @birtukangizachew2792 3 месяца назад

    Super helpful!!! Will it work for a document library with multi-select choice fields?

    • @tylerkolota
      @tylerkolota 3 месяца назад

      It looks like multiple choice fields can be updated through HTTP calls with the following format: { "__metadata": { "type": "Collection(Edm.String)" }, "results": ["Choice1", "Choice2", "Choice3"] // Your choice values } So in the GenerateSPData Select action you would specify your multiple choice field name on the left side of the mapping, then on the right-side of the mapping for the value you would need to write a dynamic expression to output something like the above json. So you would likely form the above as a string in a concat( ) expression & then surround that concat with a json( ) expression, json(concat('{ "__metadata": { "type": "Collection(Edm.String)" }, "results":' **Insert expression to output a string-ified array of the multi-choice values for each item**, '}'))

    • @birtukangizachew2792
      @birtukangizachew2792 3 месяца назад

      Thank you so much! I will try this.

  • @jeevithavaranasi
    @jeevithavaranasi 3 месяца назад

    thanks for this video , i want to batch create list items , but the datasource here is a power bi dataset , used "run query against dataset" and "parsen json" and then the subsequent actions for batch create are not working for reason . can you help in this issue

    • @tylerkolota
      @tylerkolota 3 месяца назад

      What error(s) are you getting? How is it not working?

  • @powerbusinessdocconsulting9555
    @powerbusinessdocconsulting9555 3 месяца назад

    Your explanation and solution is very useful. Thanks for helping people to do things more efficient.

  • @martinsong4909
    @martinsong4909 3 месяца назад

    Hi Tyler, thanks for sharing this video, very helpful! The whole process met the requirements of my business project. However, there is one thing I need your helps based on this valuable video. Our current resource file is JSON format instead of the Excel file. So, is there any step I need to change for getting the email when the JSON file has been re-remodified or updates.??

    • @tylerkolota
      @tylerkolota 3 месяца назад

      If you are saying your main file you are checking for updates is itself a JSON file with a JSON array of records in it, then you will need to switch out all the Excel List rows actions with actions to get the file content of the JSON file & convert it into typed JSON like what I did for the previous table version JSON file in the "Get file content using path Last table version" & "Last table version" actions. Then use the output of those actions wherever the Values of the Excel List rows had been referenced.

  • @meierthomas
    @meierthomas 3 месяца назад

    Some work questions I you don't mind: * My table has about 30 columns and all 30 get put into the email. Where is the most logical spot to alter this so that I only add the 5 relevant columns into the email? * Secondly while the code works and sends emails for the rows that have changed (not using created or deleted) the HTML styling is not applied. I have double checked the CSS. Do I need to enable HTML anywhere else? * Do I have access to the old data? Say the ETA changes from 'date old' to 'date new'. Could I have both dates in the email notification?

    • @tylerkolota
      @tylerkolota 3 месяца назад

      @@meierthomas There is an option on the HTML table action to change from automatic to custom columns. If you change it to custom then you can add column names to the left side mapping & their corresponding expressions item()[‘InsertColumnName’] to the right side of the mapping.

    • @tylerkolota
      @tylerkolota 3 месяца назад

      @@meierthomas You can add a Filter array action on the previous version JSON where an array of modified primary keys contains the item primary key to get the previous values for modified records.

    • @tylerkolota
      @tylerkolota 3 месяца назад

      @@meierthomas I’m not sure what may be off on your styling after the HTML table

    • @meierthomas
      @meierthomas 3 месяца назад

      @@tylerkolota I have tried custom columns at the create HTML table step using the body from the previous step (Modified records) in the from field. The table content renders as item()['Ordered Date'] so it doesn't pick up the actual value. Looking at the execution the 'raw input' to Create HTML Table shows the data is there; i.e. { "from": [ { "Column1": "May Containers", "Ordered Date": "45337", "Warehouse": ".....", "Email": "......", "Payment Required ": "45398", "ETA": "45395", "Model": ".....O", "Ordered by": ".....", "PO No_x002e_2": "575", "Customer name": "......", "Sales Order No_x002e_": "SO009071", "Supplied": "0", "CIN": "2405-991", "ID": "mY885K" }, but the output doesn't pick up the data. Also I'm not able to enter <space bar> when I entered the header / value pairs; wouldn't accept item()['Ordered Date'], only item()['OrderedDate'] so I created the expression in a notepad and copied it into header / value

    • @meierthomas
      @meierthomas 3 месяца назад

      @@tylerkolotaDid some more research and found that GMail seems to be the issue. Works fine on Outlook

  • @ashishrawat8276
    @ashishrawat8276 3 месяца назад

    Sir i used your method to bulk update my flow ran successfully but i has updated 14216 records only, it skipped around 1104 records, is there any limit issue why it skipped but I didn’t get any error, please help

    • @tylerkolota
      @tylerkolota 3 месяца назад

      You may want to reduce your batch size & turn concurrency off on the Apply to each loops inside the Batch Update & Batch Create scopes

    • @ashishrawat8276
      @ashishrawat8276 3 месяца назад

      @@tylerkolota sir i have turned off the concurrency but it has increase my flow running time

    • @tylerkolota
      @tylerkolota 3 месяца назад

      @@ashishrawat8276 Yes, the issue with the skipped records is SharePoint may be overwhelmed with requests & not finishing some, so the flow needs to slow down & send the requests over more time. I can't do anything more about this trade-off. Thanks

  • @shinsvaka93
    @shinsvaka93 3 месяца назад

    For ~3250 row count tables and to get sub 10 second read time, I'm finding I have to decrease the batch size to a max of 250 with a max of 4 list row actions in the side of the Switch Device and branch by remainder action. When setting the batch over 250 It doesn't seem to actually pull all the rows in the table, which I thought was odd. Expected?

    • @tylerkolota
      @tylerkolota 3 месяца назад

      @@shinsvaka93 No that’s not expected

    • @shinsvaka93
      @shinsvaka93 3 месяца назад

      ​@@tylerkolota Understood, thanks for the reply. Should the mul(20000,... be changed depending on the table size? Looking at the outputs of the initial List rows in the Do until Get row count for batches loop, it seems like it doesn't actually return anything except the first row, the second do until loop doesn't give any value for the output?

    • @shinsvaka93
      @shinsvaka93 3 месяца назад

      Looks like since I didnt import it, I had to manually turn on pagination, since the Get Rows items were limited by default. Cant believe I didnt realize that was the issue.. Thanks for sharing the flow by the way, very helpful!

  • @MrCheddah13
    @MrCheddah13 3 месяца назад

    This is really amazing and I know it was posted awhile ago, is there a way to have the task thats created be tied to a project and not just a projectareas? Almost as if you were able to open the project card, add a task inside of it and it show up in the kanban board of tasks?

    • @tylerkolota
      @tylerkolota 3 месяца назад

      @@MrCheddah13 Are you saying like have a Kanban board of projects & then have various sub-Kanban boards for each project with all their tasks? I’d think there’s probably a way to do that by creating the sub-Kanbans where each item has a Lookup column to items in the main projects Kanban. Or if you still want all the items in the same Kanban, then it should be a similar set-up to the ParentGoals lookup column where the lookup is to all the items in the same Kanban board, so you would just create a ParentProject lookup column & in each task select the parent project card in that ParentProject column.

    • @MrCheddah13
      @MrCheddah13 3 месяца назад

      @@tylerkolota Thank you for the response Tyler, I think what I meant was the second half of your explanation. For example my current department is utilizing Notion's Project management template so I have a "page" that shows a list of all the projects (20+) with their varying properties as needed and it is its own database. On separate pages you have all of the tasks everyone is assigned too, each person has their own page, and the database of tasks is all one database separate from the projects database, the pages are just filtered per person. One of the properties inside the tasks is the option to select which project it belongs too. The way Notion handles this is by using a "relation" property and allows you to select the Project database to find the list of projects. While Notion has worked great, there is a separated half of our department that uses their own system for task tracking and I have been asked to combine the two departments using Sharepoint. I really appreciate you taking the time to respond!

    • @tylerkolota
      @tylerkolota 3 месяца назад

      @@MrCheddah13 Yeah so you would have all the projects & tasks on the same board & use a lookup column to link each task to their respective project. Then you’d probably want to add something, maybe a choice column with Praject or Task as options & set different SharePoint views to filter to only Project items or only Task items. And then people could also filter the Task view to only items where they are listed as Accountable or Responsible (or whatever roles/assignments you plan to use).

    • @MrCheddah13
      @MrCheddah13 3 месяца назад

      @@tylerkolota Thats really awesome! Ill give it a try tomorrow I really appreciate your time and creating this!

  • @monsourasai959
    @monsourasai959 3 месяца назад

    Can the trigger be changed to Scheduled?

    • @tylerkolota
      @tylerkolota 3 месяца назад

      Sure, the flow can use any trigger

  • @s1301950
    @s1301950 4 месяца назад

    how does power automate address pagination?

    • @tylerkolota
      @tylerkolota 4 месяца назад

      @@s1301950 You could add some parameters to the flow so it only returns x number of items between set page numbers/items. But personally I have yet to encounter a use-case where I’d have a user going page by page through results instead of refining their filters & search input to go directly to the item(s) they need.

  • @cat-si1et
    @cat-si1et 4 месяца назад

    If I want to search multiple values for a column, would I need to add a loop in the power automate flow? Or can I modify the odata query to filter a list of values?

    • @tylerkolota
      @tylerkolota 4 месяца назад

      @@cat-si1et Hm, I have not heard a use-case where someone wants to search two non-contiguous words/phrases before. But I would think you could edit the flow to check if there is a second search term, then use a Filter array query with an or( ) & 2 contains expressions.

  • @cat-si1et
    @cat-si1et 4 месяца назад

    I heard you can also use microsoft graph api to perform search. Would that approach be simpler compared to using power automate?

    • @tylerkolota
      @tylerkolota 4 месяца назад

      You can try that, but I believe it will be limited to search, as in you won't be able to combine searches with filters. And it uses the Office365Groups connector which at least in Power Automate is being replaces by a V2 which does not allow broader graph api queries. So I don't know how long it will be available for. ruclips.net/video/NJaHC5S9Cjo/видео.htmlsi=nMdsc1QRJ5pEqVpY

    • @cat-si1et
      @cat-si1et 4 месяца назад

      @@tylerkolota I see, the graph api is not really a sustainable way as of now. Thank you for the info! Love your work :)

  • @madhavilatha7881
    @madhavilatha7881 4 месяца назад

    Hi @tylerkolota , Thank you so much for this solution, it is so helpful. Here I am looking for sorting the text by top property along with the coordinates. My pdf documents are scanned tilted which is causing these not coming as expected, especially the tables. I appreciate your input on this.

    • @tylerkolota
      @tylerkolota 4 месяца назад

      @@madhavilatha7881 The template orders the text replica based on wherever the center of the text boxes are. I don’t have any further adjustments to help with a significantly tilted page on this template. However if you want you can try using a different method with premium HTTP actions to call GPT4o Mini’s image/vision component to extract from documents community.powerplatform.com/galleries/gallery-posts/?postid=73cdb790-11c9-45b7-80d0-b991d1f43f34

    • @madhavilatha7881
      @madhavilatha7881 4 месяца назад

      @@tylerkolota Thank you for the input. I checked the above approach but I may not be able to go with this approach because of the premium actions and Azure functions logic.

  • @saullazzarini4507
    @saullazzarini4507 4 месяца назад

    Hi Tyler, This is great! Do you know if this method would work with files and folders? Specifically copying them from one site collection library to another site collection library? Thank you!

    • @tylerkolota
      @tylerkolota 4 месяца назад

      This is specifically for SharePoint lists. I have yet to see any way to use this or a different api for SharePoint document library batch calls.

  • @sharagalino
    @sharagalino 4 месяца назад

    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. :(

  • @denniswarren5871
    @denniswarren5871 4 месяца назад

    Blog post is corrupt. Cannot download.

    • @tylerkolota
      @tylerkolota 4 месяца назад

      Microsoft started renovating their community site, they didn't transfer the upload files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from their support team. In the meantime, here is a Google drive link to a zip folder with solution imports for most of my projects: drive.google.com/file/d/1-hZmu2-QdEl7l95Y3NdZ1jn8sYdaK2kD/view?usp=sharing

  • @PritishTogare
    @PritishTogare 4 месяца назад

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

    • @tylerkolota
      @tylerkolota 4 месяца назад

      Microsoft started renovating their community site, they didn't transfer the upload files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from their support team. In the meantime, here is a Google drive link to a zip folder with solution imports for most of my projects: drive.google.com/file/d/1-hZmu2-QdEl7l95Y3NdZ1jn8sYdaK2kD/view?usp=sharing

    • @PritishTogare
      @PritishTogare 4 месяца назад

      @@tylerkolota Thank you so very much. I really appreciate you responding this quickly.

  • @parranoic
    @parranoic 4 месяца назад

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

    • @tylerkolota
      @tylerkolota 4 месяца назад

      Yes, they didn't transfer the upload files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from their support team. In the meantime, here is a Google drive link to a zip folder with solution imports for most of my projects: drive.google.com/file/d/1-hZmu2-QdEl7l95Y3NdZ1jn8sYdaK2kD/view?usp=sharing

    • @parranoic
      @parranoic 4 месяца назад

      @@tylerkolota You are amazing, truly thank you!

  • @asheerhasan5680
    @asheerhasan5680 4 месяца назад

    mind blowing but am unable to download the list and solution

    • @tylerkolota
      @tylerkolota 4 месяца назад

      Microsoft started renovating their community site, they didn't transfer the upload files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from their support team. In the meantime, here is a Google drive link to a zip folder with solution imports for most of my projects: drive.google.com/file/d/1-hZmu2-QdEl7l95Y3NdZ1jn8sYdaK2kD/view?usp=sharing

    • @asheerhasan5680
      @asheerhasan5680 4 месяца назад

      @@tylerkolota thanks a lot

  • @jairoveramendi6910
    @jairoveramendi6910 4 месяца назад

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

    • @tylerkolota
      @tylerkolota 4 месяца назад

      Microsoft started renovating their community site, they didn't transfer the upload files from the old site, & I can't manually re-upload any of the download files there at the moment. I'm waiting on a solution from their support team. In the meantime, here is a Google drive link to a zip folder with solution imports for most of my projects: drive.google.com/file/d/1-hZmu2-QdEl7l95Y3NdZ1jn8sYdaK2kD/view?usp=sharing

  • @napoleonmachine1117
    @napoleonmachine1117 4 месяца назад

    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.

    • @tylerkolota
      @tylerkolota 4 месяца назад

      Yes, with their forum renovation they have yet to include upload files on any old posts and it won't let me edit the old posts to try to manually re-upload the files either. While I'm waiting on support for a fix, here is a Google drive link to a zip folder with solution imports for most of my projects: drive.google.com/file/d/1-hZmu2-QdEl7l95Y3NdZ1jn8sYdaK2kD/view?usp=sharing

    • @napoleonmachine1117
      @napoleonmachine1117 4 месяца назад

      @@tylerkolota Microsoft likes to keep people "on their toes" lol. This is a great video, very detailed and a solid approach. Thank you.

  • @Alexm3-i8f
    @Alexm3-i8f 4 месяца назад

    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.