SharePoint Batch Update V1

Поделиться
HTML-код
  • Опубликовано: 4 дек 2024
  • Significant improvements have been made to this template since this video was made several years ago. Please visit the updated download & community forum page for the new version download & new video.
    Download & Community Forum Post: powerusers.mic...
    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 to a zip folder with solution imports for most of my projects: drive.google.c...
    New Video: • SharePoint Batch Updat...
    Version 1
    This demonstrates how to use SharePoint Batch API calls in Power Automate to quickly update thousands, hundreds of thousands, or millions of records in SharePoint while conserving Power Automate action API calls.
    Download & Community Forum Post: powerusers.mic...
    (New Version Now Available)
    Download The Template Batch Update Flow
    Google Drive Link to Flow Zip Files: drive.google.c...
    Google Drive Link to Text File to a Scope Action Containing The Flow: drive.google.c...
    TachyTelic.Net Blog & Videos
    Batch Create Flow
    Blog: www.tachytelic...
    Video: • How to use Power Autom...
    Batch Delete Flow
    Blog: www.tachytelic...
    Video: • How to quickly delete ...
    Formulas For Random Number Columns
    SharePoint Rand1To50 Column Calculated Default Value Formula:
    =INT(INT(RIGHT(NOW(),2))/2)
    Excel Random Column Formula:
    =ROUNDDOWN(((Rand()*100)+1)/2, 0)
    If the batch call succeeds, but individual rows fail to load to SharePoint, then the flow will not throw an error. I personally change out the Results Compose actions with Append to variable actions and use an expression that returns the results text if it identifies an error. Then at the end of the flow I have a condition checking the length of that variable. If it has some text/length to it, then something failed and it sends me an email with a link to the flow run.
    **LISTS WITH UNDERSCORES _ IN THE TITLE MAY CAUSE ERRORS WITH EARLIER VERSIONS OF BATCH ACTIONS.**
    If you have a list with underscores in the name, then in TachyTelic.Net's batch create you will want to go to the __metadata line on the GenerateSPData select action and substitute the expression
    json(concat('{"type":"SP.Data.', replace(outputs('settings')['listName'], ' ', '_x0020_'), 'ListItem"}'))
    for
    json(concat('{"type":"SP.Data.', replace(replace(outputs('settings')['listName'], '_', '_x005f_'), ' ', '_x0020_'), 'ListItem"}'))
    Venmo
    venmo.com/u/Ty...
    PayPal
    www.paypal.com...
    Buy Me a Coffee
    www.buymeacoff...
    Thanks for any feedback,
    And reach out on LinkedIn ( / kolota ) if you want to hire me to consult or build more custom Microsoft solutions for you.

Комментарии • 72