Microsoft Excel, O365, Power Apps, Power Automate, Power BI
In this post, I am going to show you how I can send an email to each person in my mailing list, ask them to make a selection, and collect their response.
Continue reading “Power Automate to ‘Send Email with Options’”
In this post, I am going to show you how I can identify new or recently removed members in a 365 Group.
Continue reading “Power Automate to monitor group membership”…my cage, however, is that my organization invests into systems that support the student life cycle. Systems which support staff are very often de-prioritized, lost in the enterprise queue.
Today I would like to present my contribution to “Better Together” and how the Power Platform / Dynamics products work better together.
Continue reading “I went to work every day prepared to die in a tiger cage…”
In this post, I am going to show you how I monitor a shared mailbox while working from home.
Continue reading “Power Automate to monitor a shared mailbox”Today I earned the Super User 2020 – Season 1 badge in the Power BI Community forums. Check out my profile @ Microsoft Power BI Community > Forums > About ChrisMendoza.
Most of what I have learned has been from this Community. There are some terribly smart folks out there that are willing to share their knowledge with you. Check out the community @ https://community.powerbi.com/ .
In this post, I am going to discuss an option for creating a dynamic filepath for use as a Source in an Excel to Power Query connection.
Continue reading “Create a Dynamic Filepath for Power Query Connections”In this post, I am going to show you how to lock and unlock cells using Conditional Formatting and VBA.
Continue reading “Locking & Unlocking Cells in a Range”In this post, I am going to show you how to delete Excel table rows based on criteria using VBA.
Continue reading “Delete Table Rows using VBA”In this post, I am going to show you how to complete a mail-merge from an Excel table to Microsoft Word.
Continue reading “Mail-Merge Excel to Word”In this post, I am going to show you how to prepare a data set for a mail-merge using Power Query.
Continue reading “Mail-Merge Data Preparation”