Tag Archives: microsoft
Drop Down List Filter Question
So I used a filter function formula to filter data based on specific category or vendor name like so:
However, what I realized is that what this filters is readable data not editable data. If I wanted to edit the data I would have to go to a different tab where the table resides and make the necessary changes which will automatically update when going back to the readable data tab like I showed in the image above.
My question is, is there a way to use a drop down list to directly filter a table that way I would be able to edit and filter my table in the same tab? Like this for example which I photoshoped together:
So if there is something I can put in the actual Filter function formula that can make what I’m asking work that maybe you excel experts might know and tell me that would be great. By the way this is my filter function formula: =FILTER(FilterTest,(FilterTest[Category]=L3)+(FilterTest[Vendor]=L4),””).
Although if its not possible using the filter function formula maybe you excel experts might have a tutorial video link that I can watch that will help me with trying to solve this problem.
I’ve spent days and hours trying to find videos or forums but I have had no luck.
Thank you and I look forward to your help
So I used a filter function formula to filter data based on specific category or vendor name like so:However, what I realized is that what this filters is readable data not editable data. If I wanted to edit the data I would have to go to a different tab where the table resides and make the necessary changes which will automatically update when going back to the readable data tab like I showed in the image above. My question is, is there a way to use a drop down list to directly filter a table that way I would be able to edit and filter my table in the same tab? Like this for example which I photoshoped together: So if there is something I can put in the actual Filter function formula that can make what I’m asking work that maybe you excel experts might know and tell me that would be great. By the way this is my filter function formula: =FILTER(FilterTest,(FilterTest[Category]=L3)+(FilterTest[Vendor]=L4),””). Although if its not possible using the filter function formula maybe you excel experts might have a tutorial video link that I can watch that will help me with trying to solve this problem. I’ve spent days and hours trying to find videos or forums but I have had no luck. Thank you and I look forward to your help Read More
IS THERE A WAY TO AUTO COUNT THE DAYS IN B EVERYTIME IT IS OPENED?
FOR EXAMPLE, IF I OPEN IT 3 DAYS FROM NOW COLUMN B WOULD READ 484?
FOR EXAMPLE, IF I OPEN IT 3 DAYS FROM NOW COLUMN B WOULD READ 484? Read More
Nested Dynamic Filtering on web parts does not work
I created a Sharepoint page and added an MS list web part, which I use as a “filter” selection. Then, I added a second MS list to display the main list of content items, configured with Dynamic filtering based on selecting the “filter” list.
Then, I added a Document library web part, which is again configured with Dynamic Filtering based on the selection of the second content item list.
Unfortunately, when you select an item from the “filter” list and then select an item from the second “content” list, the document library does not update based on the selection.
HOWEVER..
If I select an item from the second “content” list without selecting an item from the “filter” list, the document library updates and shows the filtered content correctly.
Any idea why it would not work and how to fix this? Seems like it should work
I created a Sharepoint page and added an MS list web part, which I use as a “filter” selection. Then, I added a second MS list to display the main list of content items, configured with Dynamic filtering based on selecting the “filter” list.Then, I added a Document library web part, which is again configured with Dynamic Filtering based on the selection of the second content item list. Unfortunately, when you select an item from the “filter” list and then select an item from the second “content” list, the document library does not update based on the selection.HOWEVER..If I select an item from the second “content” list without selecting an item from the “filter” list, the document library updates and shows the filtered content correctly. Any idea why it would not work and how to fix this? Seems like it should work Read More
Partner Blog | Showcasing the potential of the Microsoft partner ecosystem at the Marketplace Summit
Microsoft Tech Community – Latest Blogs –Read More
OneDrive “Unable to share right now”
When I wanna manage my files and folders from the web, it shows the pic bellow:
1. The error shows from the web is Pic 1, I tried Chrome and Edge, the same result.
2. When I try from the PC Client, it gets nothing but circling. Pic 2.
3. It happens to all my own files and folders. Because :
1) When I manage and re-share the files and folders that shared to me, it’s OK.
2) When I log into the site with account of my friend, using my PC and same browser, it’s OK.
4. So most probably that the issue is from the MS server and from my account.
p.s. I’m using personal account with @outlook.com.
Please help! Thanks a lot.
Yang
When I wanna manage my files and folders from the web, it shows the pic bellow:1. The error shows from the web is Pic 1, I tried Chrome and Edge, the same result.2. When I try from the PC Client, it gets nothing but circling. Pic 2.3. It happens to all my own files and folders. Because :1) When I manage and re-share the files and folders that shared to me, it’s OK.2) When I log into the site with account of my friend, using my PC and same browser, it’s OK.4. So most probably that the issue is from the MS server and from my account.p.s. I’m using personal account with @outlook.com.Please help! Thanks a lot.Yang Read More
Unlocking ROI: Forrester TEI Study Insights on Microsoft 365 Copilot for SMBs webinar
Join our webinar with @GabeHo and @KaylaPatterson to discover the results of the Forrester Total Economic Impact™ (TEI) study on Microsoft 365 Copilot for SMBs. Learn about the significant business value and ROI that SMBs can achieve with Microsoft 365 Copilot.
Key Highlights:
Introduction to Microsoft 365 Copilot: See how AI enhances productivity across Word, Excel, PowerPoint, Outlook, and Teams.
Forrester TEI Study Findings: Understand the projected ROI for SMBs using Microsoft 365 Copilot.
Making it Real: Hear practical examples of SMBs successfully implementing Microsoft 365 Copilot to drive growth.
Interactive Q&A Session: Get your questions answered by our experts about the study and the benefits of Microsoft 365 Copilot for your business.
Join our webinar with @GabeHo and @KaylaPatterson to discover the results of the Forrester Total Economic Impact™ (TEI) study on Microsoft 365 Copilot for SMBs. Learn about the significant business value and ROI that SMBs can achieve with Microsoft 365 Copilot.
Key Highlights:
Introduction to Microsoft 365 Copilot: See how AI enhances productivity across Word, Excel, PowerPoint, Outlook, and Teams.
Forrester TEI Study Findings: Understand the projected ROI for SMBs using Microsoft 365 Copilot.
Making it Real: Hear practical examples of SMBs successfully implementing Microsoft 365 Copilot to drive growth.
Interactive Q&A Session: Get your questions answered by our experts about the study and the benefits of Microsoft 365 Copilot for your business.
RSVP now!
Unlocking ROI: Forrester TEI Study Insights on Microsoft 365 Copilot for SMBs webinar
Join our webinar with @GabeHo and @KaylaPatterson to discover the results of the Forrester Total Economic Impact™ (TEI) study on Microsoft 365 Copilot for SMBs. Learn about the significant business value and ROI that SMBs can achieve with Microsoft 365 Copilot.
Key Highlights:
Introduction to Microsoft 365 Copilot: See how AI enhances productivity across Word, Excel, PowerPoint, Outlook, and Teams.
Forrester TEI Study Findings: Understand the projected ROI for SMBs using Microsoft 365 Copilot.
Making it Real: Hear practical examples of SMBs successfully implementing Microsoft 365 Copilot to drive growth.
Interactive Q&A Session: Get your questions answered by our experts about the study and the benefits of Microsoft 365 Copilot for your business.
Join our webinar with @GabeHo and @KaylaPatterson to discover the results of the Forrester Total Economic Impact™ (TEI) study on Microsoft 365 Copilot for SMBs. Learn about the significant business value and ROI that SMBs can achieve with Microsoft 365 Copilot.
Key Highlights:
Introduction to Microsoft 365 Copilot: See how AI enhances productivity across Word, Excel, PowerPoint, Outlook, and Teams.
Forrester TEI Study Findings: Understand the projected ROI for SMBs using Microsoft 365 Copilot.
Making it Real: Hear practical examples of SMBs successfully implementing Microsoft 365 Copilot to drive growth.
Interactive Q&A Session: Get your questions answered by our experts about the study and the benefits of Microsoft 365 Copilot for your business.
RSVP now!
Changing Entra\Azure Sign In As Email
Change Entra\Azure Sign In As Email is a critical process in the context of professional environments that rely heavily on Microsoft Azure services for their daily operations. By leveraging this feature, users can seamlessly sign in to their Azure accounts using their corporate email addresses for enhanced security and convenience. This not only simplifies the log-in process but also ensures that sensitive organizational data remains safe from unauthorized access. Furthermore, it streamlines user management processes by centralizing login credentials and permissions within the corporate email domain, leading to improved efficiency and control over resource allocation. Overall, implementing Change Entra\Azure Sign In As Email showcases a commitment to best practices in cybersecurity and access control within an enterprise setting, promoting a more secure and productive work environment.
Change Entra\Azure Sign In As Email is a critical process in the context of professional environments that rely heavily on Microsoft Azure services for their daily operations. By leveraging this feature, users can seamlessly sign in to their Azure accounts using their corporate email addresses for enhanced security and convenience. This not only simplifies the log-in process but also ensures that sensitive organizational data remains safe from unauthorized access. Furthermore, it streamlines user management processes by centralizing login credentials and permissions within the corporate email domain, leading to improved efficiency and control over resource allocation. Overall, implementing Change Entra\Azure Sign In As Email showcases a commitment to best practices in cybersecurity and access control within an enterprise setting, promoting a more secure and productive work environment. Read More
The specified executable is not a valid application for this os platform | Help
Hi all
So I created an iso image with ADK WinPE and the task is to run a program at startup via the cmd but I received this error I searched a lot but I found nothing. If anyone has a solution it will be great to help me.
Thank you
Hi allSo I created an iso image with ADK WinPE and the task is to run a program at startup via the cmd but I received this error I searched a lot but I found nothing. If anyone has a solution it will be great to help me.Thank you Read More
Unlocking ROI: Forrester TEI Study Insights on Microsoft 365 Copilot for SMBs webinar
Join our webinar with @GabeHo and @KaylaPatterson to discover the results of the Forrester Total Economic Impact™ (TEI) study on Microsoft 365 Copilot for SMBs. Learn about the significant business value and ROI that SMBs can achieve with Microsoft 365 Copilot.
Key Highlights:
Introduction to Microsoft 365 Copilot: See how AI enhances productivity across Word, Excel, PowerPoint, Outlook, and Teams.
Forrester TEI Study Findings: Understand the projected ROI for SMBs using Microsoft 365 Copilot.
Making it Real: Hear practical examples of SMBs successfully implementing Microsoft 365 Copilot to drive growth.
Interactive Q&A Session: Get your questions answered by our experts about the study and the benefits of Microsoft 365 Copilot for your business.
Join our webinar with @GabeHo and @KaylaPatterson to discover the results of the Forrester Total Economic Impact™ (TEI) study on Microsoft 365 Copilot for SMBs. Learn about the significant business value and ROI that SMBs can achieve with Microsoft 365 Copilot.
Key Highlights:
Introduction to Microsoft 365 Copilot: See how AI enhances productivity across Word, Excel, PowerPoint, Outlook, and Teams.
Forrester TEI Study Findings: Understand the projected ROI for SMBs using Microsoft 365 Copilot.
Making it Real: Hear practical examples of SMBs successfully implementing Microsoft 365 Copilot to drive growth.
Interactive Q&A Session: Get your questions answered by our experts about the study and the benefits of Microsoft 365 Copilot for your business.
RSVP now! Read More
Marketplace Summit sessions now available on-demand
Microsoft recently hosted a one-day Marketplace Summit in London, which included more than 300 partners in attendance and provided a deep dive on how partners can work together to accelerate business—using the benefits of the marketplace and ecosystem opportunity. The sessions from this event are now available on-demand here.
Sessions offered at this event included:
Maximizing marketplace success
Co-sell and enterprise sales
Cloud marketplaces and GTM tools
Manage your listings
Activating the channel
To learn more about key takeaways from this event, including themes such as the marketplace as a partner-focused business platform, and marketplace investment as being rooted in customer demand, check out this recap blog: Showcasing the potential of the Microsoft partner ecosystem at the Marketplace Summit
Microsoft recently hosted a one-day Marketplace Summit in London, which included more than 300 partners in attendance and provided a deep dive on how partners can work together to accelerate business—using the benefits of the marketplace and ecosystem opportunity. The sessions from this event are now available on-demand here.
Sessions offered at this event included:
Maximizing marketplace success
Co-sell and enterprise sales
Cloud marketplaces and GTM tools
Manage your listings
Activating the channel
To learn more about key takeaways from this event, including themes such as the marketplace as a partner-focused business platform, and marketplace investment as being rooted in customer demand, check out this recap blog: Showcasing the potential of the Microsoft partner ecosystem at the Marketplace Summit Read More
Creating an FAQ with Associated Training and Inline Quiz All with Copilot – Copilot Snacks
I was recently asked by a customer how they could build some departmental level training and materials, along with leave behind supportive collateral, all using the power of Microsoft 365 Copilot.
In this Copilot Snack I walk you through the generation of a leave behind reference Word doc FAQ, then creating the corresponding training PowerPoint deck, and finish off with building an inline quiz in the deck using Forms. In each instance (Word, PowerPoint, and Forms) I will leverage the power of Microsoft 365 Copilot to generate the content.
After watching the video check out the resources below where I also include the prompts used.
Resources:
Check out ALL the Copilot Snacks published to Date
Prompts Used:
For Word – Create an FAQ around the importance of proper handwashing and sterilization after a clinician is finished visiting a patient
For PowerPoint -the importance of proper handwashing and sterilization after a clinician is finished visiting a patient
Forms – I’d like to create a quiz for clinicians at Smartter Health that tests their knowledge around the importance of proper handwashing and sterilization after a clinician is finished visiting a patient. Include questions concerning on types of pathogens handwashing addresses, modes of pathogen transmission, proper handwashing techniques, the four steps of effective handwashing, sterilization protocols for clinicians
Microsoft 365 Copilot – Microsoft Adoption
Copilot in Word help & learning
Copilot in PowerPoint help & learning
Welcome to Copilot in Forms – Microsoft Support
Thanks for visiting – Michael Gannotti LinkedIn
Microsoft Tech Community – Latest Blogs –Read More
FSlogix ODFC container and Outlook OST file
Hi All,
There is a host pool with a couple of session hosts.
Users’ profiles are stored in file share by means of FSLogix with Microsoft apps separated with ODFC container.
Having all that set up the way I described is it normal that users’ Outlook OST files are stored in C:UsersusernameAppDataLocalMicrosoftOutlook?
For some reason a user periodically gets this error although the path is reachable.
(All AVD users have their OST files stored in local path).
Hi All, There is a host pool with a couple of session hosts.Users’ profiles are stored in file share by means of FSLogix with Microsoft apps separated with ODFC container. Having all that set up the way I described is it normal that users’ Outlook OST files are stored in C:UsersusernameAppDataLocalMicrosoftOutlook? For some reason a user periodically gets this error although the path is reachable. (All AVD users have their OST files stored in local path). Read More
Filtering for multiple items
Hello!
I have a set of data in which I need to filter for 97 items. How do I filter a different data set for 97 items so that I don’t have to filter it 97 times?
Thanks!
Hello!I have a set of data in which I need to filter for 97 items. How do I filter a different data set for 97 items so that I don’t have to filter it 97 times?Thanks! Read More
Mute Edge as a taskbar action
Lot of people watch movies, streaming etc. using notebook connected to TV (by HDMI), as a second display. In this situation, you want sometimes to mute edge (stream going in Edge), but there is no “Mute” action on right-button when you click on taskbar Edge button (just New Window and New InPrivate Window). So you must de-fullscreen video on the TV, mute tab, later un-mute tab and fullscreen video on the TV again. Mute action on taskbar would really improve that experience (I would consider even putting small clickable icon directly on taskbar Edge button, if possible).
Lot of people watch movies, streaming etc. using notebook connected to TV (by HDMI), as a second display. In this situation, you want sometimes to mute edge (stream going in Edge), but there is no “Mute” action on right-button when you click on taskbar Edge button (just New Window and New InPrivate Window). So you must de-fullscreen video on the TV, mute tab, later un-mute tab and fullscreen video on the TV again. Mute action on taskbar would really improve that experience (I would consider even putting small clickable icon directly on taskbar Edge button, if possible). Read More
How to Join a Teams Meeting using Only the Meeting ID without password or user sign-in
Dear all,
We are working on a project that involves integrating Microsoft Teams into a web application. I have two requirements, and we are seeking guidance on how to implement them:
Join a Teams meeting using only the meeting ID: Is it possible to allow users to join a Teams meeting by entering just the meeting ID, without requiring a password or sign-in? If so, what would be the best approach to achieve this?Bypass the lobby from the client side: Is there a way to automatically bypass the Teams meeting lobby from the client side, allowing users to join the meeting directly without needing host approval?
Any help or direction on how to implement these features would be greatly appreciated!
Thank you in advance!
James from Shared Studios
Dear all,We are working on a project that involves integrating Microsoft Teams into a web application. I have two requirements, and we are seeking guidance on how to implement them:Join a Teams meeting using only the meeting ID: Is it possible to allow users to join a Teams meeting by entering just the meeting ID, without requiring a password or sign-in? If so, what would be the best approach to achieve this?Bypass the lobby from the client side: Is there a way to automatically bypass the Teams meeting lobby from the client side, allowing users to join the meeting directly without needing host approval?Any help or direction on how to implement these features would be greatly appreciated!Thank you in advance!James from Shared Studios Read More
Enviar archivo PDF a contacto de WhattsApp con C Sharp.
Hola, una consulta, tengo desarrollada una aplicación de escritorio Windows Forms con C Sharp y me están requiriendo que desde la misma se pueda enviar documentos PDF a contactos de WhttsApp. Estuve buscando información en la web, pero no encontré información certera. Desde ya muchas gracias. Saludos.
Hola, una consulta, tengo desarrollada una aplicación de escritorio Windows Forms con C Sharp y me están requiriendo que desde la misma se pueda enviar documentos PDF a contactos de WhttsApp. Estuve buscando información en la web, pero no encontré información certera. Desde ya muchas gracias. Saludos. Read More
Start reference date not refreshed in report
Hi Community,
I’ve created a Power BI report based on data from Project online.
I changed few dates for certain projects in Project online.
When I refresh the data in PBI Report, all project dates update correctly except for one specific project, where the reference date still show the old value.
Any suggestion would be appreciated.
Hi Community,I’ve created a Power BI report based on data from Project online.I changed few dates for certain projects in Project online.When I refresh the data in PBI Report, all project dates update correctly except for one specific project, where the reference date still show the old value.Any suggestion would be appreciated. Read More
Blog about: How to Use Microsoft Stream: A Beginner’s Guide
Microsoft Stream is a video-sharing service designed for businesses and organizations to upload, manage, and share videos securely within their enterprise. It’s part of the Microsoft 365 suite, making it easy to collaborate with your team using video content. Whether you’re sharing training videos, presentations, or meetings, Microsoft Stream offers an intuitive platform for video management. Here’s how to get started.
https://dellenny.com/how-to-use-microsoft-stream-a-beginners-guide/
Microsoft Stream is a video-sharing service designed for businesses and organizations to upload, manage, and share videos securely within their enterprise. It’s part of the Microsoft 365 suite, making it easy to collaborate with your team using video content. Whether you’re sharing training videos, presentations, or meetings, Microsoft Stream offers an intuitive platform for video management. Here’s how to get started.
https://dellenny.com/how-to-use-microsoft-stream-a-beginners-guide/
Read More