kalmstrom.com
kalmstrom.com
  • Видео 619
  • Просмотров 9 948 623
Automate Recurring Tasks in Excel 4 - Create Powerapp
Create a powerapp for the tasks that are due today and that have not yet been finished: www.kalmstrom.com/Tips/Excel-Automation/Recurring-Tasks-PowerApp.htm
Просмотров: 69

Видео

Automate Recurring Tasks in Excel 3 - GenerateTask ID
Просмотров 619 часов назад
Add another column to the Excel table for today's tasks and let the script create an ID for each task. The milisecond that the task was created in the Tasks table is used as the ID value: www.kalmstrom.com/Tips/Excel-Automation/Recurring-Tasks-ID.htm
Batch Import of Excel Data to SharePoint List
Просмотров 7714 часов назад
Create an app with Excel data with the PNP.PowerShell Batch functionality. Use the Excel Fill feature to quickly get multiple lines of code for 1500 items. Refer to www.kalmstrom.com/Tips/PowerShell-SharePoint/992-Small-Bussiness-Intranet-3-Apps-Batch-Content-PowerShell-SharePoint.htm for steps.
Automate Recurring Tasks in Excel 2 - Schedule Script Running from Excel
Просмотров 26821 час назад
The Schedule Script feature in Excel creates a Power Automate flow that runs the workbook's script on a schedule: www.kalmstrom.com/Tips/Excel-Automation/Recurring-Tasks-Schedule.htm
Automate Recurring Tasks in Excel 1 - Script
Просмотров 12321 час назад
Peter Kalmström uses the Office Scripts automation features in Excel for recurring tasks management. The solution he starts building here, will be expanded in later demos: www.kalmstrom.com/Tips/Excel-Automation/Recurring-Tasks.htm
Use the PowerShell Batch Functionality for SharePoint App Items
Просмотров 59День назад
Create a new SharePoint app and add items using the Batch functionality in PowerShell v7: www.kalmstrom.com/Tips/PowerShell-SharePoint/992-Small-Bussiness-Intranet-3-Apps-Batch-PowerShell-SharePoint.htm
Create a Classic Tasks List in a Modern Communication Site
Просмотров 7514 дней назад
Activate the Team Collaboration Lists feature and use classic list templates in a modern SharePoint Online Communication site: www.kalmstrom.com/Tips/SharePoint-Online-Course/Helpdesk-Tasks-List-in-Communication-Site.htm
Set up Visual Studio Code for scripting with PowerShell v7.
Просмотров 12521 день назад
Install PowerShell version 7 and VS Code and set up Visual Studio Code for PowerShell scripting and use with SharePoint: www.kalmstrom.com/Tips/PowerShell-SharePoint/010-Intro-PowerShell-SharePoint.htm
Use the Excel Automate Tool to Create a Refresh Script by Recording
Просмотров 14921 день назад
Peter Kalmström introduces the Excel Automation feature. He shows how to record a Refresh All action with the Action Recorder to get a script and a button that performs this action. He also explains how you can work directly with TypeScript code in the Code Editor. www.kalmstrom.com/Tips/Excel-Automation/Action-Recorder.htm
Create Mockups in PowerPoint with Storyboarding
Просмотров 120Месяц назад
Peter Kalmström shows how to get the free Storyboarding feature that is available for PowerPoint and how to use the Storyboard shapes to create mockups for describing or brainstorming app projects. Refer to www.kalmstrom.com/Tips/PowerPoint/Storyboard.htm. The Storyboarding download link can be found at answers.microsoft.com/en-us/msoffice/forum/all/how-can-i-get-storyboarding-option-on-my/f241...
Embed a Powerapp in Teams
Просмотров 2,2 тыс.Год назад
Add an app created in Power Apps to a Teams channel tab: www.kalmstrom.com/Tips/Power-Apps/Embed-Teams.htm
Embed a Powerapp in a modern SharePoint page:
Просмотров 11 тыс.Год назад
Use the Power Apps web part to add an app to a modern SharePoint page: www.kalmstrom.com/Tips/Power-Apps/Embed-SharePoint.htm
Power Apps Survey from SharePoint Data 6: Mood Selector
Просмотров 4,1 тыс.Год назад
The last demo in a series that describes how to create a survey connected to SharePoint in Power Apps: www.kalmstrom.com/Tips/Power-Apps/SharePoint-PowerApps-Survey-6.htm
Power Apps Survey from SharePoint Data 5: Pie Chart Progress Indicator
Просмотров 1,8 тыс.Год назад
The fifth demo in a series that describes how to create a survey connected to SharePoint in Power Apps: www.kalmstrom.com/Tips/Power-Apps/SharePoint-PowerApps-Survey-5.htm
Power Apps Survey from SharePoint Data 4: Progress Bar
Просмотров 2 тыс.Год назад
Create a progress bar in the survey UI, so that respondents can see how many questions have been answered and how many remain: www.kalmstrom.com/Tips/Power-Apps/SharePoint-PowerApps-Survey-4.htm
Power Apps Survey from SharePoint Data 3: Slider
Просмотров 2,5 тыс.Год назад
Power Apps Survey from SharePoint Data 3: Slider
Power Apps Survey from SharePoint Data 2: App User Interface
Просмотров 6 тыс.Год назад
Power Apps Survey from SharePoint Data 2: App User Interface
Power Apps Survey from SharePoint Data 1: get questions as column names into a SharePoint list.
Просмотров 4,1 тыс.Год назад
Power Apps Survey from SharePoint Data 1: get questions as column names into a SharePoint list.
Modify SharePoint Form in Power Apps
Просмотров 2,3 тыс.Год назад
Modify SharePoint Form in Power Apps
Migrate Excel Data to SharePoint
Просмотров 1,2 тыс.Год назад
Migrate Excel Data to SharePoint
Power Apps Buttons for Remove All and Remove Selected
Просмотров 7 тыс.Год назад
Power Apps Buttons for Remove All and Remove Selected
Create a Power Apps Remove button
Просмотров 4,1 тыс.Год назад
Create a Power Apps Remove button
Create New SharePoint List Items from a Powerapp: Batch
Просмотров 998Год назад
Create New SharePoint List Items from a Powerapp: Batch
Create New SharePoint List Items from a Powerapp: Patch
Просмотров 8 тыс.Год назад
Create New SharePoint List Items from a Powerapp: Patch
Create New SharePoint List Items from a Powerapp: Form
Просмотров 7 тыс.Год назад
Create New SharePoint List Items from a Powerapp: Form
Recurring Tasks Dataverse App 4 - Canvas App
Просмотров 368Год назад
Recurring Tasks Dataverse App 4 - Canvas App
Recurring Tasks Dataverse App 3 - Model-Driven App
Просмотров 994Год назад
Recurring Tasks Dataverse App 3 - Model-Driven App
Dataverse-Excel Roundtripping
Просмотров 279Год назад
Dataverse-Excel Roundtripping
Recurring SharePoint Tasks Powerapp, 5: Instructions screen
Просмотров 681Год назад
Recurring SharePoint Tasks Powerapp, 5: Instructions screen
Recurring SharePoint Tasks Powerapp, 4: Add Search to the powerapp
Просмотров 395Год назад
Recurring SharePoint Tasks Powerapp, 4: Add Search to the powerapp

