Tag Archives: microsoft
Register now! CSP Copilot and Microsoft 365 Activation Event
Reinvent your Cloud Solution Provider program (CSP) growth in the AI era with Copilot and Microsoft 365!
DETAILS
SAVE YOUR SEAT
Register today by selecting your preferred date and time zone below to reserve your spot and to get notified when session content is available on demand.
August 27th
September 5th
TOPIC DETAILS
Discover:
New promotional offers across Copilot for Microsoft 365, Microsoft 365 E SKUs, and Dynamics 365 Business Central
How CSP partners like you can accelerate growth with Copilot and Microsoft 365
PRESENTED BY
Giovanni Mezgec, VP of Modern Work and Business Applications Field & Partner Marketing
David Smith, VP of Worldwide Channel Sales
Reinvent your Cloud Solution Provider program (CSP) growth in the AI era with Copilot and Microsoft 365!
DETAILS
SAVE YOUR SEAT
Register today by selecting your preferred date and time zone below to reserve your spot and to get notified when session content is available on demand.
August 27th
AM option
PM option
September 5th
AM option
PM option
TOPIC DETAILS
Discover:
New promotional offers across Copilot for Microsoft 365, Microsoft 365 E SKUs, and Dynamics 365 Business Central
How CSP partners like you can accelerate growth with Copilot and Microsoft 365
PRESENTED BY
Giovanni Mezgec, VP of Modern Work and Business Applications Field & Partner Marketing
David Smith, VP of Worldwide Channel Sales Read More
ADX Web updates – July 2024
Introducing ad-hoc visual Data Exploration feature
Our new “Data Exploration” feature allows you to dive deeper into the data on any dashboard, extending your exploration beyond the displayed tiles to uncover new insights. This user-friendly, form-like interface lets you add filters, create aggregations, and switch visualization types without writing queries. Now, you can explore data ad-hoc, leveraging existing tiles to start your journey and expand your data view.
Read more:
Announcement: Ad-Hoc Visual Data Exploration Feature – Microsoft Community Hub
Documentation: Explore data in dashboard tiles (preview) – Azure Data Explorer | Microsoft Learn
Dashboards real time refresh rate
We are excited to announce an enhancement to our dashboard auto refresh feature, now supporting continuous and 10 seconds refresh rates, in addition to the existing options.
This upgrade, addressing a popular customer request, allows both editors and viewers to set near real-time and real-time data updates, ensuring your dashboards display the most current information with minimal delay. Experience faster data refresh and make more timely decisions with our improved dashboard capabilities.
As the dashboard author you can enable the Auto refresh setting and set a minimum time interval, to prevent users from setting an auto refresh interval smaller than the provided value.
Note that the Continuous option should be used with caution. The data is refreshed every second or after the previous refresh completes if it takes more than 1 second.
Resize dashboard tiles using keyboard only
We are excited to introduce a new accessibility feature that allows users to resize dashboard tiles using only the keyboard.
By pressing the Tab key, you can focus on a tile, and then use the arrow keys to move it.
To resize, hold the Shift key and use the arrow keys: right to increase width, left to decrease width, down to increase height, and up to decrease height.
This functionality mirrors the ease of moving and resizing with a mouse, enhancing the accessibility and usability of ADX web UI.
Azure Data Explorer Web UI team is looking forward for your feedback in KustoWebExpFeedback@service.microsoft.com
You’re also welcome to add more ideas and vote for them here – https://aka.ms/adx.ideas
Read more:
ADX Web May updates – ADX Web updates – May 2024 – Microsoft Community Hub
Microsoft Tech Community – Latest Blogs –Read More
Introducing Drag and Drop to Reorder Items in Microsoft Lists
You asked, and we listened! We’re excited to announce the arrival of a long-awaited feature in Microsoft Lists: drag and drop to reorder List items! This new feature will allow you to effortlessly rearrange your list items, making organization more efficient for all your busy lists.
Drag and Drop Items with Ease
You will now be able to drag and drop seamlessly with this new feature for Microsoft Lists! You can easily start using this option on any new or existing list to arrange your items.
You can also drag and drop multiple items at once to reorder them, giving you more ways to organize and stay on top of your work.
Your custom ordering is saved across the entire list, and you can switch into custom order mode any time you’d like by changing the sort to Custom order.
Work in different views
The drag and drop feature in Microsoft Lists is incredibly versatile, supporting reordering across various views including board view and gallery view. Whether you’re grouping or filtering items, you can easily reorder them to suit your needs.
Board View
Gallery View
Move up and move down
For our keyboard users and screen reader users, there is a move up/move down functionality we have implemented. Navigate to More Actions > More and you will find the option to Move down or Move up your List item.
This feature streamlines how you manage your lists, providing a more personalized and efficient way to keep your data organized.
Try it out today and experience a smoother workflow with Microsoft Lists!
Resources
Microsoft Tech Community – Latest Blogs –Read More
Recovering and Validating Data After Unexpected SQL Server Failovers
In SQL Server environments, including on-premises, Azure SQL Database, or SQL Managed Instance, unexpected failovers can sometimes leave Availability Group roles out of sync. When this happens, the new primary replica might take over while the original primary faces issues, leading to possible data discrepancies if transactions were in progress or uncommitted. To recover or validate any data loss, it’s essential to resync or validate the new primary with the old primary as soon as it’s back online. This ensures any lost transactions are reconciled. If critical data was missed during the failover, it must be recovered and merged to maintain database consistency. This blog outlines the steps to recover or validate any data loss using SQL Server Database Compare Utility.
To simulate this situation with the SQL Server Box product, two SQL Server VMs were set up on the same subnet, Always-On HA was turned on for both instances, a simplified WideWorldImportersDW (WWIDW) database was restored and set to full recovery mode. After creating the certificates and logins/users required for Availability Groups (AGs) without domains, an asynchronous commit AG was created (it needed to be asynchronous, since we cannot simulate transaction loss with a synchronous AG).
Using a transaction simulator, many transactions per second were performed into the primary database.
During this activity, the primary instance was stopped, which created a group of committed transactions that had not been replicated to the secondary. The goal of this post is to recover those missing transactions.
After stopping sql1, you need to open the dashboard on sql2, because SSMS can no longer connect to sql1 to update the status:
Opening the Failover wizard – you see a warning about data loss:
The wizard really wants to make sure you know there may be data loss:
Click through to get the results:
The dashboard for sql2 has the current cluster status:
To capture the state of the new primary, immediately create a database snapshot, ideally before opening it up to new application connections:
(In this case we were using sql1 in the transaction simulator and not the sqlistener, so no transactions will be written to sql2).
Restart the sql1 instance. On refresh, you will see that the old primary now has a state of Not Synchronizing / In Recovery.
Create a database snapshot on the old primary (sql1) before making the old primary the secondary (otherwise, when the old primary synchronizes as a secondary, the missing transactions are lost🙁
At this point you can Resume Data Movement to make the old primary a secondary.
It takes a minute for the old primary to roll back lost transactions and resynchronize with the new primary and the old primary should now be a synchronizing secondary;
We can now use the SQL Server Database Compare (SSDBC) application to check if we lost any transactions between the snapshot on the new primary (sql2 – the source) and the snapshot on the old primary (sql1 – the target). Refer to the SSDBC documentation for how to set it up.
In this case we have 313 hash differences (updates) and 423 missing (inserts) rows – note that we have no deletes that were not replicated because of timing of the simulated transaction cascading deletes (deletes stop if we exceed the configured percentage until the inserts/updates catch up):
Looking at the SSDBC folder in My Documents – we can see a SQL script file for each table in the database, with numbers in front to indicate the order you should run them in (based on foreign key references). If the database has DRI configured, you may need to combine scripts if the referenced table has an identity column and if you have the identity value capture option turned on. In the same folder are log files which contain more details about the comparison.
Opening one of the files, you can see update and insert statements. The update statements are written to try to be as safe as possible by checking (with additional conditions in the where clause) that the column value hasn’t been subsequently changed on the new primary.
After running all the change scripts on WWIDW on sql2 and then re-running SSDBC on WWIDW on sql2 (not the snapshot) and the sql1 snapshot – we see that the databases are now the same (note that this will only work on a static new primary);
Note that we could also use the tablediff utility or SSDT to generate a differences script.
The SSDBC download package contains a PowerShell script to make running the comparison operations across many servers/databases easier by making it Excel workbook driven. You can list your source and target servers and databases in the provided Servers.xlsx workbook and run the BulkDatabaseRecovery.ps1 script.
Feedback and suggestions
If you have feedback or suggestions for improving this team asset, please contact the Azure Databases SQL Customer Success Engineering Team. Thank you for your support!
Microsoft Tech Community – Latest Blogs –Read More
Mesh for Teams license for government
I work for the government. Looking in our Microsoft 365 admin center, I see we own:
Microsoft 365 G3 GCC Microsoft 365 G3 GCC
Microsoft 365 G5 Compliance GCC Microsoft 365 G5 Compliance GCC
Microsoft 365 G5 Security GCC Microsoft 365 G5 Security GCC
Microsoft Teams Premium for GCC Introductory Pricing Microsoft Teams Premium for GCC Introductory Pricing
Microsoft Teams Rooms Pro for GCC Microsoft Teams Rooms Pro for GCC
Do we have license for Mesh for Teams? I ask because per aka.ms/meshprep, there is mention of Premium license in a tenant for “Commercial”.
I work for the government. Looking in our Microsoft 365 admin center, I see we own:Microsoft 365 G3 GCC Microsoft 365 G3 GCCMicrosoft 365 G5 Compliance GCC Microsoft 365 G5 Compliance GCCMicrosoft 365 G5 Security GCC Microsoft 365 G5 Security GCCMicrosoft Teams Premium for GCC Introductory Pricing Microsoft Teams Premium for GCC Introductory PricingMicrosoft Teams Rooms Pro for GCC Microsoft Teams Rooms Pro for GCC Do we have license for Mesh for Teams? I ask because per aka.ms/meshprep, there is mention of Premium license in a tenant for “Commercial”. Read More
Hybrid TaskBar
Personally, I think it’d be nice to have a windows 11 setting that has the apps and search bar in the middle and the windows bar in the bottom left, due to the fact it’s been there for about 30 years, so it’s a hard habit to break for those who were there from the start.
Personally, I think it’d be nice to have a windows 11 setting that has the apps and search bar in the middle and the windows bar in the bottom left, due to the fact it’s been there for about 30 years, so it’s a hard habit to break for those who were there from the start. Read More
“Ugh-oh, there was a problem while creating your booking page” – all users unable to create bookings
All of our users are unable to create shared bookings pages. We have tried via Teams and signed in to Office.com, trying on multiple web browsers. All users have the Microsoft Bookings app assignment granted in 365 Admin Center. I have also turned off Bookings using Powershell, and turned it back on with no success.
Is Bookings as a service working for others? Some users are also reporting that personal bookings calendars have disappeared.
Error attached here:
All of our users are unable to create shared bookings pages. We have tried via Teams and signed in to Office.com, trying on multiple web browsers. All users have the Microsoft Bookings app assignment granted in 365 Admin Center. I have also turned off Bookings using Powershell, and turned it back on with no success. Is Bookings as a service working for others? Some users are also reporting that personal bookings calendars have disappeared. Error attached here: Read More
Pop up reminder based when specific wording is present (VBA or Macro?)
I am trying to create a pop up message/reminder/alert when certain projects read “Overdue” in certain cells.
Is there a simple formula or code that can notify when a cell reads Overdue?
Once I enter dates for my many projects, there are formulas for each project that show when the due date is and whether the project is currently “Not due or Overdue” based on those dates/data.
I am looking to have a pop up reminder or Macro of some sort that I can quickly check if any dates are “Overdue”.
Any and all help is much appreciated !
I am trying to create a pop up message/reminder/alert when certain projects read “Overdue” in certain cells. Is there a simple formula or code that can notify when a cell reads Overdue? Once I enter dates for my many projects, there are formulas for each project that show when the due date is and whether the project is currently “Not due or Overdue” based on those dates/data. I am looking to have a pop up reminder or Macro of some sort that I can quickly check if any dates are “Overdue”. Any and all help is much appreciated ! Read More
Powershell Profiles
Hi! I would like to create profiles for powershell that on launch run commands like ssh to autoconnect to server. I tried making powershell profiles in window but besides of just existing it hasn’t changed anything. When using command New-Item -Path $profile.CurrentUserCurrentHost -ItemType File -Force
It is making profile used by whole powershell. How can i change that so profile for ex. HPServer launches different commands and RPIServer other?
Hi! I would like to create profiles for powershell that on launch run commands like ssh to autoconnect to server. I tried making powershell profiles in window but besides of just existing it hasn’t changed anything. When using command New-Item -Path $profile.CurrentUserCurrentHost -ItemType File -ForceIt is making profile used by whole powershell. How can i change that so profile for ex. HPServer launches different commands and RPIServer other? Read More
Vinesh Phogaat hi hai kya be kar rahe
Ted and I will be in touch with you and your family members
Ted and I will be in touch with you and your family members Read More
Working with a list, but I keep getting errors when updating
Hello!
I’m getting this message in Hebrew (translated to English here):
“The source of the list must be a delimited list or a reference to a single line.”.
“על מקור הרשימה להיות רשימה מופרדת או הפניה לשורה יחידה”
And all I need to do is to update this list, which exists on another page.
I updated it with one value, but the list itself wasn’t updated (I tried to recreate it also, but it didn’t let me, with the same error as above).
I need help about how to update it! And/or how to use as new list in the main sheet.
Please answer,
Thanks for the helpers!
Hello!I’m getting this message in Hebrew (translated to English here):”The source of the list must be a delimited list or a reference to a single line.”.”על מקור הרשימה להיות רשימה מופרדת או הפניה לשורה יחידה”And all I need to do is to update this list, which exists on another page.I updated it with one value, but the list itself wasn’t updated (I tried to recreate it also, but it didn’t let me, with the same error as above).I need help about how to update it! And/or how to use as new list in the main sheet. Please answer,Thanks for the helpers! Read More
Excel Copilot examples for the week of August 12th
The Excel team is happy to share some examples of how Excel Copilot can help you. Here’s what you can look forward to this week:
Monday 12-Aug – Using Excel Copilot to split columns
Tuesday, 13-Aug – Adding email addresses using Excel Copilot (coming soon)
Wednesday, 14-Aug – Working with date columns using Excel Copilot (coming soon)
Thursday, 15-Aug – Converting text to numbers with Excel Copilot (coming soon)
Friday. 16-Aug – Using Excel Copilot to show additional units of measure (coming soon)
Stay tuned,
Microsoft Excel Team
The Excel team is happy to share some examples of how Excel Copilot can help you. Here’s what you can look forward to this week:
Monday 12-Aug – Using Excel Copilot to split columns
Tuesday, 13-Aug – Adding email addresses using Excel Copilot (coming soon)
Wednesday, 14-Aug – Working with date columns using Excel Copilot (coming soon)
Thursday, 15-Aug – Converting text to numbers with Excel Copilot (coming soon)
Friday. 16-Aug – Using Excel Copilot to show additional units of measure (coming soon)
Stay tuned,
Microsoft Excel Team Read More
What’s New in Microsoft EDU webinar – August 2024
Here is our August 2024 webinar agenda:
Copilot for M365 announcements for educators and students
Teams for EDU updates – AI for educators feature rollout and more
Learning Accelerators updates
Reading Coach and Reflect
Clipchamp for EDU rollout
AMA – Ask Microsoft EDU Anything (Q&A)
How to sign up
OPTION 1: August 21st, Wednesday @ 8:00am Pacific Time Register here
OPTION 2: August 21st, Wednesday @ 4:00pm Pacific Time Register here
This is what the webinar portal will look like when you register:
Microsoft Tech Community – Latest Blogs –Read More
Status reports intune
I am using the API “deviceManagement/reports/getUserInstallStatusReport” with the HTTP POST method, and the request body includes:
Intune returns a maximum of 50 records, but some applications are installed by more than 5000 users. To check if a specific user has installed this application and to get the installation status report for this application on their device, I have to loop through the results by incrementing the skip value by 50. This process takes a lot of time and often results in a 429 status (Too Many Requests).
Is there any way to filter by UserName directly? Currently, this doesn’t seem to be supported.
I am using the API “deviceManagement/reports/getUserInstallStatusReport” with the HTTP POST method, and the request body includes: { “select”: [ “UserName”, “UserPrincipalName”, “FailedCount”, “InstalledCount”, “PendingInstallCount”, “NotInstalledCount” ], “skip”: 0, “top”: 50, “filter”: “(ApplicationId eq ‘XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX’)” } Intune returns a maximum of 50 records, but some applications are installed by more than 5000 users. To check if a specific user has installed this application and to get the installation status report for this application on their device, I have to loop through the results by incrementing the skip value by 50. This process takes a lot of time and often results in a 429 status (Too Many Requests).Is there any way to filter by UserName directly? Currently, this doesn’t seem to be supported. Read More
Azure Monitoring Agent Extension – no update
Hello, I am using Azure Arc along with the AzureMonitorLinuxAgent and AzureMonitorWindowsAgent extensions.
However, I’ve encountered multiple instances where the version listed in the changelog for the Azure Monitor Agent extension (Azure Monitor Agent extension versions – Azure Monitor | Microsoft Learn) is newer than the version I can see in the portal – also with azure cli or powershell, the newest version is missing – i only see the previous one.
Has anyone else experienced this issue? Last time they had to redeploy something in westeurope
But i guess this is no coincidence
Thanks if somebody can share there experience or can help…
Hello, I am using Azure Arc along with the AzureMonitorLinuxAgent and AzureMonitorWindowsAgent extensions.However, I’ve encountered multiple instances where the version listed in the changelog for the Azure Monitor Agent extension (Azure Monitor Agent extension versions – Azure Monitor | Microsoft Learn) is newer than the version I can see in the portal – also with azure cli or powershell, the newest version is missing – i only see the previous one.Has anyone else experienced this issue? Last time they had to redeploy something in westeuropeBut i guess this is no coincidenceThanks if somebody can share there experience or can help… Read More
ASP.NET MVC4 to ASP.NET Core 8
Question:
Should replace our DevExpress controls with supported .NET 8 controls?
What are our options going forward?
Background
We are migrating ASP.NET 4 MVC to ASP.NET Core 8. Our application has DevExpress controls which underneath uses System.Web(.NET Framework 4.8). DevExpress controls use System.Web assembly or extend System.Web.UI.Control from that library. Regarding documentation ASP.NET Core 8 doesn’t support System.Web.UI.Controls. And our code doesn’t compile because of that.
Question: Should replace our DevExpress controls with supported .NET 8 controls?What are our options going forward? BackgroundWe are migrating ASP.NET 4 MVC to ASP.NET Core 8. Our application has DevExpress controls which underneath uses System.Web(.NET Framework 4.8). DevExpress controls use System.Web assembly or extend System.Web.UI.Control from that library. Regarding documentation ASP.NET Core 8 doesn’t support System.Web.UI.Controls. And our code doesn’t compile because of that. Read More
Lookup and Iterate
I have a dataset that i would like to use to lookup but I need to iterate between set values such as 1:03 that falls between 1:00 and 1:05 AFTER my time of concentration is greater than 1 hr. Any help would be greatly appreciated.
D=0.48Duration of rainfall event (hours)SI=0.02Slope of longest flow path (elevation difference between 10% and 85% of path length, divided by .75L)Tc=00:29Time of concentration (This is the cell that is looked up on the table Column A)*Tc is calculated using equation that assumes grass and aggregate-lined roads and ditches Recurrence Interval
(Intensity) first lookup value
=LOOKUP(B19,’Riley County Rainfall Intensity’!A2:A117,’Riley County Rainfall Intensity’!B2:B117)
(Discharge)
(inches/hr)Qt (cfs)2 year2.54 132 5 year3.1926510 year3.7539025 year4.5659850 year4.86698100 year5.89919
Table Referenced
Time2yr5yr10yr25yr50yr100yr00:055.797.268.5310.3711.8513.3800:065.356.717.899.5810.9512.3600:0756.277.378.9510.2311.5500:084.715.96.948.439.6310.8800:094.465.596.577.989.1210.300:104.245.316.257.598.679.7900:114.045.075.967.248.279.3400:123.864.855.76.927.918.9300:133.714.655.476.657.598.5700:143.574.485.266.47.318.2500:153.444.325.086.177.057.9600:163.344.194.935.996.847.7200:173.254.084.795.826.657.5100:183.163.974.675.676.477.3100:193.093.874.555.536.317.1300:203.013.784.445.46.166.9600:212.943.694.345.276.026.800:222.883.614.245.155.896.6500:232.813.534.155.045.766.500:242.753.464.064.945.646.3700:252.73.393.984.845.536.2400:262.643.323.94.745.426.1200:272.593.253.834.655.31600:282.543.193.754.565.215.8900:292.493.133.684.485.125.7800:302.443.073.614.395.025.6800:312.43.023.554.324.945.5800:322.362.973.494.254.865.4900:332.322.923.434.184.785.4100:342.282.873.384.114.715.3200:352.252.823.324.054.635.2400:362.212.783.273.984.565.1600:372.182.733.223.924.495.0900:382.142.693.173.864.425.0100:392.112.653.123.84.364.9400:402.082.613.073.754.34.8700:412.052.573.033.694.234.800:422.022.532.983.644.174.7300:431.992.492.943.594.124.6700:441.962.462.93.544.064.6100:451.932.422.863.4944.5400:461.92.392.823.443.954.4800:471.882.362.783.393.94.4300:481.852.322.743.353.854.3700:491.822.292.73.313.84.3100:501.82.262.673.263.754.2600:511.782.232.633.223.74.2100:521.752.22.63.183.664.1600:531.732.172.573.143.614.1100:541.712.152.533.13.574.0600:551.692.122.53.063.524.0100:561.672.092.473.033.483.9600:571.652.072.442.993.443.9200:581.632.042.412.953.43.8700:591.612.022.382.923.363.8301:001.5922.362.893.323.7801:051.511.892.242.743.163.601:101.441.82.132.613.013.4301:151.371.722.032.52.883.2801:201.311.651.942.392.753.1401:251.261.581.862.292.643.0201:301.211.511.792.22.542.901:351.161.461.722.122.452.7901:401.121.41.662.042.362.6901:451.081.351.61.972.282.601:501.041.311.551.912.22.5201:551.011.271.51.852.132.4402:000.981.231.451.792.072.3702:050.951.191.411.742.012.302:100.921.161.371.691.962.2402:150.91.131.341.651.912.1802:200.871.11.31.61.862.1302:250.851.071.271.561.812.0802:300.831.041.241.531.772.0302:350.811.021.211.491.731.9802:400.7911.181.461.691.9402:450.770.971.151.421.651.902:500.760.951.131.391.621.8602:550.740.931.11.361.581.8203:000.730.911.081.341.551.7803:150.680.861.021.261.461.6803:300.650.810.971.191.391.5903:450.610.770.921.131.321.5204:000.580.740.871.081.261.4404:150.560.70.831.031.21.3804:300.530.670.80.991.151.3204:450.510.650.770.951.11.2705:000.490.620.740.911.061.2205:150.470.60.710.881.021.1705:300.460.580.680.850.981.1305:450.440.560.660.820.951.0906:000.430.540.640.790.921.0506:300.40.510.60.740.860.9907:000.380.480.570.70.810.9307:300.360.450.540.660.770.8808:000.340.430.510.630.730.8408:300.320.410.490.60.70.809:000.310.390.470.570.660.7609:300.30.380.450.550.630.7210:000.290.360.430.530.610.6910:300.270.350.410.510.580.6611:000.260.330.40.490.560.6411:300.250.320.380.470.540.6112:000.250.310.370.450.520.5913:000.230.290.340.420.490.5514:000.220.270.320.40.460.5215:000.210.260.310.370.430.4916:000.190.250.290.350.410.4617:000.190.230.270.340.380.4418:000.180.220.260.320.370.4119:000.170.210.250.30.350.3920:000.160.20.240.290.330.3821:000.160.190.230.280.320.3622:000.150.190.220.270.310.3523:000.140.180.210.260.290.3300:000.140.170.20.250.280.32
I have a dataset that i would like to use to lookup but I need to iterate between set values such as 1:03 that falls between 1:00 and 1:05 AFTER my time of concentration is greater than 1 hr. Any help would be greatly appreciated. D=0.48Duration of rainfall event (hours)SI=0.02Slope of longest flow path (elevation difference between 10% and 85% of path length, divided by .75L)Tc=00:29Time of concentration (This is the cell that is looked up on the table Column A)*Tc is calculated using equation that assumes grass and aggregate-lined roads and ditches Recurrence Interval(Intensity) first lookup value =LOOKUP(B19,’Riley County Rainfall Intensity’!A2:A117,’Riley County Rainfall Intensity’!B2:B117)(Discharge)(inches/hr)Qt (cfs)2 year2.54 132 5 year3.1926510 year3.7539025 year4.5659850 year4.86698100 year5.89919 Table Referenced Time2yr5yr10yr25yr50yr100yr00:055.797.268.5310.3711.8513.3800:065.356.717.899.5810.9512.3600:0756.277.378.9510.2311.5500:084.715.96.948.439.6310.8800:094.465.596.577.989.1210.300:104.245.316.257.598.679.7900:114.045.075.967.248.279.3400:123.864.855.76.927.918.9300:133.714.655.476.657.598.5700:143.574.485.266.47.318.2500:153.444.325.086.177.057.9600:163.344.194.935.996.847.7200:173.254.084.795.826.657.5100:183.163.974.675.676.477.3100:193.093.874.555.536.317.1300:203.013.784.445.46.166.9600:212.943.694.345.276.026.800:222.883.614.245.155.896.6500:232.813.534.155.045.766.500:242.753.464.064.945.646.3700:252.73.393.984.845.536.2400:262.643.323.94.745.426.1200:272.593.253.834.655.31600:282.543.193.754.565.215.8900:292.493.133.684.485.125.7800:302.443.073.614.395.025.6800:312.43.023.554.324.945.5800:322.362.973.494.254.865.4900:332.322.923.434.184.785.4100:342.282.873.384.114.715.3200:352.252.823.324.054.635.2400:362.212.783.273.984.565.1600:372.182.733.223.924.495.0900:382.142.693.173.864.425.0100:392.112.653.123.84.364.9400:402.082.613.073.754.34.8700:412.052.573.033.694.234.800:422.022.532.983.644.174.7300:431.992.492.943.594.124.6700:441.962.462.93.544.064.6100:451.932.422.863.4944.5400:461.92.392.823.443.954.4800:471.882.362.783.393.94.4300:481.852.322.743.353.854.3700:491.822.292.73.313.84.3100:501.82.262.673.263.754.2600:511.782.232.633.223.74.2100:521.752.22.63.183.664.1600:531.732.172.573.143.614.1100:541.712.152.533.13.574.0600:551.692.122.53.063.524.0100:561.672.092.473.033.483.9600:571.652.072.442.993.443.9200:581.632.042.412.953.43.8700:591.612.022.382.923.363.8301:001.5922.362.893.323.7801:051.511.892.242.743.163.601:101.441.82.132.613.013.4301:151.371.722.032.52.883.2801:201.311.651.942.392.753.1401:251.261.581.862.292.643.0201:301.211.511.792.22.542.901:351.161.461.722.122.452.7901:401.121.41.662.042.362.6901:451.081.351.61.972.282.601:501.041.311.551.912.22.5201:551.011.271.51.852.132.4402:000.981.231.451.792.072.3702:050.951.191.411.742.012.302:100.921.161.371.691.962.2402:150.91.131.341.651.912.1802:200.871.11.31.61.862.1302:250.851.071.271.561.812.0802:300.831.041.241.531.772.0302:350.811.021.211.491.731.9802:400.7911.181.461.691.9402:450.770.971.151.421.651.902:500.760.951.131.391.621.8602:550.740.931.11.361.581.8203:000.730.911.081.341.551.7803:150.680.861.021.261.461.6803:300.650.810.971.191.391.5903:450.610.770.921.131.321.5204:000.580.740.871.081.261.4404:150.560.70.831.031.21.3804:300.530.670.80.991.151.3204:450.510.650.770.951.11.2705:000.490.620.740.911.061.2205:150.470.60.710.881.021.1705:300.460.580.680.850.981.1305:450.440.560.660.820.951.0906:000.430.540.640.790.921.0506:300.40.510.60.740.860.9907:000.380.480.570.70.810.9307:300.360.450.540.660.770.8808:000.340.430.510.630.730.8408:300.320.410.490.60.70.809:000.310.390.470.570.660.7609:300.30.380.450.550.630.7210:000.290.360.430.530.610.6910:300.270.350.410.510.580.6611:000.260.330.40.490.560.6411:300.250.320.380.470.540.6112:000.250.310.370.450.520.5913:000.230.290.340.420.490.5514:000.220.270.320.40.460.5215:000.210.260.310.370.430.4916:000.190.250.290.350.410.4617:000.190.230.270.340.380.4418:000.180.220.260.320.370.4119:000.170.210.250.30.350.3920:000.160.20.240.290.330.3821:000.160.190.230.280.320.3622:000.150.190.220.270.310.3523:000.140.180.210.260.290.3300:000.140.170.20.250.280.32 Read More
SharePoint List JSON Formatting – Layout elements horizontally instead of vertically
How to I change the JSON below so that the elements shown in the screenshot are laid out horizontally instead of vertically?
Thank you,
Ed
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json”,
“hideSelection”: true,
“hideColumnHeader”: false,
“rowFormatter”: {
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-card”
},
“children”: [
{
“elmType”: “div”,
“style”: {
“margin-left”: “10px”,
“margin-right”: “25px”,
“height”: “130px”
},
“children”: [
{
“elmType”: “img”,
“attributes”: {
“src”: “@thumbnail.large”,
“title”: “[$Title]”
},
“style”: {
“border”: “1px solid #808080”,
“border-radius”: “2%”,
“width”: “100%”
}
}
]
},
{
“elmType”: “div”,
“style”: {
“text-align”: “left”,
“border-left”: “2px solid rgba(200, 200, 200, 0.5)”,
“padding-left”: “2px”
},
“children”: [
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-title”
},
“style”: {
“font-weight”: “semi-bold”,
“font-size”: “x-large”,
“margin-left”: “10px”
},
“txtContent”: “=if([$TalkTitle] == ”, [$FileLeafRef], [$TalkTitle])”
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “Duration: “
},
{
“elmType”: “span”,
“txtContent”: “[$Duration]”
}
]
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “DDD Year: “
},
{
“elmType”: “span”,
“txtContent”: “[$DDDYear]”
}
]
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “Speaker Name: “
},
{
“elmType”: “span”,
“txtContent”: “[$SpeakerName]”
}
]
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “Business Area: “
},
{
“elmType”: “span”,
“txtContent”: “[$BusinessArea]”
}
]
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “Product Name: “
},
{
“elmType”: “span”,
“txtContent”: “[$ProductName]”
}
]
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “General Subject/Concept: “
},
{
“elmType”: “span”,
“txtContent”: “[$GeneralSubject_x002f_Concept]”
}
]
},
{
“elmType”: “button”,
“customRowAction”: {
“action”: “defaultClick”
},
“style”: {
“width”: “150px”,
“margin-left”: “10px”,
“display”: “span”
},
“txtContent”: “Watch Now”,
“attributes”: {
“class”: “sp-row-button ms-bgColor-purple sp-row-button ms-bgColor-purpleDark–hover ms-fontWeight-semibold ms-fontColor-white”
}
},
{
“elmType”: “button”,
“customRowAction”: {
“action”: “share”
},
“style”: {
“width”: “150px”,
“margin-left”: “10px”
},
“txtContent”: “Share”,
“attributes”: {
“class”: “sp-row-button ms-bgColor-grey sp-row-button ms-bgColor-purpleDark–hover ms-fontColor-white–hover”
}
},
{
“elmType”: “button”,
“customRowAction”: {
“action”: “editProps”
},
“style”: {
“width”: “150px”,
“margin-left”: “10px”,
“display”: “span”
},
“txtContent”: “View Details”,
“attributes”: {
“class”: “sp-row-button ms-bgColor-grey sp-row-button ms-bgColor-purpleDark–hover ms-fontColor-white–hover”
}
}
]
}
]
}
}
How to I change the JSON below so that the elements shown in the screenshot are laid out horizontally instead of vertically? Thank you,Ed{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/view-formatting.schema.json”,
“hideSelection”: true,
“hideColumnHeader”: false,
“rowFormatter”: {
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-card”
},
“children”: [
{
“elmType”: “div”,
“style”: {
“margin-left”: “10px”,
“margin-right”: “25px”,
“height”: “130px”
},
“children”: [
{
“elmType”: “img”,
“attributes”: {
“src”: “@thumbnail.large”,
“title”: “[$Title]”
},
“style”: {
“border”: “1px solid #808080”,
“border-radius”: “2%”,
“width”: “100%”
}
}
]
},
{
“elmType”: “div”,
“style”: {
“text-align”: “left”,
“border-left”: “2px solid rgba(200, 200, 200, 0.5)”,
“padding-left”: “2px”
},
“children”: [
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-title”
},
“style”: {
“font-weight”: “semi-bold”,
“font-size”: “x-large”,
“margin-left”: “10px”
},
“txtContent”: “=if([$TalkTitle] == ”, [$FileLeafRef], [$TalkTitle])”
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “Duration: “
},
{
“elmType”: “span”,
“txtContent”: “[$Duration]”
}
]
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “DDD Year: “
},
{
“elmType”: “span”,
“txtContent”: “[$DDDYear]”
}
]
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “Speaker Name: “
},
{
“elmType”: “span”,
“txtContent”: “[$SpeakerName]”
}
]
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “Business Area: “
},
{
“elmType”: “span”,
“txtContent”: “[$BusinessArea]”
}
]
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “Product Name: “
},
{
“elmType”: “span”,
“txtContent”: “[$ProductName]”
}
]
},
{
“elmType”: “div”,
“attributes”: {
“class”: “sp-row-listPadding”
},
“style”: {
“margin-left”: “10px”,
“font-size”: “larger”
},
“children”: [
{
“elmType”: “span”,
“style”: {
“font-weight”: “bold”
},
“txtContent”: “General Subject/Concept: “
},
{
“elmType”: “span”,
“txtContent”: “[$GeneralSubject_x002f_Concept]”
}
]
},
{
“elmType”: “button”,
“customRowAction”: {
“action”: “defaultClick”
},
“style”: {
“width”: “150px”,
“margin-left”: “10px”,
“display”: “span”
},
“txtContent”: “Watch Now”,
“attributes”: {
“class”: “sp-row-button ms-bgColor-purple sp-row-button ms-bgColor-purpleDark–hover ms-fontWeight-semibold ms-fontColor-white”
}
},
{
“elmType”: “button”,
“customRowAction”: {
“action”: “share”
},
“style”: {
“width”: “150px”,
“margin-left”: “10px”
},
“txtContent”: “Share”,
“attributes”: {
“class”: “sp-row-button ms-bgColor-grey sp-row-button ms-bgColor-purpleDark–hover ms-fontColor-white–hover”
}
},
{
“elmType”: “button”,
“customRowAction”: {
“action”: “editProps”
},
“style”: {
“width”: “150px”,
“margin-left”: “10px”,
“display”: “span”
},
“txtContent”: “View Details”,
“attributes”: {
“class”: “sp-row-button ms-bgColor-grey sp-row-button ms-bgColor-purpleDark–hover ms-fontColor-white–hover”
}
}
]
}
]
}
} Read More
New Blog | eDiscovery launches a modern, intuitive user experience
By ninachen
This month, we have launched a redesigned Microsoft Purview eDiscovery product experience in public preview. This improved user experience revolutionizes your data search, review and export tasks within eDiscovery. Our new user-friendly and feature-rich eDiscovery experience is not just about finding and preserving data, it’s about doing it with unprecedented efficiency and ease. The modern user experience of eDiscovery addresses some long-standing customer requests, such as enhanced search capabilities with MessageID, Sensitive Information Types (SITs) and sensitivity labels. It also introduces innovative features like draft query with Copilot and search using audit log. These changes, driven by customer feedback and our commitment to innovation, offer tangible value by saving time and reducing costs in the eDiscovery process.
The new eDiscovery experience is exclusively available in the Microsoft Purview portal. The new Microsoft Purview portal is a unified platform that streamlines data governance, data security, and data compliance across your entire data estate. It offers a more intuitive experience, allowing users to easily navigate and manage their compliance needs.
Read the full post here: eDiscovery launches a modern, intuitive user experience
By ninachen
This month, we have launched a redesigned Microsoft Purview eDiscovery product experience in public preview. This improved user experience revolutionizes your data search, review and export tasks within eDiscovery. Our new user-friendly and feature-rich eDiscovery experience is not just about finding and preserving data, it’s about doing it with unprecedented efficiency and ease. The modern user experience of eDiscovery addresses some long-standing customer requests, such as enhanced search capabilities with MessageID, Sensitive Information Types (SITs) and sensitivity labels. It also introduces innovative features like draft query with Copilot and search using audit log. These changes, driven by customer feedback and our commitment to innovation, offer tangible value by saving time and reducing costs in the eDiscovery process.
The new eDiscovery experience is exclusively available in the Microsoft Purview portal. The new Microsoft Purview portal is a unified platform that streamlines data governance, data security, and data compliance across your entire data estate. It offers a more intuitive experience, allowing users to easily navigate and manage their compliance needs.
Read the full post here: eDiscovery launches a modern, intuitive user experience Read More