TW-Waytek

Hi, I’m Tyler Wasson, and welcome to TW-Waytek, the place where I teach, test, and review “Way Cool Tech”.

[TW-Waytek @TW_Waytek]

In this post, we’ll walk through how to create a custom Project Tracker application using Model-Driven Apps in Microsoft Power Apps, with a focus on using Dataverse as the backend.

See link for more details:
https://t.co/FJ4hErHjYS

#PowerApps #Dataverse #ModelDriven Apps

[TW-Waytek @TW_Waytek]

In this blog post, I’ll show you how to automatically save a PDF to a SharePoint Document Library and populate its metadata using Power Automate.

See link for more details:
https://t.co/NqY2iPhb5Z

#PowerAutomate #SharePoint #JSON

[TW-Waytek @TW_Waytek]

This post goes into the difference between Group Chats and Channels within the Microsoft Teams platform.

Click here:
https://t.co/uvlkJ61BeM

[TW-Waytek @TW_Waytek]

Deploy Microsoft Fabric Capacity to a Power BI Workspace Using Azure

This post provides a step-by-step walkthrough on how to set up Fabric capacity using the Azure Portal and assign that capacity to a Power BI workspace.

Use this link:
https://t.co/WuIDjXY1Ge

[TW-Waytek @TW_Waytek]

In this post, I will demonstrate how to view the SharePoint User Lookup field in Power BI Reports with two examples.
1.Update Existing Table
2.Connect to Users Table

Use this link:
https://t.co/Jl27elzEaq

#PowerBI #SharePoint #PowerPlatform

[TW-Waytek @TW_Waytek]

In this post I’ll show you how to keep your Power BI dataset automatically refreshed with the latest data. Exploring both options Power BI provides for refreshing your data, manual refresh and automatic.

Use this link:
https://t.co/LKUXJ6GzF1

#PowerBI #PowerBIRefresh

[TW-Waytek @TW_Waytek]

In this post, I will walk through how to create interactive reports in Power BI that connect directly to a SharePoint List.

Use this link:
https://t.co/IKNe71vryY

#PowerBI #SharePoint #PowerPlatform #ProjectReporting

[TW-Waytek @TW_Waytek]

In this post, I’ll explain how to use Microsoft Lists (also known as SharePoint Lists) to track projects. This application offers a blank canvas that’s fully customizable, easy to setup, and simple to maintain.

Use this link:
https://t.co/t3LCEU6sWh

#Microsoft365 #SharePoint

[TW-Waytek @TW_Waytek]

In this post I will walk through five practical enhancements that improve a Vacation Trackers functionality.

Use this link:
https://t.co/vsaBqzV1MC

#SharePoint #MicrosoftLists #PowerAutomate #Microsoft365 #VactionalTracker

[TW-Waytek @TW_Waytek]

In this post, I show you how to automate running a daily Power BI report, exporting the data to an Excel file, and saving the Excel file to a SharePoint document library.

Use this link:
https://t.co/nb0LZoH4jC

#PowerBI #PowerAutomate #SharePoint #Excel #Automation

[TW-Waytek @TW_Waytek]

In this post, I’ll show you how to export 100k rows of filtered data from SharePoint into a CSV-file automatically

Use this link;
https://t.co/pheKhFHi1v

#technology #SharePoint #Power Automate #Microsoft

[TW-Waytek @TW_Waytek]

Connect Dataverse to SSMS in Minutes!

Click below for step-by-step instructions on how to connect Microsoft Dataverse to SQL Server Management Studio (SSMS). in minutes.

https://t.co/PsUeiICZhD

#microsoft #dataverse #ssms #sqlservermanagementstudio

[TW-Waytek @TW_Waytek]

Learn how to import 100,00 rows x 56 columns (5.6M data points) into SharePoint using Power Automate.

Use this link:
https://t.co/9kY3wdUcxv

#Excel #SharePoint #PowerAutomate #Microsoft

[TW-Waytek @TW_Waytek]

Built a team vacation tracker using Microsoft Lists + SharePoint—then integrated into Teams. Inspired by a manual Excel tracker at Microsoft, I created a smarter, low-maintenance solution.

Use this link:
https://t.co/tMUqlFwgCP

#PowerAutomate #Excel #SharePoint #Microsoft

[TW-Waytek @TW_Waytek]

This post will show you how to create a Power BI Date Table for both calendar and fiscal years using the same data.

Use this link:
https://t.co/d5pZXIE3XS

#PowerBI #DataTable #Microsoft #Calender

[TW-Waytek @TW_Waytek]

In this post, you’ll learn how to build offline Power Apps that can store data and images locally when there is no internet connection. Once the device reconnects, the app automatically syncs to SQL Server and uploads images to Azure Blob Storage.

https://t.co/69SZBnyoqM

[TW-Waytek @TW_Waytek]

At Microsoft, I used Power Query in Excel to link notes to SQL Server inventory data from Azure Capacity Planning—keeping notes synced even after refreshes, filters, or sorts.

Use this link:
https://t.co/3xhBkLkwOX

#Excel #Power Query #SQL Server #Microsoft

[TW-Waytek @TW_Waytek]

How to set up a Data Gateway in Power Automate using a Premium Power Automate subscription. It enables secure access to on-premises data from the cloud.

Use this link:
https://t.co/soCm0sFnnp

#Power Automate #PowerApps #Data Gateway #Microsoft

[TW-Waytek @TW_Waytek]

In this post, we’ll walk through how to set up a Scheduled Cloud Flow in Power Automate that pulls data from a cloud source using an HTTP request, parse the JSON response, and insert the data in a local SQL Server database.

Use this link:
https://t.co/uGxWX3BVrl

[TW-Waytek @TW_Waytek]

At Microsoft, I used SQL data from Azure tools to track server rack movements and built a Power Query solution in Excel that kept notes synced with inventory items—even after refreshes, filters, or sorts.

Use this link to see my latest post:
https://t.co/3xhBkLkwOX