Category: Microsoft
Category Archives: Microsoft
training data model from SQL server text columns
I want to create a Q & A based on the data we have already collected while serving our clients (people with disabilities). There is a text field where they present their issue. There is another text field where we record the service we provided and some of the possible solutions. There are other selection type/lookup fields that can help us categorize/tag the problem/solution text.
How can I train Azure AI service so that it can provide the most likely solution based on any new service requests received from our clients? As you can tell, I am fairly new to the AI world. Therefore I’m open to any new ideas/technologies that can help achieve this objective. Any help is appreciated.
Thank you.
I want to create a Q & A based on the data we have already collected while serving our clients (people with disabilities). There is a text field where they present their issue. There is another text field where we record the service we provided and some of the possible solutions. There are other selection type/lookup fields that can help us categorize/tag the problem/solution text. How can I train Azure AI service so that it can provide the most likely solution based on any new service requests received from our clients? As you can tell, I am fairly new to the AI world. Therefore I’m open to any new ideas/technologies that can help achieve this objective. Any help is appreciated. Thank you. Read More
Request: Manage Apple Vision Pro with Intune MDM
Hi,
At our company, some teams are working with Apple Vision Pro because they are hoping to find new technical solutions for the business. We would also like to include Apple Vision Pro in the management of our other mobile devices via Intune MDM.
Since Apple has also offered an MDM interface for Apple Vision Pro with the visionOS 1.1 update, the glasses could in principle also be managed by an MDM, but the MDM must also support the glasses.
Hence my question: When will this be possible via Intune MDM? As a company, we recently switched to Intune MDM with over 110,000 devices (both mobile devices and fat clients) and we are confident that Microsoft will also support new technical products (such as the Apple Vision Pro).
Hi, At our company, some teams are working with Apple Vision Pro because they are hoping to find new technical solutions for the business. We would also like to include Apple Vision Pro in the management of our other mobile devices via Intune MDM.Since Apple has also offered an MDM interface for Apple Vision Pro with the visionOS 1.1 update, the glasses could in principle also be managed by an MDM, but the MDM must also support the glasses.Hence my question: When will this be possible via Intune MDM? As a company, we recently switched to Intune MDM with over 110,000 devices (both mobile devices and fat clients) and we are confident that Microsoft will also support new technical products (such as the Apple Vision Pro). Read More
Transposing Absolute References
I would like to drag a sum down a column, essentially creating field sums for a large number of records. Once dragged down, I want to paste-special transpose. The final result should be a row of sums, but the sums should row sums from above. I could turn all the sums into absolute references first, but that is tedious. Somehow, I would like to highlight multiple cells and ask Excel to turn them all into absolutely references at the same time. Can this be done?
I would like to drag a sum down a column, essentially creating field sums for a large number of records. Once dragged down, I want to paste-special transpose. The final result should be a row of sums, but the sums should row sums from above. I could turn all the sums into absolute references first, but that is tedious. Somehow, I would like to highlight multiple cells and ask Excel to turn them all into absolutely references at the same time. Can this be done? Read More
Google Premier Club
Hello from resercher Professional.
Present you business plan for Google Premier Partner Club.
Join us and bring your professional experience with Microsoft Azure Organisation and Google Legal Department.
Integration for Special Event on Ignite
Hello from resercher Professional.Present you business plan for Google Premier Partner Club.Join us and bring your professional experience with Microsoft Azure Organisation and Google Legal Department. Integration for Special Event on Ignite Read More
New learning
https://learn.microsoft.com/training/challenges?id=3eec2027-867a-4787-8e87-bc6ec22953e9&WT.mc_id=cloudskillschallenge_3eec2027-867a-4787-8e87-bc6ec22953e9&wt.mc_id=studentamb_287632 Read More
Join this challenge
https://learn.microsoft.com/training/challenges?id=61f56e0c-17e2-48ca-8e81-e6e79180a0de&WT.mc_id=cloudskillschallenge_61f56e0c-17e2-48ca-8e81-e6e79180a0de&wt.mc_id=studentamb_280411 Read More
Error being returned summing field
Hi folks,
In the following formula:
=SUMIFS((Sheet1!$R$5:$R$1000, D24)=SUMIF(Sheet1!$O$5:$O$1000,”>0″))
colR is the week number
D24 refers to week number 19
colO is the amount sold
The formula I am trying looks first to find the matching field number and then sum the the total of colO where the amount of each week number found is greater than 0
For example D24 has found three week 19’s in colO two of the records are greater than 0 and one record less than 0
The formula should only sum those records that are greater than 0
Thank you for your interest!
Hi folks, In the following formula:=SUMIFS((Sheet1!$R$5:$R$1000, D24)=SUMIF(Sheet1!$O$5:$O$1000,”>0″)) colR is the week numberD24 refers to week number 19colO is the amount sold The formula I am trying looks first to find the matching field number and then sum the the total of colO where the amount of each week number found is greater than 0 For example D24 has found three week 19’s in colO two of the records are greater than 0 and one record less than 0 The formula should only sum those records that are greater than 0 Thank you for your interest! Read More
License for External Users in D365F&O
Hi,
Do we need a license to use the vendor collaboration in D365F&O. previously we didnt need any license.
looking for confirmations.
Hi, Do we need a license to use the vendor collaboration in D365F&O. previously we didnt need any license. looking for confirmations. Read More
OneDrive – Mac OS Ventura – iMac 3.8 GHz Quad-Core Intel Core i5
Yesterday, at around 10AM EDT, OneDrive crashed on my Mac. For the past 20 hours I have tried to restore the OneDrive app on the Mac. I have installed and reinstalled the app. I have rebooted the gateway. I have more than enough capacity (only using .4 of 1TB). Even though I have uninstalled the app it is still showing in the Systems-General-Log In Items, which I have turned off. I can access my OneDrive on my iPhone and my iPad, but the app will no longer run on my iMac. After I install it the OneDrive icon appears in the Menu Bar at the top, it just flashes on and off and prevents the iMac from functioning properly; it appears it trying to update and keeps taking control of the processor. Any ideas are greatly appreciated.
Yesterday, at around 10AM EDT, OneDrive crashed on my Mac. For the past 20 hours I have tried to restore the OneDrive app on the Mac. I have installed and reinstalled the app. I have rebooted the gateway. I have more than enough capacity (only using .4 of 1TB). Even though I have uninstalled the app it is still showing in the Systems-General-Log In Items, which I have turned off. I can access my OneDrive on my iPhone and my iPad, but the app will no longer run on my iMac. After I install it the OneDrive icon appears in the Menu Bar at the top, it just flashes on and off and prevents the iMac from functioning properly; it appears it trying to update and keeps taking control of the processor. Any ideas are greatly appreciated. Read More
Link to new item form using Power app
Hi!
I have a list for which the form (new / edit) was customized with Power Apps.
This works OK if we edit an existing item or select New from the list main page.
However, if we browse to https://oursharepointsite/Lists/MyList/newform.aspx
we get a default form instead of the power app form. This happens only for this specific list on our site.
How can I get a link to the PowerApp form for this list?
Hi! I have a list for which the form (new / edit) was customized with Power Apps.This works OK if we edit an existing item or select New from the list main page.However, if we browse to https://oursharepointsite/Lists/MyList/newform.aspxwe get a default form instead of the power app form. This happens only for this specific list on our site. How can I get a link to the PowerApp form for this list? Read More
ManualValidation task is not available in my tfs
hi
i don’t ManualValidation task available in my tfs , what should i do ??
hi i don’t ManualValidation task available in my tfs , what should i do ?? Read More
Why are there no career paths for Messaging or SharePoint administrator?
I do not see any official career path from Microsoft for Messaging or SharePoint administrators.
I do not see any official career path from Microsoft for Messaging or SharePoint administrators. Read More
Microsoft Invoice Storage Solution
Today, I’ve put together a swift and efficient Microsoft Power Automate solution. It swiftly extracts your invoices from Microsoft Outlook, securely storing them in a SharePoint folder, and then tidies up your inbox by deleting the email. This not only reduces clutter but also provides a centralised hub for managing and reviewing your invoices, ensuring better organisation of your payable and paid invoices. Grab this solution now from our download page at www.nomorebadmondays.com/solutions.
Today, I’ve put together a swift and efficient Microsoft Power Automate solution. It swiftly extracts your invoices from Microsoft Outlook, securely storing them in a SharePoint folder, and then tidies up your inbox by deleting the email. This not only reduces clutter but also provides a centralised hub for managing and reviewing your invoices, ensuring better organisation of your payable and paid invoices. Grab this solution now from our download page at www.nomorebadmondays.com/solutions. Read More
Excel – Welche Formel ? / Which formula?
Hallo,
ich bräuchte bitte Unterstützung hinsichtlich welche Formel anzuwenden ist.
Folgende Situation:
2 Excel Dateien.
Wunsch:
Zunächst sollte ein Abgleich zwischen den beiden Dateien stattfinden.
Sind die Personalnummern aus Datei 1 (Spalte B) in Datei 2 (Spalte A) vorhanden?
Wenn ja, soll in Datei 1 in Spalte C, der Werte aus Datei 2 (Spalte B) aus der Zeile in der die jeweilige Personalnummer gefunden wurde, übernommen werden.
Wenn nein, soll in Datei 1 in Spalte C, bei der jeweiligen Personalnummer “n/a” hinterlegt sein.
Hi,
I need help to find the right formula. Currently I have two files.
I am aiming for the following:
First, I need to know whether the personnel number in file 1 (column B) is available in file 2 (column A)
If yes, the figure from file 2 (column B) should be shown in file 1 (column C)
If no, column C in file 1 should show “n/a”.
Hallo,ich bräuchte bitte Unterstützung hinsichtlich welche Formel anzuwenden ist.Folgende Situation:2 Excel Dateien. Wunsch:Zunächst sollte ein Abgleich zwischen den beiden Dateien stattfinden.Sind die Personalnummern aus Datei 1 (Spalte B) in Datei 2 (Spalte A) vorhanden?Wenn ja, soll in Datei 1 in Spalte C, der Werte aus Datei 2 (Spalte B) aus der Zeile in der die jeweilige Personalnummer gefunden wurde, übernommen werden.Wenn nein, soll in Datei 1 in Spalte C, bei der jeweiligen Personalnummer “n/a” hinterlegt sein. Hi,I need help to find the right formula. Currently I have two files.I am aiming for the following: First, I need to know whether the personnel number in file 1 (column B) is available in file 2 (column A)If yes, the figure from file 2 (column B) should be shown in file 1 (column C)If no, column C in file 1 should show “n/a”. Read More
Program tracking
Hello,
I’m not sure what the best option would be best to meet my needs on a patient tracker excel spreadsheet. Each column has name, ID number, date referred, date evaluated and other info. In the diagnostic column, can the row be copied into another tab with the diagnosis? For example, I add AS in the diagnostic cell, and it copies the row to an another tab for tracking AS patients. I have a list of diagnostics that need to be complete before procedure and need to have a reminder or sent to my outlook calendar. My volume is increasing where I have 288 patients that I am manually tracking. I created a table so I can at least filter diagnosis and/ or referring physician. Any advice would be much appreciated.
Hello, I’m not sure what the best option would be best to meet my needs on a patient tracker excel spreadsheet. Each column has name, ID number, date referred, date evaluated and other info. In the diagnostic column, can the row be copied into another tab with the diagnosis? For example, I add AS in the diagnostic cell, and it copies the row to an another tab for tracking AS patients. I have a list of diagnostics that need to be complete before procedure and need to have a reminder or sent to my outlook calendar. My volume is increasing where I have 288 patients that I am manually tracking. I created a table so I can at least filter diagnosis and/ or referring physician. Any advice would be much appreciated. Read More
Need help for building a storeprocedure
Hi all, Urgent help is required.
There are two pages now in my application. One is buildingblock page and another is volume page. Now in the buildingblock page I am choosing building blocks(Origin/destination type). Under each BB there are locations which are called as OriginCX/Destination Cx based on which BB type it is.
I am making all possible pairs of them like origin – destination combinations and then in volume page I am displaying them as records in a grid with some other input fields.
Example scenarios which are NOT passing now- Consider choosing 1 OriginCx and 1destinationCx of each BB type and they are the same location then after going to Volume page we can find a single record. When we are saving the record data and coming back to BB page then if we are deselecting either one location and saving data in BB page. Then moving forward no alert is being shown that location has been modified
Another scenario which is also failing now is – If I am choosing a single BB location maybe as origin/destination and saving in BB page and moving forward to volume then we can find a dropdown with all available cities location to choose. Here if I am choosing any city and saving the data then alert is coming as Location has been modified. This condition no alert should come.
This is all of my business logic
Hi all, Urgent help is required. There are two pages now in my application. One is buildingblock page and another is volume page. Now in the buildingblock page I am choosing building blocks(Origin/destination type). Under each BB there are locations which are called as OriginCX/Destination Cx based on which BB type it is. I am making all possible pairs of them like origin – destination combinations and then in volume page I am displaying them as records in a grid with some other input fields. Example scenarios which are NOT passing now- Consider choosing 1 OriginCx and 1destinationCx of each BB type and they are the same location then after going to Volume page we can find a single record. When we are saving the record data and coming back to BB page then if we are deselecting either one location and saving data in BB page. Then moving forward no alert is being shown that location has been modified Another scenario which is also failing now is – If I am choosing a single BB location maybe as origin/destination and saving in BB page and moving forward to volume then we can find a dropdown with all available cities location to choose. Here if I am choosing any city and saving the data then alert is coming as Location has been modified. This condition no alert should come. This is all of my business logic Read More
Issue with get-sposite SPO PowerShell
Issue with SPO PowerShell get-sposite for all sites not returning the correct values for different properties SharingDomainRestrictionMode , LimitedAccessFileType, DefaultSharingLinkType, DefaultLinkPermission etc,
If get-sposite -Identity <siteurl> is used, the correct values for the properties are returned.
It seems to be an issue with the underlying CSOM. Can someone at Microsoft help with this? I have raised case #2405120050000021 for this. My previous experience raising a case related to SPO PowerShell was closed because SPO PowerShell was not supported by the team handling the case.
Issue with SPO PowerShell get-sposite for all sites not returning the correct values for different properties SharingDomainRestrictionMode , LimitedAccessFileType, DefaultSharingLinkType, DefaultLinkPermission etc,If get-sposite -Identity <siteurl> is used, the correct values for the properties are returned. It seems to be an issue with the underlying CSOM. Can someone at Microsoft help with this? I have raised case #2405120050000021 for this. My previous experience raising a case related to SPO PowerShell was closed because SPO PowerShell was not supported by the team handling the case. Read More
Distribution of one number over different categories with specific probabilities per category
Hi all,
I’ve been trying to create a formula to distribute a given amount of points over multiple different categories with different probabilities for each individual category.
So for example 10 points over 6 different categories with 50% probability for each point to be added to category 1, 20% for category 2, 10% for categories 3 and 4, and 5% for categories 5 and 6.
I appreciate any ideas!
Hi all, I’ve been trying to create a formula to distribute a given amount of points over multiple different categories with different probabilities for each individual category.So for example 10 points over 6 different categories with 50% probability for each point to be added to category 1, 20% for category 2, 10% for categories 3 and 4, and 5% for categories 5 and 6. I appreciate any ideas! Read More
Inbox
How to find emails recieved just now? A notification at top right appears but it wont appear in the inbox. Sometimes when i click on top right notification, the mail opens, sometimes dont.
How to find emails recieved just now? A notification at top right appears but it wont appear in the inbox. Sometimes when i click on top right notification, the mail opens, sometimes dont. Read More
