- Видео 21
- Просмотров 210 729
Tyler Kolota
Добавлен 2 май 2014
Power Platform Development & Process Improvement
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...
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 950
Видео
Read Excel 5X Faster - Power Automate
Просмотров 1,7 тыс.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)
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
How did you get the ID for each items?
@@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.
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
@@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?
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?
@@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.
Can’t seem to get this working. Any insights you can share ? Thanks. Dave
@@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
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.
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.
@@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']])))"
Thank sir
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?
@@monikk2777 Did you remove or rename a “List rows present in a table” action?
@@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' )
@ 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.
@@tylerkolota that worked! Thanks a lot Tyler!
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.
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'.'.
@@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
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
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
@@AyurvedBenefitsHealthyLiving Have you tried the formatDateTime( ) expression?
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.
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?
@@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.
@@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!
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
@@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.
Thanks for this video! I was struggling with rate limitations before seeing this.
Hey great video but what if i dont have primary key?
@@yashgandhi6128 Then you can only create items, not update them tachytelic.net/2021/06/power-automate-flow-batch-create-sharepoint-list-items/
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
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
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?
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/
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?
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/
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.
Do you have an expression somewhere with an items('Apply_to_each_Modified') reference outside the correct apply to each loop?
Downloaded and already success with my project. Thank you very much, you are my hero!!!
Tyler thank you for the amazing video, this does exactly what I want!!!
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?
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?
@@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
@@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.
@@tylerkolota thanks I'll give that a go
@@tylerkolota got it to work! Thanks for your help 😃
Hello, could anyone please give me hints on how to modify this to update a dataverse table from an excel source ?
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
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. :)
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/
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.
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?
@@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.
Hi@@tylerkolota, are there some method on getting list data with combination of offset and limit in power automate, similiar with Odata filter?
@@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.
@@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
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.
Super helpful!!! Will it work for a document library with multi-select choice fields?
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**, '}'))
Thank you so much! I will try this.
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
What error(s) are you getting? How is it not working?
Your explanation and solution is very useful. Thanks for helping people to do things more efficient.
Thank you!
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.??
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.
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?
@@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.
@@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.
@@meierthomas I’m not sure what may be off on your styling after the HTML table
@@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
@@tylerkolotaDid some more research and found that GMail seems to be the issue. Works fine on Outlook
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
You may want to reduce your batch size & turn concurrency off on the Apply to each loops inside the Batch Update & Batch Create scopes
@@tylerkolota sir i have turned off the concurrency but it has increase my flow running time
@@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
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?
@@shinsvaka93 No that’s not expected
@@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?
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!
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?
@@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.
@@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!
@@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).
@@tylerkolota Thats really awesome! Ill give it a try tomorrow I really appreciate your time and creating this!
Can the trigger be changed to Scheduled?
Sure, the flow can use any trigger
how does power automate address pagination?
@@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.
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?
@@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.
I heard you can also use microsoft graph api to perform search. Would that approach be simpler compared to using power automate?
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
@@tylerkolota I see, the graph api is not really a sustainable way as of now. Thank you for the info! Love your work :)
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.
@@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
@@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.
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!
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.
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.
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
Great video for beginners. I cant find the zip file on the link though. plz help
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
@@tylerkolota Thank you so very much. I really appreciate you responding this quickly.
Thank you! Any chance you can re upload the zip ? Microsoft nuked their community site this week
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
@@tylerkolota You are amazing, truly thank you!
mind blowing but am unable to download the list and solution
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
@@tylerkolota thanks a lot
hi, i dont see the zip packege. How could I download it?
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
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.
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
@@tylerkolota Microsoft likes to keep people "on their toes" lol. This is a great video, very detailed and a solid approach. Thank you.
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?
Microsoft recently renovated their community forum and have yet to transfer file uploads for old posts. And it also won't let me edit the posts to try to manually add the files back. While I'm waiting for a fix, I created a link to a zip folder on my Google drive that includes the imports for most of my projects: drive.google.com/file/d/1-hZmu2-QdEl7l95Y3NdZ1jn8sYdaK2kD/view?usp=sharing
Hello, how do I find the zip file?
Microsoft started renovating their community site & I can't re-upload any of the download files there at the moment. 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
@@tylerkolota Thank you so much for the quick response. I am going to try to set up my teams project channel today.
Hello! The downloadable packages are missing on the referenced page. Is there another way to download the flow templates?
Microsoft is renovating their community forums. I'm not sure if the page they moved my stuff to even has file uploads and I'm unable to edit the posts. I'll need to figure something else out, but in the meantime, email me at takolota@gmail.com with what templates you want the solution packages for.
Here is a google drive link to a zip folder with the solution package import for most of my projects: drive.google.com/file/d/1-hZmu2-QdEl7l95Y3NdZ1jn8sYdaK2kD/view?usp=sharing
@@tylerkolota Thank you very much! Appreciated!