Month: September 2024
Kiosk Mode for sign in and sign out with Printing ability for label
Hello Team,
I need assistance with reconfiguring a new machine in Intune with kiosk single app mode, but I’m encountering issues with a Brother label printer. How can I enable printing in kiosk mode as well? Has anyone accomplished this before, or can someone guide me on what steps to take, or is it an impossible task?
Thanks
Hello Team,I need assistance with reconfiguring a new machine in Intune with kiosk single app mode, but I’m encountering issues with a Brother label printer. How can I enable printing in kiosk mode as well? Has anyone accomplished this before, or can someone guide me on what steps to take, or is it an impossible task? Thanks Read More
Security review for Microsoft Edge version 129
We are pleased to announce the security review for Microsoft Edge, version 129!
We have reviewed the new settings in Microsoft Edge version 129 and determined that there are no additional security settings that require enforcement. The Microsoft Edge version 128 security baseline continues to be our recommended configuration which can be downloaded from the Microsoft Security Compliance Toolkit.
Microsoft Edge version 129 did not introduce any new settings therefore no spreadsheet was generated for this release.
As a friendly reminder, all available settings for Microsoft Edge are documented here, and all available settings for Microsoft Edge Update are documented here.
Please continue to give us feedback through the Security Baselines Discussion site or this post.
Microsoft Tech Community – Latest Blogs –Read More
date formts when reading csv files
My dates get scrambled.
I have a .csv file with dates in the first column in dd/mm/yy format.
If I open it in Excel the values are correctly entered as date values.
If I open it in a VB macro the dates are mangled. So 20/03/2024 appears as text whilst 03/05/2024 is converted to a date value and displays as 05/03/2024 which is incorrect. The system date format is dd/yy/mm like the file data.
How can I get all the dates converted to date values with day and month in the correct order? Is it possible to use the input wizard in the VB macro?
Any help would be most appreciated.
My dates get scrambled.I have a .csv file with dates in the first column in dd/mm/yy format.If I open it in Excel the values are correctly entered as date values.If I open it in a VB macro the dates are mangled. So 20/03/2024 appears as text whilst 03/05/2024 is converted to a date value and displays as 05/03/2024 which is incorrect. The system date format is dd/yy/mm like the file data.How can I get all the dates converted to date values with day and month in the correct order? Is it possible to use the input wizard in the VB macro?Any help would be most appreciated. Read More
Aug 2024 Recap: Azure PostgreSQL Flexible Server
Aug 2024 Recap: Azure PostgreSQL Flexible Server
This month we’ve introduced:
Reserved pricing for Intel & AMD V5 SKUs
Support for the latest Postgres minor versions
New extensions like “postgres_protobuf” and “postgresql_anonymizer”
Updates to Ansible modules and DNS record management
Enhanced migration services including support for TimescaleDB
New capabilities for Burstable SKU migrations
And more!
Dive into the details and discover how these updates can improve your database management and security. Read the full blog post :link: – https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/aug-2024-recap-azure-postgresql-flexible-server/ba-p/4238812#postgres-minor-versions
Aug 2024 Recap: Azure PostgreSQL Flexible ServerThis month we’ve introduced:
Reserved pricing for Intel & AMD V5 SKUs
Support for the latest Postgres minor versions
New extensions like “postgres_protobuf” and “postgresql_anonymizer”
Updates to Ansible modules and DNS record management
Enhanced migration services including support for TimescaleDB
New capabilities for Burstable SKU migrations
And more!
Dive into the details and discover how these updates can improve your database management and security. Read the full blog post :link: – https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/aug-2024-recap-azure-postgresql-flexible-server/ba-p/4238812#postgres-minor-versions Read More
Dev Channel update to 130.0.2835.2 is live.
Hello Insiders! We released 130.0.2835.2 to the Dev channel! This includes numerous fixes. For more details on the changes, check out the highlights below.
Added Features:
Added the ‘Custom Image Upload’ feature in the new settings appearance page.
Added a loading view icon while the PDF is loading on android.
Improved Behavior:
Fixed an issue where logging into a different MSA account would cause browser to crash on iOS.
Resolved an issue where browser crashes after installing the Dark Reader extension on Android.
Fixed a crash issue in the Passwords settings on Android.
Changed Behavior:
Fixed an issue where there was no response when closing the search result panel with the Enter key in the Favorites hub.
Resolved an issue where the Settings banner was incorrectly displayed on the Settings page, ensuring it now appears only once.
Resolved an issue where the icon badge color was incorrect with the ‘System default’ theme in dark mode within the Settings appearance.
Resolved an issue where the new group was generated successfully, but the previously generated group became ungrouped.
Fixed an issue where the close button was missing in modal dialogs.
iOS:
Fixed an issue where the font size of the ‘Microsoft Rewards’ page increased in landscape mode on iOS.
Android:
Fixed an issue where the shopping cashback page would incorrectly appear on the New Tab Page (NTP) when clicking the back button on mobile after visiting shopping websites with cashback offers.
Fixed an issue where Talk Back in the Android settings did not announce the selected state of chat and search list items.
Mac:
Resolved an issue where the toolbar would cover content below when ‘Automatically hide and show the menu bar’ was set to ‘Never’ in system settings on Mac.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri
Hello Insiders! We released 130.0.2835.2 to the Dev channel! This includes numerous fixes. For more details on the changes, check out the highlights below.
Added Features:
Added the ‘Custom Image Upload’ feature in the new settings appearance page.
Added a loading view icon while the PDF is loading on android.
Improved Behavior:
Fixed an issue where logging into a different MSA account would cause browser to crash on iOS.
Resolved an issue where browser crashes after installing the Dark Reader extension on Android.
Fixed a crash issue in the Passwords settings on Android.
Changed Behavior:
Fixed an issue where there was no response when closing the search result panel with the Enter key in the Favorites hub.
Resolved an issue where the Settings banner was incorrectly displayed on the Settings page, ensuring it now appears only once.
Resolved an issue where the icon badge color was incorrect with the ‘System default’ theme in dark mode within the Settings appearance.
Resolved an issue where the new group was generated successfully, but the previously generated group became ungrouped.
Fixed an issue where the close button was missing in modal dialogs.
iOS:
Fixed an issue where the font size of the ‘Microsoft Rewards’ page increased in landscape mode on iOS.
Android:
Fixed an issue where the shopping cashback page would incorrectly appear on the New Tab Page (NTP) when clicking the back button on mobile after visiting shopping websites with cashback offers.
Fixed an issue where Talk Back in the Android settings did not announce the selected state of chat and search list items.
Mac:
Resolved an issue where the toolbar would cover content below when ‘Automatically hide and show the menu bar’ was set to ‘Never’ in system settings on Mac.
See an issue that you think might be a bug? Remember to send that directly through the in-app feedback by heading to the … menu > Help and feedback > Send feedback and include diagnostics so the team can investigate.
Thanks again for sending us feedback and helping us improve our Insider builds.
~Gouri Read More
INCREASE VALUE ON SEPERATE SHEETS
Attention Advisor,
I am currently using excel spreadsheet for costs and quotes on customers.
I have one sheet up with part numbers and my costs on them, and what would make it very simple and beneficial for me is if I could set up separate sheets and have the costs get adjusted accordingly. For example lets say in sheet #1 it would have my cost in there, and sheet #2 it would have cost plus 10%, sheet #3 would be cost plus 20%. But if my costs change, it would be fantastic if I could adjust the price on sheet #1 and the other sheets would follow suit and adjust it automatically, rather then going into each individual sheet and adjusting every single time my cost goes up. Is anything like this a possibility?
Attention Advisor, I am currently using excel spreadsheet for costs and quotes on customers. I have one sheet up with part numbers and my costs on them, and what would make it very simple and beneficial for me is if I could set up separate sheets and have the costs get adjusted accordingly. For example lets say in sheet #1 it would have my cost in there, and sheet #2 it would have cost plus 10%, sheet #3 would be cost plus 20%. But if my costs change, it would be fantastic if I could adjust the price on sheet #1 and the other sheets would follow suit and adjust it automatically, rather then going into each individual sheet and adjusting every single time my cost goes up. Is anything like this a possibility? Read More
Sikkim Invite Code 2024: 667811500744 ( Claim Today Gift Bonus)
Sikkim Invite code is 667811500744, use this code at the time of sign up to get a free bonus of Rs.52 on. Sikkim colour prediction app lets you have fun guessing the next winning colour for a chance to earn rewards.The Sikkim is quite a fresh website, which is why, in the starting, you can get many bonuses on the Sikkim app. So, don’t hold up for long and register on the Sikkim app.
Sikkim Invite Code
Sikkim Invitation Code
667811500744
Signup Bonus
Rs. 1500
Sikkim Invite Code
667811500744
Sikkim Invitation Code 667811500744
667811500744 is a Sikkim app invite code. You will get a sign up bonus upto Rs.52 on using the code at the time of registration. You can also earn by sharing your invite code with your friends.
Sikkim offers you Daily Bonus, Weekly Bonus, Monthly Bonus, Rebate, Referral Bonus and many more advantages. Here you can easily do the Agent work also and make daily huge profits just by giving predictions to there team and make them play the games.
Sikkim Colour Prediction Game
On Sikkim Games you can play the Sikkim Colour Prediction Games in which you can either predict the Colours or the numbers as you can easily make your money 2X by predicting colours and 9X by predicting the numbers in less than 30 sec. Here, you can play Wingo, Trx Wingo, K3, 5D. On Sikkim App you can play many other games also like Aviator, Casino and many more games through which you can make daily huge money by investing your few seconds only.
About Sikkim
The Sikkim Colour Prediction app is an entertaining platform where users can predict the next winning colour or numbers. It is easy to play- simply choose a color you think will be selected, and if you are right you can easily double your money or even 10X in just 30sec. This app offers a simple way to pass the time while testing your luck. It is a popular way for those who enjoy casual games with a chance to win.
Sikkim Invite code is 667811500744, use this code at the time of sign up to get a free bonus of Rs.52 on. Sikkim colour prediction app lets you have fun guessing the next winning colour for a chance to earn rewards.The Sikkim is quite a fresh website, which is why, in the starting, you can get many bonuses on the Sikkim app. So, don’t hold up for long and register on the Sikkim app.Sikkim Invite Code Sikkim Invitation Code667811500744Signup BonusRs. 1500Sikkim Invite Code667811500744Sikkim Invitation Code 667811500744667811500744 is a Sikkim app invite code. You will get a sign up bonus upto Rs.52 on using the code at the time of registration. You can also earn by sharing your invite code with your friends.Sikkim offers you Daily Bonus, Weekly Bonus, Monthly Bonus, Rebate, Referral Bonus and many more advantages. Here you can easily do the Agent work also and make daily huge profits just by giving predictions to there team and make them play the games. Sikkim Colour Prediction Game On Sikkim Games you can play the Sikkim Colour Prediction Games in which you can either predict the Colours or the numbers as you can easily make your money 2X by predicting colours and 9X by predicting the numbers in less than 30 sec. Here, you can play Wingo, Trx Wingo, K3, 5D. On Sikkim App you can play many other games also like Aviator, Casino and many more games through which you can make daily huge money by investing your few seconds only. About SikkimThe Sikkim Colour Prediction app is an entertaining platform where users can predict the next winning colour or numbers. It is easy to play- simply choose a color you think will be selected, and if you are right you can easily double your money or even 10X in just 30sec. This app offers a simple way to pass the time while testing your luck. It is a popular way for those who enjoy casual games with a chance to win. Read More
Number assigned to Teams user is presenting INVITE wrong
I have a peculiar issue and I wonder if anyone else has had this issue or experienced anything similar.
At the tail end of migrating a company to Microsoft Teams voice, most of the issues have been rectified apart from two numbers. When ever we assign these numbers to a user, they cannot call out, assign a number and they work.
Immediately think its the SIP Provider, as in other cases the number has not been ported correctly. However from the investigation it seems on the INVITE as the number leaves teams, it is incorrect. On the offending number the P-ASSERTED-IDENTITY is showing as (tel:)
The working example given shows this as a SIP Record.
The CONTACT header is different. My Carrier has assured me the number is set up correctly and it this is coming from Teams
I have a peculiar issue and I wonder if anyone else has had this issue or experienced anything similar. At the tail end of migrating a company to Microsoft Teams voice, most of the issues have been rectified apart from two numbers. When ever we assign these numbers to a user, they cannot call out, assign a number and they work. Immediately think its the SIP Provider, as in other cases the number has not been ported correctly. However from the investigation it seems on the INVITE as the number leaves teams, it is incorrect. On the offending number the P-ASSERTED-IDENTITY is showing as (tel:)The working example given shows this as a SIP Record. The CONTACT header is different. My Carrier has assured me the number is set up correctly and it this is coming from Teams Read More
Use of Copilot to generate analytic reports from my tenancy
It would be useful to be able to use Copilot to generate usage/analytics reports from within my tenancy, without having to create Flows, PowerBI queries etc.
E.g. “Give me a list of all the files in SharePoint that have been shared with people from outside the organization. Include the date the share was created and the name of the person who created it. Tabulate these in an Excel spreadsheet.”
Try it for yourself, it doesn’t work. It gave me a small number of files in a table within the response window, and refuses to search beyond our ‘home’ SP site.
It would be useful to be able to use Copilot to generate usage/analytics reports from within my tenancy, without having to create Flows, PowerBI queries etc.E.g. “Give me a list of all the files in SharePoint that have been shared with people from outside the organization. Include the date the share was created and the name of the person who created it. Tabulate these in an Excel spreadsheet.”Try it for yourself, it doesn’t work. It gave me a small number of files in a table within the response window, and refuses to search beyond our ‘home’ SP site. Read More
Outlook search and other issues after Exchange 2019 CU14
Hi,
After Exchange 2019 CU14 users can’t:
– Search in cached mode.
– Open other users calendar.
– Set out of office.
All of the above works perfectly in OWA.
We did install the latest hotfix that should fix the search issue but no. We have installed latest outlook and reinstalled a computer, nothing helps.
Regards
Johan
Hi, After Exchange 2019 CU14 users can’t: – Search in cached mode.- Open other users calendar.- Set out of office. All of the above works perfectly in OWA. We did install the latest hotfix that should fix the search issue but no. We have installed latest outlook and reinstalled a computer, nothing helps. RegardsJohan Read More
How to recover deleted folder from OneDrive/sharepoint
I have synced my sharepoint folder in onedrive.
Onedrive was offline and not syncing with cloud due to some issue so reinstalled onedrive.
During installation i selected to sync existing directory.
After synchronization, one folder get removed from my onedrive. Is there any way to restore it ?
I have synced my sharepoint folder in onedrive.Onedrive was offline and not syncing with cloud due to some issue so reinstalled onedrive.During installation i selected to sync existing directory.After synchronization, one folder get removed from my onedrive. Is there any way to restore it ? Read More
Pipeline Error for SSIS
We are currently upgrading from a SQL 2012 Server to SQL 2022 on Windows Server 2022. We are using ODBC in SSIS to connect to an AS400 database. Our projects are currently set to a deployment version of SQL 2012. As long as we don’t change that setting, the packages run fine in Visual Studio 2019 with the latest SSIS extension. But, they do not work when deployed to SQL 2022.
When we deployed to our SQL 2022 server, or upgraded to a deployment server level of SQL 2019 or 2022 in Visual Studio, we received “Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on xxxxx returned error code 0x80004005…” All parts of the data flow task have green check marks, but the DFT as a whole fails and the error is in the Progress tab.
Any ideas on what we can do to get this to work on our new server?
If we add a source without a destination, it doesn’t error out. As soon as we add any destination, the error occurs when deployed or when the project deployment server is set to SQL 2019 or higher. This makes sense to me since the pipeline probably isn’t initiated until a destination is added.
We are currently upgrading from a SQL 2012 Server to SQL 2022 on Windows Server 2022. We are using ODBC in SSIS to connect to an AS400 database. Our projects are currently set to a deployment version of SQL 2012. As long as we don’t change that setting, the packages run fine in Visual Studio 2019 with the latest SSIS extension. But, they do not work when deployed to SQL 2022. When we deployed to our SQL 2022 server, or upgraded to a deployment server level of SQL 2019 or 2022 in Visual Studio, we received “Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on xxxxx returned error code 0x80004005…” All parts of the data flow task have green check marks, but the DFT as a whole fails and the error is in the Progress tab. Any ideas on what we can do to get this to work on our new server? If we add a source without a destination, it doesn’t error out. As soon as we add any destination, the error occurs when deployed or when the project deployment server is set to SQL 2019 or higher. This makes sense to me since the pipeline probably isn’t initiated until a destination is added. Read More
How to generate report of all distribution list usage over 90 days
Hello,
I am looking for an Exchange online Powershell script/command to run a report for how frequently all of our distribution lists are used over a 90 day period (if there is a way to generate the report in EAC that would be great too). I have found out how to run the report for 10 days, but I cannot find a command or way to generate further in the past. Any help would be appreciated, thank you.
Hello, I am looking for an Exchange online Powershell script/command to run a report for how frequently all of our distribution lists are used over a 90 day period (if there is a way to generate the report in EAC that would be great too). I have found out how to run the report for 10 days, but I cannot find a command or way to generate further in the past. Any help would be appreciated, thank you. Read More
Your thoughts serializing arrays to manage state in excel (by way of inventory tracking)
I’m curious what you all think of this approach for managing state in excel with minimal computational impact. I’m sure after a few thousand different items to track, performance may be implicated, but the formulas initially feel like they will create static values that don’t have to be recalculated with any frequency. Skip towards the end if you just want to see the formulas.
I think one of the important ideas here is that this formula can be used within a table column the same as any other formula that doesn’t return an array, the difference being that calculations are not lost between steps of the row and the only information a calculation needs is the limited state info in the prior state.
Any comments welcome. If you’ve found a better way to do this, I’d be curious to know. I am limiting myself to using only native excel formulas/functionality plus excel labs.
P.S. The formulas have one or two undeveloped ideas because they are not essential. For instance, there is one inline lambda that uses a switch to return a comparison function for data masking that has only implemented the equals and does not equal operators.
**********Description********************
General idea is such – write a series of formulas that serialize and deserialize arrays and combine it with an efficient mechanism to access the most recent state. The example uses the idea of lots of items where each lot has a quantity and cost – transactions can either increase the quantity (and cost) or decrease it. The state being managed is the existent lots, their quantities, and their costs.
columns are simple:
control; date; lot; qty; cost; state
So here is the overall structure:
table formula checks control column to see if the current row impacts the state –
if it doesn’t, return nothing,
if it does, move on
if it is the first control number, just serialize the row data
if it isn’t, find the prior state and update it
The way it updates the state is by
1) deserializing the prior state
2) determining whether the prior state already included the current row’s item
3) updating that value if so or just returning the current rows values,
4) filtering the prior state to remove the current row’s item
5) vstacking the filtered array onto the current row’s entry (potentially updated), and
6) serializing the current state.
Using 40 rows as an example, I might end with a serialized state that looks like this:
lot_H,65,650;lot_I,100,1000;lot_J,45,450;lot_K,70,700;lot_L,30,300;lot_A,135,1350;lot_B,150,1500;lot_C,145,1450;lot_D,90,900;lot_E,120,1200;lot_F,80,800;lot_G,170,1700
and deserializes to this:
lot_A 135 1350
lot_B 150 1500
lot_C 145 1450
lot_D 90 900
lot_E 120 1200
lot_F 80 800
lot_G 170 1700
lot_H 65 650
lot_I 100 1000
lot_J 45 450
lot_K 70 700
lot_L 30 300
using this function: SORT(array.deserialize_string(I57))
table formula:
=IF(
TRIM([@lot]) = “”,
“”,
IF(
[@control] = 1,
array.serialize_array(Table68[@[lot]:[cost]]),
LET(
current_trans, Table68[@[lot]:[cost]],
last_state_ctrl, MAX(
FILTER([control], ([control] < [@control]) * ([lot] <> “”) * (2024 <= [@date])),
1
),
last_state, XLOOKUP(last_state_ctrl, [control], [state], “”, 0),
array.serialize_array(array.track_state(array.deserialize_string(last_state), current_trans))
)
)
)
module formulas:
deserialize_string = LAMBDA(state_string, TEXTSPLIT(state_string, “,”, “;”, FALSE));
serialize_row = LAMBDA(row, TEXTJOIN(“,”, FALSE, row));
serialize_array = LAMBDA(state_array,
REDUCE(
,
BYROW(state_array, LAMBDA(r, serialize_row(r))),
LAMBDA(acc, current_row, acc & “;” & current_row)
)
);
serialized_wrapper = lambda(state_string, func_to_apply, serialize_array(func_to_apply(deserialize_string(state_string))));
replace_row =
lambda(
new_row,
original_array,
[replacement_col_idx],
let(
idx_col, if(isomitted(replacement_col_idx), 1, replacement_col_idx),
data_mask, choosecols(new_row, idx_col) <> choosecols(original_array,idx_col),
filtered_array, filter(original_array, data_mask),
hstack(filtered_array, replace_row)
)
);
columnMask =
lambda(
value,
comp_to_array,
[comparison_operator],
[column_idx],
[value_idx],
let(
operator, if(isomitted(comparison_operator),”=”,comparison_operator),
comp_func, lambda(operator, lambda(value, comp_array, switch(operator, “=”, value=comp_array, “<>”, value<>comp_array,”Not yet implimented”))),
col_idx, if(isomitted(column_idx), 1, column_idx),
val_idx, if(isomitted(value_idx), 1, value_idx),
adj_value, if(COLUMNS(value)>1, CHOOSECOLS(value, val_idx), value),
comp_col, choosecols(comp_to_array, col_idx),
comp_func(operator)(adj_value, comp_col)
)
);
track_state =
lambda(
last_state_string, current_trans,
LET(
lots, array.deserialize_string(last_state_string),
lot_to_add, INDEX(current_trans, 1, 1),
prior_lot_values, IFERROR(
FILTER(lots, array.columnMask(lot_to_add, lots), ERROR.TYPE(3)),
ERROR.TYPE(3)
),
filtered_array, FILTER(lots, array.columnMask(lot_to_add, lots, “<>”), ERROR.TYPE(3)),
replacement_line, IF(
ISNA(prior_lot_values),
current_trans,
HSTACK(
lot_to_add,
(INDEX(prior_lot_values, 1, 2) + INDEX(current_trans, 1, 2)),
(INDEX(prior_lot_values, 1, 3) + INDEX(current_trans, 1, 3))
)
),
final_array, IF(
OR(TRIM(last_state_string) = “”),
replacement_line,
IF(OR(ISNA(filtered_array)), replacement_line, VSTACK(filtered_array, replacement_line))
),
final_array
)
);
I’m curious what you all think of this approach for managing state in excel with minimal computational impact. I’m sure after a few thousand different items to track, performance may be implicated, but the formulas initially feel like they will create static values that don’t have to be recalculated with any frequency. Skip towards the end if you just want to see the formulas. I think one of the important ideas here is that this formula can be used within a table column the same as any other formula that doesn’t return an array, the difference being that calculations are not lost between steps of the row and the only information a calculation needs is the limited state info in the prior state.Any comments welcome. If you’ve found a better way to do this, I’d be curious to know. I am limiting myself to using only native excel formulas/functionality plus excel labs. P.S. The formulas have one or two undeveloped ideas because they are not essential. For instance, there is one inline lambda that uses a switch to return a comparison function for data masking that has only implemented the equals and does not equal operators. **********Description******************** General idea is such – write a series of formulas that serialize and deserialize arrays and combine it with an efficient mechanism to access the most recent state. The example uses the idea of lots of items where each lot has a quantity and cost – transactions can either increase the quantity (and cost) or decrease it. The state being managed is the existent lots, their quantities, and their costs. columns are simple:control; date; lot; qty; cost; state So here is the overall structure:table formula checks control column to see if the current row impacts the state – if it doesn’t, return nothing, if it does, move on if it is the first control number, just serialize the row data if it isn’t, find the prior state and update it The way it updates the state is by1) deserializing the prior state2) determining whether the prior state already included the current row’s item3) updating that value if so or just returning the current rows values,4) filtering the prior state to remove the current row’s item5) vstacking the filtered array onto the current row’s entry (potentially updated), and6) serializing the current state. Using 40 rows as an example, I might end with a serialized state that looks like this:lot_H,65,650;lot_I,100,1000;lot_J,45,450;lot_K,70,700;lot_L,30,300;lot_A,135,1350;lot_B,150,1500;lot_C,145,1450;lot_D,90,900;lot_E,120,1200;lot_F,80,800;lot_G,170,1700and deserializes to this: lot_A 135 1350lot_B 150 1500lot_C 145 1450lot_D 90 900lot_E 120 1200lot_F 80 800lot_G 170 1700lot_H 65 650lot_I 100 1000lot_J 45 450lot_K 70 700lot_L 30 300 using this function: SORT(array.deserialize_string(I57)) table formula:
=IF(
TRIM([@lot]) = “”,
“”,
IF(
[@control] = 1,
array.serialize_array(Table68[@[lot]:[cost]]),
LET(
current_trans, Table68[@[lot]:[cost]],
last_state_ctrl, MAX(
FILTER([control], ([control] < [@control]) * ([lot] <> “”) * (2024 <= [@date])),
1
),
last_state, XLOOKUP(last_state_ctrl, [control], [state], “”, 0),
array.serialize_array(array.track_state(array.deserialize_string(last_state), current_trans))
)
)
)
module formulas:
deserialize_string = LAMBDA(state_string, TEXTSPLIT(state_string, “,”, “;”, FALSE));
serialize_row = LAMBDA(row, TEXTJOIN(“,”, FALSE, row));
serialize_array = LAMBDA(state_array,
REDUCE(
,
BYROW(state_array, LAMBDA(r, serialize_row(r))),
LAMBDA(acc, current_row, acc & “;” & current_row)
)
);
serialized_wrapper = lambda(state_string, func_to_apply, serialize_array(func_to_apply(deserialize_string(state_string))));
replace_row =
lambda(
new_row,
original_array,
[replacement_col_idx],
let(
idx_col, if(isomitted(replacement_col_idx), 1, replacement_col_idx),
data_mask, choosecols(new_row, idx_col) <> choosecols(original_array,idx_col),
filtered_array, filter(original_array, data_mask),
hstack(filtered_array, replace_row)
)
);
columnMask =
lambda(
value,
comp_to_array,
[comparison_operator],
[column_idx],
[value_idx],
let(
operator, if(isomitted(comparison_operator),”=”,comparison_operator),
comp_func, lambda(operator, lambda(value, comp_array, switch(operator, “=”, value=comp_array, “<>”, value<>comp_array,”Not yet implimented”))),
col_idx, if(isomitted(column_idx), 1, column_idx),
val_idx, if(isomitted(value_idx), 1, value_idx),
adj_value, if(COLUMNS(value)>1, CHOOSECOLS(value, val_idx), value),
comp_col, choosecols(comp_to_array, col_idx),
comp_func(operator)(adj_value, comp_col)
)
);
track_state =
lambda(
last_state_string, current_trans,
LET(
lots, array.deserialize_string(last_state_string),
lot_to_add, INDEX(current_trans, 1, 1),
prior_lot_values, IFERROR(
FILTER(lots, array.columnMask(lot_to_add, lots), ERROR.TYPE(3)),
ERROR.TYPE(3)
),
filtered_array, FILTER(lots, array.columnMask(lot_to_add, lots, “<>”), ERROR.TYPE(3)),
replacement_line, IF(
ISNA(prior_lot_values),
current_trans,
HSTACK(
lot_to_add,
(INDEX(prior_lot_values, 1, 2) + INDEX(current_trans, 1, 2)),
(INDEX(prior_lot_values, 1, 3) + INDEX(current_trans, 1, 3))
)
),
final_array, IF(
OR(TRIM(last_state_string) = “”),
replacement_line,
IF(OR(ISNA(filtered_array)), replacement_line, VSTACK(filtered_array, replacement_line))
),
final_array
)
); Read More
Partner Blog | IDC study on partner profitability with Microsoft AI
Microsoft Tech Community – Latest Blogs –Read More
How to change date & year setting for timeline slicer after using pivot table
I have a data from October 2023, but when I am using timeline slicer, it shows me from Jan 2023. I want to fix this.
I have a data from October 2023, but when I am using timeline slicer, it shows me from Jan 2023. I want to fix this. Read More
More menu missing when viewing app on iOS
I have a static tab app where I have noticed that the more menu (i.e. the ellipsis at the top right of the screen) is no longer appearing when running the app in Teams in iOS. The more menu appears in the app in Android, desktop, and web. I looked at another static app I created and observe the same.
Is this a change in Teams for iOS? If so, how do users navigate to the About or reload functionalities?
I have a static tab app where I have noticed that the more menu (i.e. the ellipsis at the top right of the screen) is no longer appearing when running the app in Teams in iOS. The more menu appears in the app in Android, desktop, and web. I looked at another static app I created and observe the same.Is this a change in Teams for iOS? If so, how do users navigate to the About or reload functionalities? Read More
Entra ID Group Writeback Option Missing from Portal Web Interface
Yesterday in the middle of the day, the group writeback option for Azure AD (Entra ID) security groups and M365 groups was removed from the properties section for each group. (It’s normally below the “Microsoft Entra roles can be assigned to the group” y/n). This is regardless of whether you utilize portal.azure.com or entra.microsoft.com.
I had connected to the portal earlier in the day and saw it, then re-authed later in the day and it was gone for all groups. This was verified by a co-worker.
You can still see the writeback option via the group ‘list’ by adding the writeback column (i.e. Home -> Groups -> All Groups -> Manage View -> Edit Columns), but I’m curious if this was an intended change? I’ve heard that group writeback support might be going away from Entra ID Connect in favor of Entra Cloud Sync, but that shouldn’t affect the actual group attribute for the writeback status within the Azure portal.
When searching, I haven’t found anything mentioning the change so I was curious if anyone knew something that I couldn’t find.
Thanks.
Yesterday in the middle of the day, the group writeback option for Azure AD (Entra ID) security groups and M365 groups was removed from the properties section for each group. (It’s normally below the “Microsoft Entra roles can be assigned to the group” y/n). This is regardless of whether you utilize portal.azure.com or entra.microsoft.com. I had connected to the portal earlier in the day and saw it, then re-authed later in the day and it was gone for all groups. This was verified by a co-worker. You can still see the writeback option via the group ‘list’ by adding the writeback column (i.e. Home -> Groups -> All Groups -> Manage View -> Edit Columns), but I’m curious if this was an intended change? I’ve heard that group writeback support might be going away from Entra ID Connect in favor of Entra Cloud Sync, but that shouldn’t affect the actual group attribute for the writeback status within the Azure portal. When searching, I haven’t found anything mentioning the change so I was curious if anyone knew something that I couldn’t find. Thanks. Read More
Apparent MX issue impacting only one email account and only if sourced from OUTLOOK.COM
I have had an issue for years with email not being received to my Godaddy registered domain with an email hosted by Google. The common element is that the non-received emails are all sent from OUTLOOK.COM. These messages are not received in my inbox or spam. If I log into OUTLOOK.COM using that email address as the UID I see a blank screen, no sent or received emails at all. From my perspective, this seems to be an internal OUTLOOK.COM MX misconfiguration. Has anyone seen anything like this before? Who should I contact to try to resolve this issue?
PS: As a test to prove this issue, I would appreciate someone from the community to source an email from OUTLOOK.COM to two different emails on the domain; one will be received, and the other will not. Let me know if you would be willing to help me test this, and I will PM a reply with the email addresses.
Thanks
I have had an issue for years with email not being received to my Godaddy registered domain with an email hosted by Google. The common element is that the non-received emails are all sent from OUTLOOK.COM. These messages are not received in my inbox or spam. If I log into OUTLOOK.COM using that email address as the UID I see a blank screen, no sent or received emails at all. From my perspective, this seems to be an internal OUTLOOK.COM MX misconfiguration. Has anyone seen anything like this before? Who should I contact to try to resolve this issue? PS: As a test to prove this issue, I would appreciate someone from the community to source an email from OUTLOOK.COM to two different emails on the domain; one will be received, and the other will not. Let me know if you would be willing to help me test this, and I will PM a reply with the email addresses. Thanks Read More
I2C WriteRead with no restart, IoT libraries and FT4232H device
Hi everyone,
I am porting an app and trying to use the FTDI Ft4232H device to communicate to some I2C devices.
When I use the “old” dongle(going to be obsolete) and I2C call to the device, I get the correct transaction and read results from the device.
However, when I use the IoT libraries and the “WriteRead” command to do the same thing, the library issues a restart and the transaction fails.
Can anyone help or point me to:
A library that does a correct multi byte read without a restart?A way to do this with the current IoT libraries?
Here are the “using” statements in my C# code:
using Iot.Device.FtCommon;
using Iot.Device.Ft4232H;
using System.Device.I2c;
Cheers,
Steve
Hi everyone,I am porting an app and trying to use the FTDI Ft4232H device to communicate to some I2C devices.When I use the “old” dongle(going to be obsolete) and I2C call to the device, I get the correct transaction and read results from the device. However, when I use the IoT libraries and the “WriteRead” command to do the same thing, the library issues a restart and the transaction fails.Can anyone help or point me to:A library that does a correct multi byte read without a restart?A way to do this with the current IoT libraries?Here are the “using” statements in my C# code:using Iot.Device.FtCommon;using Iot.Device.Ft4232H;using System.Device.I2c; Cheers,Steve Read More