Комментарии

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

    Is this required Microsoft Enterprise E3 or E4 license since I only got Microsoft 365 E3 and was not able to find it ? Thanks

    •  17 минут назад

      I usually do my demos with an E3 license, so the file viewer web part should be there.

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

    This is a separate question from this video. Do you know how to automate reset Microsoft Planner without manually unchecking everything.

    •  9 дней назад

      Sounds like a very good topic for another video. Watch this space ...

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

    Is this possible with Sharepoint Online? I am not able to create a Task List. Nor do I see the ablility to connect a custom list to outlook. I can only do so for calendars.

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

    I would like to know if you have a tutorial on how to place a calendar in sharepoint and be able to see the room resources created in O365 and be able to see the availability of the rooms from an online sharepoint site. thanks again.

    •  20 дней назад

      That should be quite possible to do with the Graph APIs and a lot of code, but it is way beyond the scope of a tutorial regretfully.

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

    How to implement same thing with power automate?

    •  Месяц назад

      Excellent idea for a new video. Added to my ToDo list.

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

      Thanks 👍

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

    Thank you for saving my time

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

    How to do this without using the SharePoint pnp powershell online module

    •  Месяц назад

      There are so many different ways to upload files to SharePoint. Please let me know more about your requirements and environment.

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

      I just need them to upload it from my local server file explorer download folders to SharePoint document library by using powershell but without downloading the pnp module and using csom assemblies

  • @user-bo9lh7se1s
    @user-bo9lh7se1s 2 месяца назад

    Good

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

    I do need a mood selector based on images, but instead of saving numbers to the sharepoint list, we already have 5 different mood option available: 5. Fantastic 4. Good 3. Neutral 2. Bad 1. Very Bad. Is this possible?

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

    0:14

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

    i liked the SparKline in the middle

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

    It would have been so much better if it checks the file out automatically when anyone opens it, and checks back in when you close it

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

    This is amazing. Thank you.

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

    I have tried and tried to get the dates to autofill in the blocks for the days of the month but it is not working I have tried to do the control shift and left arrow but it does not work for me. What am I doing wrong? HELP

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

    Thank You, it works!!

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

    Thank you!! I have been looking for this “how to” for so long!!

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

    I dont have excel web access in business data folder I have IT confirming office online 365 uodated version and excel permission Kindly help Thanks

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

    Can we add more than one chart in same page to get a dashboard with multiple charts? appreciate your feedback. Many Thanks

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

    Nice vid! I believe if you open the app to edit mode, and use the share button...you can get a url that will work in the web part. I have a SharePoint integrated form in landscape mode and unfortunately, the window is extremely small when added to a single column section. I hope Microsoft fixes this!

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

      Thank you for the clarification about the Share URL. Yes, sizing is tricky indeed.

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

    Very useful one. Thanks for the demonstration.

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

      Glad you liked it!

  • @user-bd8bq1wl6d
    @user-bd8bq1wl6d 3 месяца назад

    Nice video! So if people don't have access to the app, but do have access to SP, they will not be able to see the app? how would it look on their end?

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

      I have not actually tried it - please do and let us know the results. Hopefully that web part is simply ignored when the user doesn't have permissions.

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

    I am not able to see that email settings under advanced settings

  • @user-me8xb1wi5g
    @user-me8xb1wi5g 4 месяца назад

    I have the /e/ in the PowerApp URL for the environment GUID but no 'a'. I have .. %2Fapps%2 followed by a GUID at the end but it did not work. It is a canvas app. Is it a problem if this is a developer environment? Maybe I need to get a third environment setup. ??

    • @user-bd8bq1wl6d
      @user-bd8bq1wl6d 3 месяца назад

      you can access the GUID by going into the power apps home page > my apps > hit on the ellipsis for your app > click on details

  • @aravindcheerla3768
    @aravindcheerla3768 5 месяцев назад

    Thanks Peter ,This video helped me a lot even after 9 years this video is helping someone like me .One doubt in this how to remove/hide ribbon actions ?

    •  5 месяцев назад

      You are very welcome. I have not worked with this much in the years in between but I think you can just press the delete button on your keyboard to remove the selected ribbon button.

    • @aravindcheerla3768
      @aravindcheerla3768 5 месяцев назад

      ​@Thanks for the Superfast reply .

  • @aprilrosedolorfino2760
    @aprilrosedolorfino2760 5 месяцев назад

    Helpful thank you so much good bless you❤

  • @divyarathnakar4245
    @divyarathnakar4245 5 месяцев назад

    Unable to Authenticate with Connect-pnpOnline. It shows some multifactor authentication related error

  • @sekirokingcypher6792
    @sekirokingcypher6792 5 месяцев назад

    thanks to msft they changed teh screen and now i cant find services and addins

  • @japert00
    @japert00 5 месяцев назад

    Thank you very much for this. I ve been playing with some automations for my area and wanted to know how to implement the power apps to the sharepoint page of my team

    •  5 месяцев назад

      Glad you liked it. Good luck with your implementation!

  • @user-fj8es1of1m
    @user-fj8es1of1m 5 месяцев назад

    What about folder structures within a site? It's all well & good when you have a clean slate to work with but when you inherit a pile of crap that someone else set up 10 years ago, you have to cherry pick pieces of a single site to tidy it up first. I have about 90% of a 'site' under a folder called 'Documents' and the whole site is under a retention policy, but I want to delete a few dozen 'folders', each with nested folders. The whole site is a few Terrabytes big.

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

    Thank you!

  • @qwertyuiop12335
    @qwertyuiop12335 6 месяцев назад

    hi how about when the user resubmit again for approval using the same id?

  • @jerusalem7050
    @jerusalem7050 6 месяцев назад

    Short and sweet! Thank you

    •  6 месяцев назад

      Glad you liked it!

  • @debbieironside-smith515
    @debbieironside-smith515 6 месяцев назад

    Super easy to follow - thank you for making this - the best one I have found! 😀

  • @user-lr8ux8gd3j
    @user-lr8ux8gd3j 6 месяцев назад

    Hi there. Any suggestions or ideas as to why the chart will not load or become visible unless the user moves their cursor over the chart web part area?

  • @michaellussem1777
    @michaellussem1777 7 месяцев назад

    Hi, thank you for this video. Can you say something about what is happening behind the scenes? Is the patch using the batch-API because of patching a collection, or is each element patched with a own API-call? I am looking for a nice solution for adding 20K items each day and want to reduce API-calls by using the batch-API

  • @Bhojpurisongs12393
    @Bhojpurisongs12393 7 месяцев назад

    Thank you

  • @austingoricki8324
    @austingoricki8324 7 месяцев назад

    how do I hide from the list only in PowerApp not the SharePoint list using a button like this?

  • @maddiebeatz98
    @maddiebeatz98 7 месяцев назад

    What could I do if I wanted to have customers input their own reservation and then I approve it ?

  • @Thebluediamoundvision831
    @Thebluediamoundvision831 7 месяцев назад

    I can't get Feb correct. The dates are not aligned

  • @youdagoob
    @youdagoob 8 месяцев назад

    Are these feeds available for public consumption? Or only to those logged into their Microsoft ecosystem?

  • @Kreemerz
    @Kreemerz 8 месяцев назад

    What about Plan 1?

  • @user-vl6jv9kw5u
    @user-vl6jv9kw5u 8 месяцев назад

    Very well explained. Thank you

    • @kalmstrom
      @kalmstrom 8 месяцев назад

      Glad you liked it 🙂

  • @jeffhenning8335
    @jeffhenning8335 9 месяцев назад

    Great video series, Peter! This helped a lot. I've changed my wizard to use Radio choices using this method. I have however, a survey with 274 columns/cards. Is there a way to re-use a custom data card as a template for all the other data fields added? It's pretty annoying to have to change every single one by hand. I tried just copying a card and changing it's data field, but that is apparently not allowed.

    •  9 месяцев назад

      Hi Jeff, Glad you liked it! Your question is a good subject for another video.

  • @felipeabajo
    @felipeabajo 9 месяцев назад

    Thank you!

  • @justj518
    @justj518 9 месяцев назад

    get to the f'ing point

    •  9 месяцев назад

      Sorry to have wasted your time ...

  • @mustafamousahassan6470
    @mustafamousahassan6470 9 месяцев назад

    Thank you for your informative and helpful video! :) I've received alerts indicating that a significant amount of data was downloaded or altered within the past two days. However, I was not involved in any such activity, and there were no changes made by me or any suspicious activity detected on my computer. Could these alerts be false or a result of a hacking attempt? Could these changes have occurred due to some coincidence, which looks improbable, considering that these changes on such a significant volume of files would have taken considerable time to process? Thanks once again.

    •  9 месяцев назад

      I doubt this worklfow has anything to do with the warnings you have received. Good luck!

    • @mustafamousahassan6470
      @mustafamousahassan6470 9 месяцев назад

      @ Maybe..These warnings say it’s coming from my IP address and my account. Thank you for the info. 😊

  • @halleshwar
    @halleshwar 9 месяцев назад

    Can we make the links open in the same tab, like if I want a link put in ppt to navigate to another section in the same page, is there a way this can be done

  • @nhrony1
    @nhrony1 9 месяцев назад

    How does this feature operate within the latest Outlook application?

  • @9999EFI
    @9999EFI 9 месяцев назад

    Awesome video. Thanks for sharing!

    •  9 месяцев назад

      Most welcome 🙂

  • @nurulsyazana5070
    @nurulsyazana5070 9 месяцев назад

    IT'S WORKED !! THANKS SIRR

    •  9 месяцев назад

      Glad to hear it 🙂