Month: October 2024
Fill Column based on Specific data from another Column
Hi All,
Flash fill has been playing up a bit on this column, I am trying to create a Formula to allow excel to check what colour is in ROW F and then Put that colour into ROW D. There is around 128,000 products.
I am having issues with flash fill because some of the fields have Black + Honeycomb Filter and flash fill just puts in “Filter” which isnt a colour. Or Instead of putting Anodic Bronze Matt it just puts “Matt”
Is there a Formula that can do this ?
Happy to make a table with all the colours etc….
Thanks !
Hi All, Flash fill has been playing up a bit on this column, I am trying to create a Formula to allow excel to check what colour is in ROW F and then Put that colour into ROW D. There is around 128,000 products. I am having issues with flash fill because some of the fields have Black + Honeycomb Filter and flash fill just puts in “Filter” which isnt a colour. Or Instead of putting Anodic Bronze Matt it just puts “Matt” Is there a Formula that can do this ? Happy to make a table with all the colours etc…. Thanks ! Read More
جـلب الـحبيب المتمـرد ☑️ -002.0104058.1277 -☑️ شـيخ روحـاني السعـودية **
جـلب الـحبيب المتمـرد :ballot_box_with_check: -002.0104058.1277 -:ballot_box_with_check: شـيخ روحـاني السعـودية **
جـلب الـحبيب المتمـرد :ballot_box_with_check: -002.0104058.1277 -:ballot_box_with_check: شـيخ روحـاني السعـودية ** Read More
Excel formulas not working across multiple sheets
So I’ve got an excel document going where each month I am keeping track of data, then using auto sum for monthly totals. After that I do quarterly totals and then a year to date total. Each month, quarter, and YTD are their own sheet. In my sheets for Q1 through Q3, I reference the respective monthly sheets, then autosum the totals and it has worked flawlessly. For Q4, it pulled the monthly totals with no problem, but suddenly autosum does not want to function. I have automatic calculations turned on and the data is in there under general, so it’s not a text issue. I can manually do it no problem, but I’d rather it be an automatic thing so I’m not editing multiple sheets each month. Please help. (there are no error messages either, it’s just not adding the data)
So I’ve got an excel document going where each month I am keeping track of data, then using auto sum for monthly totals. After that I do quarterly totals and then a year to date total. Each month, quarter, and YTD are their own sheet. In my sheets for Q1 through Q3, I reference the respective monthly sheets, then autosum the totals and it has worked flawlessly. For Q4, it pulled the monthly totals with no problem, but suddenly autosum does not want to function. I have automatic calculations turned on and the data is in there under general, so it’s not a text issue. I can manually do it no problem, but I’d rather it be an automatic thing so I’m not editing multiple sheets each month. Please help. (there are no error messages either, it’s just not adding the data) Read More
CTRL + Q To “Mark Emails as Read” No Longer Auto Highlights the Next Email, Requiring Manual Clicks
Just as the title suggests, on New Outlook, I had created an “Unread Mail” folder in my favorites that showed me all Unread mail. When you click an email, it does not automatically read the email, so I found pressing CTRL + Q would read the email. Beforehand, it would automatically selecte the next email under it, and once I read it, I’d press CTRL + Q, and it would read, disappear from the Unread Folder, and move to the next one. Now, that process just stopped out of nowhere. Now I need to manually click each email, before pressing CTRL + Q to get it to read and stop showing in the unread email folder. I like this option because many of my emails are ruled into folders automatically on arrival, and the Unread Emails Folder shows me which folder they live in and of course that they’re unread. Would there be any reason this changed? Feels like a bug that newest update produced.
Just as the title suggests, on New Outlook, I had created an “Unread Mail” folder in my favorites that showed me all Unread mail. When you click an email, it does not automatically read the email, so I found pressing CTRL + Q would read the email. Beforehand, it would automatically selecte the next email under it, and once I read it, I’d press CTRL + Q, and it would read, disappear from the Unread Folder, and move to the next one. Now, that process just stopped out of nowhere. Now I need to manually click each email, before pressing CTRL + Q to get it to read and stop showing in the unread email folder. I like this option because many of my emails are ruled into folders automatically on arrival, and the Unread Emails Folder shows me which folder they live in and of course that they’re unread. Would there be any reason this changed? Feels like a bug that newest update produced. Read More
New Hugging Face Models on Azure AI: Phi-3 Variants from the Community
Building generative AI applications starts with model selection and picking the right model to suit your application needs. The Azure AI Model Catalog offers over 1.78K models, including foundation models from core partners and nearly 1.6K open-source models from the Hugging Face community. This post is part of a monthly series to raise awareness of new models added to the Hugging Face collection on Azure. Check out the previous Hugging Face Models roundup post here.
The Hugging Face model hub has over 1M models. We select ~20 models each month to add to Azure based on feedback from our customers and developer community. Want to request a specific Hugging Face model be added? Make the request in just 3 steps:
Search the Hugging Face Hub for the desired model – click to view its Model Card.
Click the “Deploy” dropdown on that page – select the Azure ML option.
Look for a “Request to add” button in the pop-up dialog and complete the flow.
If the model already exists in the Azure AI model catalog, you will see a “Go to model in Azure ML” button that should direct you to the model card on Azure AI Studio.
18 New Hugging Face Models Added in September
September saw the addition of 18 new models into the Hugging Face Collection on Azure AI. Models included community-created variants of popular base models from Meta’s Llama family (LLM), Microsoft’s Phi-3 family (SLM) and more. We also saw a number of these fine-tuned models were “made with Unsloth” – we’ll talk about this in a bit. First, let’s review the models added and highlight any notable features about them.
Note: These community-created models are suitable for research & prototyping but will require additional assessment for use in production. Read the model card (linked to each) for usage guidance and limitations and conduct your own quality and safety evaluations to assess them for your specific application scenario.
#
Model Name · Inference Task
Notable Features
01
Groq/Llama-3-Groq-70B-Tool-Use ·
Text Generation
Fine-tuned for tool use · 90.76% accuracy on BFCL (best in 70B class) · Meta-Llama-3-70B based
02
Groq/Llama-3-Groq-8B-Tool-Use ·
Text Generation
Fine-tuned for tool use · 89.06% accuracy on BFCL (best in 8B class) · Meta-Llama-3-8B based
03
LenguajeNaturalAI/leniachat-qwen2-1.5B-v0 · Text Generation · Spanish
Fine-tuned for Spanish users · Trained exclusively in Spanish for high-quality chat, instructions · Qwen/Qwen2-1.5B based
04
gokaygokay/Flux-Prompt-Enhance ·
Text-to-Text Generation ·
Create enhanced prompts for image creation with Flux models · Creator Blog · google-t4/t5-base based
05
Ba2han/Llama-Phi-3_DoRA · Text Generation · made with unsloth
Trained on fltered versions of tagged datasets and llama-3-70B generated examples · Highest on MMLU, Winogrande for its class · microsoft/phi-3-mini
06
unsloth/Phi-3.5-mini-instruct · Text Generation · made with unsloth
2X faster fine-tuning · 50% less memory use · Notebook (add data) · microsoft/phi-3.5-mini
07
cognitivecomputations/dolphin-2.9.2-Phi-3-Medium-abliterated · Text Generation · made with unsloth
Filtered dataset to remove alignment/bias · Uncensored model (see: research) · Needs dev effort for alignment, responsible AI · unsloth/Phi-3-mini-4k-instruct
08
third-intellect/Phi-3-mini-4k-instruct-orca-math-word-problems-200k-model-16bit · Text Generation · made with unsloth
Conversational math problems · Orca-Math problems dataset · unsloth/Phi-3-mini-4k-instruct-bnb-4bit based
09
unsloth/Phi-3-medium-4k-instruct · Text Generation · made with unsloth
2X faster fine-tuning · Notebook (add data) · Quantized bnb-4bit model · microsoft/phi-3-medium-4k-instruct
10
vonjack/Phi-3-mini-4k-instruct-LLaMAfied · Text Generation
Chat completion · Recalibrated to fit Llama/Llama-2 model structure · microsoft/phi-3-mini-4k-instruct based
11
Sreenington/Phi-3-mini-4k-instruct-AWQ · Text Generation
Uses AutoAWQ for 4-bit quantization · Higher throughput with smaller GPUs · microsoft/phi-3-mini-4k-instruct based
12
Skywork/Skywork-Reward-Gemma-2-27B · Text Generation
High-perf reward model · Skywork Reward Dataset · gemma-2-27b-it · Top 3 in RewardBench leaderboard
13
TinyLlama/TinyLlama-1.1B-Chat-v1.0 · Text Generation
Pre-train 1.1B-Llama model on 3T tokens · Use UltraChat data set variant · Edge devices · Real-time dialog
14
lemon07r/Gemma-2-Ataraxy-9B · Text Generation · Creative Writing
Creative Writing · Top-ranked in Eq-Bench leaderboard · Model merge using SLERP mergekit · google/gemma2-9b fine-tune with merges
15
MLP-KTLim/llama-3-Korean-Bllossom-8B · Text Generation · Korean
Korean-English bilingual model · Vocabulary expansion · Human Feedback (DPO) · Bllossom ELO model has SOTA score on LogicKor for <10B models · meta/llama-3 based
16
weblab-GENIAC/Tanuki-8B-dpo-v1.0 · · Text Generation · Japanese
Japanese dialogue · Pre-trained · Supervised fine-tuning · Direct Preference Optimization (DPO) · meta/llama arch
17
aisingapore/llama3-8b-cpt-sea-lionv2.1-instruct · Text Generation · Multi-lingual
Fine-tuned with 100K English, 50K ASEAN language pairs · Commercially permissive · High-quality datasets · Ranks top on SEA HELM · llama3-8b-cpt (continued pre-trained)
18
aisingapore/llama3-8b-cpt-sea-lionv2-base · Text Generation · Multi-lingual
Pre-trained, instruction-tuned for Southeast Asia (SEA) · Evaluated well on BHASA benchmarks · Not aligned for safety · meta/llama-3-8b-instruct based
Observed Themes
The 18 models added also help us identify useful themes or trends in community created variants in terms of use cases, tools and processes. This is what we observed:
Multi-lingual Models Continue to Shine – We added models tailored for Spanish, Japanese, Korean and Southeast Asian languages, with many models scoring well on their respective evaluation leaderboards. This underscores growing demand for conversational tasks that can reflect regional vocabularies and culture effectively.
Phi-3 Variants Continue to Grow – Microsoft’s Phi-3 family of “small language models” (SLM) outperforms other comparable models in equivalent or adjacent size classes. We are now seeing more variants developed, potentially for scenarios on mobile and edge devices. More on this below.
Fine-Tuning Tools Have Value – Community-authored variants focus on fine-tuning popular base models, but this is time-intensive and costly. We are now seeing more models “made with Unsloth”, reflecting interest in tools and processes that speed-up fine-tuning with less memory – without sacrificing accuracy. More on this below.
Meta/Llama Remains Popular – The Meta/Llama family of models continues to influence community creators in different ways. First, as a base model for fine-tuning (e.g., multi-lingual with SEA-lion, tool usage with Groq) and second as a target for optimization (e.g., TinyLlama family for mobile and edge devices). We also see adaptation of other base models (e.g., Llamafied version of Phi-3) to make those models fit a familiar structure for usage.
Model Spotlight: Phi-3 Community Variants
The Hugging Face models hub shows Phi-3 variants are created on a daily basis. In general, the Phi-3 family of models outperforms others in its size class (and adjacent) making it ideal for use cases targeting edge and mobile devices. We added 7 of these models to Azure this month, fine-tuned with Phi-3 and Phi-3.5 base models, but with different objectives. Let’s review these briefly.
1. vonjack/Phi-3-mini-4k-instruct-LLaMAfied
2. Sreenington/Phi-3-mini-4k-instruct-AWQ
3. Ba2han/Llama-Phi-3_DoRA · made with unsloth
4. unsloth/Phi-3.5-mini-instruct · made with unsloth
5. cognitivecomputations/dolphin-2.9.2-Phi-3-Medium-abliterated · made with unsloth
6. third-intellect/Phi-3-mini-4k-instruct-orca-math-word-problems-200k-model-16bit · made with unsloth
7. unsloth/Phi-3-medium-4k-instruct · made with unsloth
The first variant recalibrates the model to fit the Llama2/Llama3 model structure for developer familiarity. The second uses AutoAWQ for 4-bit quantization to get a model that can work on smaller GPUs. The third uses Llama-3 generated examples for fine-tuning, scoring well on two popular benchmarks. Variants 4 and 7 are from Unsloth and showcase their fine-tuning techniques as explained in the next section. Variant 5 shows an example of fine-tuning Phi-3 to “abilterate” information, uncensoring it. Variant 6 showcases Phi-3’s math capabilities, fine-tuned with the popular Orca Math Word problems dataset.
Want to explore to explore Phi-3 capabilities but don’t know where to start? Bookmark the Phi-3 Cookbook from Microsoft and start with the Welcome to the Phi-3 Family page. Then explore the Table Of Contents for links to quick-starts, tutorials and E2E samples. Then, try using one of the fine-tuned variants above to see the difference.
Community Call for Action
1. Help Us Spotlight Your Work!
Have you used Hugging Face models on Azure to build interesting AI applications? Have you published your own fine-tuned variants of popular foundation models? We want to know more. Leave a comment on this blog with links to articles or repositories you’ve authored – we’d love to learn more and amplify our model creator community.
2. Get Started with Hugging Face Models on Azure
New to the Azure AI Model catalog and want to get started using Hugging Face models on Azure? Here are three resources to kickstart your learning journey:
Azure AI Model Catalog: Explore the Hugging Face Collection
Azure ML Documentation: Model Catalog and Collections
Azure ML Sample Notebooks: Explore inference tasks with code
Reminder: We add ~20 models to the Hugging Face Collection on Azure each month and we need your feedback to help make these decisions! Request a model using the 3-step process outlined earlier in the article and tell us more about how you’re using it today!
Microsoft Tech Community – Latest Blogs –Read More
Office 365 Admin Walkthrough
How to Navigate the Microsoft 365 Admin Center
The complexity of managing IT infrastructure can often seem overwhelming, especially with limited resources. This simply walkthrough of the Microsoft 365 admin center will help you navigate administrative tasks for your nonprofit organization.
Accessing the Admin Center
Step 1: Log In
Open your web browser.
Go to admin.microsoft.com.
If you have the appropriate permissions, you will see the Admin button which can be viewed on the left side panel or in the App Launcher.
Enter your admin credentials (username and password).
Click Sign in.
Step 2: Home Page Overview
After logging in, you’ll land on the Home page. The home page provides a summary of your organization, including any common tasks typical to most organizations. At the top of the navigation, find actions like adding users, resetting passwords, or adding user groups.
Step 3: Navigation Pane
The left-hand navigation pane gives you access to all admin features. Key sections include:
Users
Groups
Devices
Billing
Settings
Managing Users
Step 4: Adding New Users
To add users go to Users > Active users.
Click Add a user.
Fill in the required information (name, email, etc.).
Assign product licenses.
Set up sign-in security options.
Click Add to create the user.
Step 5: Managing Existing Users
To manage your current users navigate to Users > Active users <strong>, where you can see a list of all users. Click on a user to view and edit their details. Options include:
Resetting passwords
Managing licenses
Editing user information
Managing Groups
Step 6: Creating and Managing Groups
Navigate to Groups > Active groups.<strong>
Click Add a group.
Choose the group type (e.g., Office 365, Security).
Enter the group name and description.
Add members to the group.
Click Create to finalize the group.
Managing Devices
Step 7: Managing Devices
Go to Devices > Manage. <strong>
View a list of all devices connected to your organization.
Click on a device to view details and manage settings. Options include:
Adding new devices
Enforcing security policies
Managing device settings
Billing and Subscriptions
Step 8: Managing Licenses
Navigate to Billing > Licenses <strong> to manage your licenses.
View a list of all licenses assigned to your organization.
Assign, remove, or reassign licenses as needed.
Step 9: Billing Information
Go to Billing > Bills & payments <strong> to modify payment methods.
View your billing history.
Manage payment methods.
Set up billing alerts and notifications.
Additional Admin Center View
Step 10: Dashboard View
Once back on the Home page, you have the ability to change your view from simplified to a dashboard view. This view allows you to customize the home page by adding, removing, or rearranging task cards:
Click Customize <strong> in the top right corner.
Drag and drop cards to rearrange them.
Click the X on a card to remove it.
Configuring Settings
Step 11: Organization Settings
For additional settings applicable to the entire org, navigate to Settings > Org settings. <strong> Configure organization-wide settings, including:
Security settings
Email settings
Compliance policies
Step 12: Security and Compliance
To view security items within the admin center go to Security & compliance. <strong> Here you will have the ability to: Manage data protection and compliance features, Set up data loss prevention (DLP) policies, and Manage eDiscovery and configure audit logs.
Getting Help and Support
Step 13: Accessing Help
Use the Help & support section to find answers to common questions.
Open service requests and track their status.
Step 14: Learning Resources
Access training materials and tutorials to get the most out of Microsoft 365.
Join the Microsoft 365 community or the Microsoft Nonprofit Community Hub for additional support and networking.
Conclusion
By following this guide, you can effectively navigate and utilize the Microsoft 365 admin center to manage your organization’s Microsoft 365 environment. For more detailed instructions, refer to the official Microsoft documentation and support resources.
Microsoft Tech Community – Latest Blogs –Read More
Share AI Skills Navigator with your nonprofits and your teams!
Help nonprofits unlock new opportunities with AI skills that are in demand now and in the future.
Share AI Skills Navigator, an AI assistant designed to direct learners to learning pathways and resources, with your nonprofits to:
Help encourage AI adoption
Explore learning content from videos, LinkedIn Learning, Microsoft Learn, and more. Over 200 learning resources in one starting points
Discover free learning resources for all roles/levels to lead team readiness
Org leader resources to skill up on topics of concern for decision makers, like responsible AI, change management, etc
Learn more
AI Skills Navigator
AI Skills Navigator: FAQ
Help nonprofits unlock new opportunities with AI skills that are in demand now and in the future.
Share AI Skills Navigator, an AI assistant designed to direct learners to learning pathways and resources, with your nonprofits to:
Help encourage AI adoption
Explore learning content from videos, LinkedIn Learning, Microsoft Learn, and more. Over 200 learning resources in one starting points
Discover free learning resources for all roles/levels to lead team readiness
Org leader resources to skill up on topics of concern for decision makers, like responsible AI, change management, etc
Learn more
AI Skills Navigator
AI Skills Navigator: FAQ Read More
Powershell 7 – $time is not defined – Script from Microsoft
I get the error “Get-ADComputer: Variable: ‘time’ found in expression: $time is not defined.”. The script is straight from Microsoft and $time is populated with a date/time. It seems very simple, I don’t know what is going wrong.
$DaysInactive = 90
$time = (Get-Date).Adddays(-($DaysInactive))
Get-ADComputer -searchbase “OU=SC,OU=Servers,DC=WSDOT,DC=LOC” -Filter {$_.LastLogonTimeStamp -lt $time} -ResultPageSize 2000 -resultSetSize $null -Properties Name, OperatingSystem, SamAccountName, DistinguishedName
I get the error “Get-ADComputer: Variable: ‘time’ found in expression: $time is not defined.”. The script is straight from Microsoft and $time is populated with a date/time. It seems very simple, I don’t know what is going wrong. $DaysInactive = 90
$time = (Get-Date).Adddays(-($DaysInactive))
Get-ADComputer -searchbase “OU=SC,OU=Servers,DC=WSDOT,DC=LOC” -Filter {$_.LastLogonTimeStamp -lt $time} -ResultPageSize 2000 -resultSetSize $null -Properties Name, OperatingSystem, SamAccountName, DistinguishedName Read More
Managing Microsoft Teams Blueprint Survey Opportunity
Greetings!
Microsoft is updating a certification for Managing Microsoft Teams, and we need your input through our exam blueprinting survey.
The blueprint determines how many questions each skill in the exam will be assigned. Please complete the online survey by October 31st, 2024. Please also feel free to forward the survey to any colleagues you consider subject matter experts for this certification.
If you have any questions, feel free to contact Rohan Mahadevan at rmahadevan@microsoft.com or John Sowles at josowles@microsoft.com.
Managing Microsoft Teams blueprint survey link:
https://microsoftlearning.co1.qualtrics.com/jfe/form/SV_ctOPGr5wCMctRKC
Greetings!Microsoft is updating a certification for Managing Microsoft Teams, and we need your input through our exam blueprinting survey. The blueprint determines how many questions each skill in the exam will be assigned. Please complete the online survey by October 31st, 2024. Please also feel free to forward the survey to any colleagues you consider subject matter experts for this certification.
If you have any questions, feel free to contact Rohan Mahadevan at rmahadevan@microsoft.com or John Sowles at josowles@microsoft.com.Managing Microsoft Teams blueprint survey link:https://microsoftlearning.co1.qualtrics.com/jfe/form/SV_ctOPGr5wCMctRKC Read More
Dax measures total mismatch in visual level
Hi Team,
I have below dax measures as follows:
Forecast – Target Units_1 =
VAR _DailyUnits = [Target consumption per day_1]
RETURN
SUMX(Points,
SUMX(Calendar_,
IF(ISBLANK([Actual Units]),_DailyUnits
)))
Referenced above measure ‘Target consumption per day_1′ comes from below:
Target consumption per day_1 =
VAR minDate = MIN ( ‘Calendar_'[Date] )
VAR maxDate = MAX ( ‘Calendar_'[Date] )
RETURN CALCULATE (
SUMX (
TargetTimeSeries,
VAR _Days = TargetTimeSeries[EndDate] – TargetTimeSeries[StartDate] +1
VAR Result = TargetTimeSeries[Usage] / _Days
RETURN Result
),
REMOVEFILTERS ( ‘Calendar_’ ),
KEEPFILTERS ( TargetTimeSeries[EndDate] >= minDate ),
KEEPFILTERS ( TargetTimeSeries[StartDate] <= maxDate ),
TargetTimeSeries[TargetType] = 1
)
The result(Duplicate of Page 3) tab is as below:
Please advise!
PFA file here Portfolio Performance – v2.13 – Copy.pbix
Thanks in advance!
Hi Team, I have below dax measures as follows: Forecast – Target Units_1 =
VAR _DailyUnits = [Target consumption per day_1]
RETURN
SUMX(Points,
SUMX(Calendar_,
IF(ISBLANK([Actual Units]),_DailyUnits
))) Referenced above measure ‘Target consumption per day_1’ comes from below: Target consumption per day_1 =
VAR minDate = MIN ( ‘Calendar_'[Date] )
VAR maxDate = MAX ( ‘Calendar_'[Date] )
RETURN CALCULATE (
SUMX (
TargetTimeSeries,
VAR _Days = TargetTimeSeries[EndDate] – TargetTimeSeries[StartDate] +1
VAR Result = TargetTimeSeries[Usage] / _Days
RETURN Result
),
REMOVEFILTERS ( ‘Calendar_’ ),
KEEPFILTERS ( TargetTimeSeries[EndDate] >= minDate ),
KEEPFILTERS ( TargetTimeSeries[StartDate] <= maxDate ),
TargetTimeSeries[TargetType] = 1
) The result(Duplicate of Page 3) tab is as below: Expected output total from Forecast – Target Units_1 should add up(4978+4037) to give 9015 in total.But the measure total displays as 18,030(guess so) which is not correct & what we wanted. Another example for above total mismatch is as below: I think its to do with filter context but am struggling to work it out. Please advise!PFA file here Portfolio Performance – v2.13 – Copy.pbix Thanks in advance!@SergeiBaklan Read More
Marking a file or folder as cloud only
I am working with Windows 11 on an Acer desktop computer and have uploaded numerous files into One Drive. But I want to designate those files as Cloud Only as I am trying to clear up space on my harddrive. Can someone tell me how to do this?
I am working with Windows 11 on an Acer desktop computer and have uploaded numerous files into One Drive. But I want to designate those files as Cloud Only as I am trying to clear up space on my harddrive. Can someone tell me how to do this? Read More
Intune Remediation schedule
Hi I have a question about remediation and when it runs.
I have a detection and remediation script set up and have a schedule for every hour. When I deploy it how long before the client runs the detection ?
Is it that he client has to pick up the policy first (so once every 8 hours, on restart or logon) ?
If so does it run the detection straight away ?
What does the schedule of 1 hour do ? Does it has run the detection script once, and then continue to run the detection script every hour ?
Thanks
G
Hi I have a question about remediation and when it runs.I have a detection and remediation script set up and have a schedule for every hour. When I deploy it how long before the client runs the detection ?Is it that he client has to pick up the policy first (so once every 8 hours, on restart or logon) ?If so does it run the detection straight away ?What does the schedule of 1 hour do ? Does it has run the detection script once, and then continue to run the detection script every hour ? Thanks G Read More
Graph API – Sharepoint Bulk update – best practice ??
Hi Experts,
I am looking for best practices for implementing a project using Graph API and sharepoint
“template”: “documentLibrary”
We have 40K records incoming in the below format as json,
Need to consume it and update the corresponding line-item based on the client_no.
The reason we are using the approach is, in the previous implmentation
it is throwing [ 429 Too Many Requests] errors when we try to update SP/Docuoment template with 40k records.
Any thoughts/suggestions highly appreciated
[
{
“Client_No”: “5Z39896869”,
“Case_Name”: “CON-ESBTest001”,
“DeptName”: “veteneary”,
“Open_Date”: “02/24/2016”,
“Initial__Date”: “04/12/2016”
},
{
“Client_No”: “4Z40990233”,
“Case_Name”: “Test Test”,
“DeptName”: “vet”,
“Open_Date”: “02/16/2017”,
“Initial__Date”: “04/11/2017”
},
{
“Client_No”: “0Z42299803”,
“Case_Name”: “ESBTest002”,
“DeptName”: “department”,
“Open_Date”: “07/07/2020”,
“Initial__Date”: “10/21/2020”
}
]
PATCH – https://graph.microsoft.com/v1.0/sites/xyz.sharepoint.com:/sites/testsplist:/lists/9b2e99d1-c067-7654-bcb5-b5b00c65432/items/1
1 = line item with “Client_No”: “5Z39896869”,
Hi Experts, I am looking for best practices for implementing a project using Graph API and sharepoint “template”: “documentLibrary” We have 40K records incoming in the below format as json,Need to consume it and update the corresponding line-item based on the client_no.The reason we are using the approach is, in the previous implmentation it is throwing [ 429 Too Many Requests] errors when we try to update SP/Docuoment template with 40k records.Any thoughts/suggestions highly appreciated[{“Client_No”: “5Z39896869″,”Case_Name”: “CON-ESBTest001″,”DeptName”: “veteneary”,”Open_Date”: “02/24/2016″,”Initial__Date”: “04/12/2016”},{“Client_No”: “4Z40990233″,”Case_Name”: “Test Test”,”DeptName”: “vet”,”Open_Date”: “02/16/2017″,”Initial__Date”: “04/11/2017”},{“Client_No”: “0Z42299803″,”Case_Name”: “ESBTest002″,”DeptName”: “department”,”Open_Date”: “07/07/2020″,”Initial__Date”: “10/21/2020”}]PATCH – https://graph.microsoft.com/v1.0/sites/xyz.sharepoint.com:/sites/testsplist:/lists/9b2e99d1-c067-7654-bcb5-b5b00c65432/items/11 = line item with “Client_No”: “5Z39896869”, Read More
Register a shared computer with Intune for Device Management and Windows Updates
We are a financial institution and most of our computers in our retail division are shared computers. Nobody has a true dedicated computer in retail. We are looking to get all our desktops and laptops registered within Intune for Device Management to Control with Group Policy and Updates via Intune. Has anyone done this before and how did you go about doing it?
We are a financial institution and most of our computers in our retail division are shared computers. Nobody has a true dedicated computer in retail. We are looking to get all our desktops and laptops registered within Intune for Device Management to Control with Group Policy and Updates via Intune. Has anyone done this before and how did you go about doing it? Read More
Town Hall vs Live Events
Please bring back some of the beloved features of Live Events into Town Hall or just make these improvements:
1. Ability to end the live broadcast and debrief with presenters behind the scenes when the event has concluded
2. Ability to sort published questions in different ways (# of likes, first in vs last in)
3. Ability to reply to questions In Review / Dismissed so the audience doesn’t have to see the conversation
4. Ability to clean up the Published questions once they’ve been asked/answered
Please bring back some of the beloved features of Live Events into Town Hall or just make these improvements:1. Ability to end the live broadcast and debrief with presenters behind the scenes when the event has concluded2. Ability to sort published questions in different ways (# of likes, first in vs last in)3. Ability to reply to questions In Review / Dismissed so the audience doesn’t have to see the conversation4. Ability to clean up the Published questions once they’ve been asked/answered Read More
Candidly Copilot Episode 1
Well, we kicked off our new weekly podcast this Monday 10/14 at 1pm and immediately encountered technical errors with streaming to LinkedIn that we did not encounter in testing. We were however able to capture the session in a recording. Moving forward we are simplifying the process by hosting directly as a Teams meeting so there should not be any more issues like that.
In this kickoff episode, hosts Chat Stout and Michael Gannotti kick off the new podcast and discuss the weekly approach to covering Copilot content (Crawl, Walk, Run) If you missed this week’s episode don’t worry. We will be back this next Monday diving into “Before You Crawl – Getting Your Data Up in the Cloud.”
Resources:
Check out ALL upcoming, and previously recorded, Candidly Copilot podcasts here
Microsoft 365 Copilot – Microsoft Adoption
Thanks for visiting!
Microsoft Tech Community – Latest Blogs –Read More
FILTER and SCAN function
Dear Experts,
Greetings!
I have a data like below(Input worksheet), in Column1, there are 144 Band Combination(1~144) each with a specific Feature sets(
In Output-1, I need like below:-
and in Output-2, I need like below:-
Thanks in Advance,
Br,
Anupam
Dear Experts, Greetings! I have a data like below(Input worksheet), in Column1, there are 144 Band Combination(1~144) each with a specific Feature sets( In Output-1, I need like below:-and in Output-2, I need like below:- Thanks in Advance,Br,Anupam Read More
Recording in Microsoft Stream is skipping words on audio
Hey, I have used Microsoft Streams to record video recently.
I have an external microphone and the audio quality is fine.
Unfortunately about every minute or so the recorded audio on the Microsoft Streams video will skip a word or two. I know it is not the microphone or connections as I can use them for other applications. It only happens with Microsoft Streams. I would really appreciate your guidance as this problem is really limiting my work currently.
Many thanks and best wishes,
Rakshita
Hey, I have used Microsoft Streams to record video recently.I have an external microphone and the audio quality is fine.Unfortunately about every minute or so the recorded audio on the Microsoft Streams video will skip a word or two. I know it is not the microphone or connections as I can use them for other applications. It only happens with Microsoft Streams. I would really appreciate your guidance as this problem is really limiting my work currently.Many thanks and best wishes,Rakshita Read More
Full Screen in Edge with touchscreen – How do we inhibit long duration touch (right click?) actions?
I volunteer for a museum and we display an internal html web based presentation featuring images upon selection using a mouse with a physically inhibited right click… to prevent right click actions by visitors breaking out of the full screen display.
We want to move to a touchscreen solution but of course in Edge.. the browser we are currently using …. it will allow right click actions which opens a dialogue box menu allowing a breakout, and also a swipe from the top screen edge will produce the F11 escape function .. also offering access a cancel out off full screen mode.
Does anyone know a way to inhibit both of these facilities in Edge full screen mode so that only hyperlinked graphic buttons in the touchscreen display etc respond to touch control and not general page area touches. Ironically we have managed to inhibit side swiping in this mode using an Edge UI key.. but how do we do this for the top edge swipe? Turning off right click resources in the Windows 11 control panel simply does not work!!
Help if at all possible please!!
I volunteer for a museum and we display an internal html web based presentation featuring images upon selection using a mouse with a physically inhibited right click… to prevent right click actions by visitors breaking out of the full screen display.We want to move to a touchscreen solution but of course in Edge.. the browser we are currently using …. it will allow right click actions which opens a dialogue box menu allowing a breakout, and also a swipe from the top screen edge will produce the F11 escape function .. also offering access a cancel out off full screen mode. Does anyone know a way to inhibit both of these facilities in Edge full screen mode so that only hyperlinked graphic buttons in the touchscreen display etc respond to touch control and not general page area touches. Ironically we have managed to inhibit side swiping in this mode using an Edge UI key.. but how do we do this for the top edge swipe? Turning off right click resources in the Windows 11 control panel simply does not work!! Help if at all possible please!! Read More
authorized supplier
Hi i have microsoft partner and microsoft indirect resller for my llc and i want to sell products like winodows keys and ms office 2021 online and worldwide but i want to found microsoft authorized supplier for this products can you help me ?
Hi i have microsoft partner and microsoft indirect resller for my llc and i want to sell products like winodows keys and ms office 2021 online and worldwide but i want to found microsoft authorized supplier for this products can you help me ? Read More
