Tag Archives: microsoft
Auto-populate a column in one list from a source in a lookup list
I have a list built with the new SharePoint list template called “Approvals Content Scheduler With Approvals” (the target list) and the list is called Timesheet. The purpose is for an employee to log time for a given week and the time is entered into a column as a number. By default, this list has a column named “Author” (Employee) and “Approver” (Person selected to approve).
In a separate lookup list (the source), I have two columns; Employee (which would be the Author in this case) and their manager in the second column named “Manager”.
When an employee creates a new item in the Timesheet list (the target list), the employee becomes the Author, and whomever they selected as the approver becomes the “Approver”. In addition to these two columns, I have created a new column in the Timesheet list (the target list) called “Manager”.
The scenario: When an employee enters a new item in the Timesheet (the target list), I want to use the lookup list (the source list) to grab the Manager’s name and auto-populate this name into the Manager column in the target list.
The lookup list (source) has one column for the employee’s name and one column with the name of their manager. How do I get the name of the employee’s manager to auto-populate the Manager column in the Timesheet list (target list)? Basically, I want to use the lookup list to determine who the manager is for the employee and insert the Manager’s name in the Manager column in the target list. I don’t want the user (Employee) to make the selection.
I have a list built with the new SharePoint list template called “Approvals Content Scheduler With Approvals” (the target list) and the list is called Timesheet. The purpose is for an employee to log time for a given week and the time is entered into a column as a number. By default, this list has a column named “Author” (Employee) and “Approver” (Person selected to approve). In a separate lookup list (the source), I have two columns; Employee (which would be the Author in this case) and their manager in the second column named “Manager”. When an employee creates a new item in the Timesheet list (the target list), the employee becomes the Author, and whomever they selected as the approver becomes the “Approver”. In addition to these two columns, I have created a new column in the Timesheet list (the target list) called “Manager”. The scenario: When an employee enters a new item in the Timesheet (the target list), I want to use the lookup list (the source list) to grab the Manager’s name and auto-populate this name into the Manager column in the target list. The lookup list (source) has one column for the employee’s name and one column with the name of their manager. How do I get the name of the employee’s manager to auto-populate the Manager column in the Timesheet list (target list)? Basically, I want to use the lookup list to determine who the manager is for the employee and insert the Manager’s name in the Manager column in the target list. I don’t want the user (Employee) to make the selection. Read More
Excel Filter() Function Skipping Data
Hello all!
I am completing an analysis based on a very large master data set (around 50.,000 rows). I have encountered an issue in one specific calculation I am trying to program. Basically, a part of my algorithm for this calculation is using the Filter() function to find specific values based on an ID and two other criteria. However, I noticed that many expected values for a test cell with the formula were missing (e.g., I expected a dozen rows to return for this test cell but only 5 or so results would appear. I managed to find a very specific test example with a small subset of the data I have that gives the same error:
Formula is: =FILTER(DB!W$18844:W$18850;DB!H$18844:H$18850=A2;0), A2 is 102158
Data pulled directly from my report (apologies, I use the French Canadian version of Excel which uses commas and not periods for decimals):
HW188441021582232,1188451021580188461021580188471021580188481021580188491021580188501021580
This results in only row 18844 and 18848 being pulled by the Filter function, giving 2232,1 and 0
I have checked the “Evaluate Formula” tool and it successfully matches the ID number (column H) to all 7 rows as it gives the array {TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE} at the step where it compares A2 to the range provided and it does not provide any further calculation steps after this. I have no idea what to check next to find the source of the error. Any ideas?
Thanks!
Hello all! I am completing an analysis based on a very large master data set (around 50.,000 rows). I have encountered an issue in one specific calculation I am trying to program. Basically, a part of my algorithm for this calculation is using the Filter() function to find specific values based on an ID and two other criteria. However, I noticed that many expected values for a test cell with the formula were missing (e.g., I expected a dozen rows to return for this test cell but only 5 or so results would appear. I managed to find a very specific test example with a small subset of the data I have that gives the same error: Formula is: =FILTER(DB!W$18844:W$18850;DB!H$18844:H$18850=A2;0), A2 is 102158 Data pulled directly from my report (apologies, I use the French Canadian version of Excel which uses commas and not periods for decimals): HW188441021582232,1188451021580188461021580188471021580188481021580188491021580188501021580 This results in only row 18844 and 18848 being pulled by the Filter function, giving 2232,1 and 0I have checked the “Evaluate Formula” tool and it successfully matches the ID number (column H) to all 7 rows as it gives the array {TRUE; TRUE; TRUE; TRUE; TRUE; TRUE; TRUE} at the step where it compares A2 to the range provided and it does not provide any further calculation steps after this. I have no idea what to check next to find the source of the error. Any ideas? Thanks! Read More
Variable Performance when Creating or Removing Shortcut Folders for SharePoint libraries
When using the “Add shortcut to OneDrive” feature for a SharePoint online library or folder, we experience inconsistent performance with the local OneDrive sync application creating/initializing the local “shortcut folder”. Sometimes the sync application processes “changes” very quickly–100s of changes per second. And sometimes it does so very slowly–10s (or less) changes per second.
We experience the same inconsistent behavior when removing a “shortcut folder”–sometimes it’s fast and sometimes it’s slow.
In my testing, the difference cannot be attributed to either the specific SharePoint library/folder or the the specific client machine. On my own machine, I have seen both the fast and slow behavior when creating a “shortcut folder” for the same SharePoint library.
Can anyone provide any insight on what might be causing this inconsistent performance?
Could any service limits be coming into play?
https://learn.microsoft.com/en-us/graph/throttling-limits#files-and-lists-service-limits
Environment: Large SharePoint online libraries; Windows 11 client machines; current PROD ring OneDrive sync applications; Files On-Demand enforced via group policy; no rate limiting used for the local sync application.
When using the “Add shortcut to OneDrive” feature for a SharePoint online library or folder, we experience inconsistent performance with the local OneDrive sync application creating/initializing the local “shortcut folder”. Sometimes the sync application processes “changes” very quickly–100s of changes per second. And sometimes it does so very slowly–10s (or less) changes per second.We experience the same inconsistent behavior when removing a “shortcut folder”–sometimes it’s fast and sometimes it’s slow. In my testing, the difference cannot be attributed to either the specific SharePoint library/folder or the the specific client machine. On my own machine, I have seen both the fast and slow behavior when creating a “shortcut folder” for the same SharePoint library. Can anyone provide any insight on what might be causing this inconsistent performance?Could any service limits be coming into play?https://learn.microsoft.com/en-us/graph/throttling-limits#files-and-lists-service-limits Environment: Large SharePoint online libraries; Windows 11 client machines; current PROD ring OneDrive sync applications; Files On-Demand enforced via group policy; no rate limiting used for the local sync application. Read More
WARNING for users of Dropbox (Beta) integration with Microsoft 365/Word
Anyone concerned with the “last modified date” of their files should NOT use the Dropbox (Beta) integration sent out by Dropbox earlier in the week. Once the Beta is installed in Word, it will alter the dates of every file you open, even if you do nothing to the file. If the last modified date was, say, June 27, opening the file merely to look at, making NO changes, the last modified date will change to the date you open the file. The problem occurs in Mac and Windows.
This is a disaster for law offices, which count on the last modified dates in a number of ways.
Anyone concerned with the “last modified date” of their files should NOT use the Dropbox (Beta) integration sent out by Dropbox earlier in the week. Once the Beta is installed in Word, it will alter the dates of every file you open, even if you do nothing to the file. If the last modified date was, say, June 27, opening the file merely to look at, making NO changes, the last modified date will change to the date you open the file. The problem occurs in Mac and Windows. This is a disaster for law offices, which count on the last modified dates in a number of ways. Read More
Outlook on IMAC Issue
have an odd issue, screenshot below: the user when they respond or create a new email to a user they get this redbox with an ! in it and the first letter of the username. after deleting it and retyping its not longer an issue.. was just curious if anyone else has experience this before?
have an odd issue, screenshot below: the user when they respond or create a new email to a user they get this redbox with an ! in it and the first letter of the username. after deleting it and retyping its not longer an issue.. was just curious if anyone else has experience this before? Read More
Microsoft edge windows 10
how do i keep signed in, when i want to comment on a news item, i always have to sign in? thank you.
how do i keep signed in, when i want to comment on a news item, i always have to sign in? thank you. Read More
365 pro plus (university) + privat acc copilot pro -> error code 44
Hello!
I use a business acc with 365 proplus (from my university FU Berlin) and I would like to add copilot pro. I subscribed for copilot pro with my privat e-mail. But now the desktop app doesn’t allow to add copilot functionality. I get the error code 44 when I try.
What can I do? I don’t want to buy a full private Office version 365 just to use copilot when I already have access through my university. But this account doesn’t let me add copilot to the plan. Is it impossible to combine two accounts to use word 365 with copilot?
Hello! I use a business acc with 365 proplus (from my university FU Berlin) and I would like to add copilot pro. I subscribed for copilot pro with my privat e-mail. But now the desktop app doesn’t allow to add copilot functionality. I get the error code 44 when I try. What can I do? I don’t want to buy a full private Office version 365 just to use copilot when I already have access through my university. But this account doesn’t let me add copilot to the plan. Is it impossible to combine two accounts to use word 365 with copilot? Read More
Conditional Formatting with dates and highlights
I am writing a workbook and need a conditional formula that highlights due dates the month before they are due in yellow and stays yellow until the due date. Then changes to a pink color if overdue. I have a cell showing the current date, is there a way to use that cell in the formula?
I am writing a workbook and need a conditional formula that highlights due dates the month before they are due in yellow and stays yellow until the due date. Then changes to a pink color if overdue. I have a cell showing the current date, is there a way to use that cell in the formula? Read More
How to revoke consent for a registered app programmatically?
Hello,
I’ve been struggling with this issue for days. Tried many different endpoints and mostly got back cryptic errors only. Overall, zero progress. So, I really hope that someone here can help me out.
I have a very simple application where users can sync their calendars and also receive new events directly into the calendar. I acquire “Calendars.ReadWrite, offline_access, User.Read” delegated permissions interactively.
When the users decide to stop using my application, they can “unlink” and I will drop all the events, hooks, etc. What I am trying to achieve is that my third-party app would also disappear from the list of apps presented here: https://account.live.com/consent/Manage. In other words, a complete cleanup, revoking any access permissions, dropping all tokens, etc.
It seems a very basic scenario. Google Calendar has a simple endpoint that can do exactly that: https://oauth2.googleapis.com/revoke?token=<TOKEN>. What am I missing? How can I do that? I am running out of ideas about what I can do with revokeSignInSessions and oAuth2PermissionGrant; it seems like I tried everything and nothing worked. It must be a common requirement, no?
Thanks for reading this post! Any help is appreciated.
Regards,
Hello, I’ve been struggling with this issue for days. Tried many different endpoints and mostly got back cryptic errors only. Overall, zero progress. So, I really hope that someone here can help me out. I have a very simple application where users can sync their calendars and also receive new events directly into the calendar. I acquire “Calendars.ReadWrite, offline_access, User.Read” delegated permissions interactively. When the users decide to stop using my application, they can “unlink” and I will drop all the events, hooks, etc. What I am trying to achieve is that my third-party app would also disappear from the list of apps presented here: https://account.live.com/consent/Manage. In other words, a complete cleanup, revoking any access permissions, dropping all tokens, etc. It seems a very basic scenario. Google Calendar has a simple endpoint that can do exactly that: https://oauth2.googleapis.com/revoke?token=<TOKEN>. What am I missing? How can I do that? I am running out of ideas about what I can do with revokeSignInSessions and oAuth2PermissionGrant; it seems like I tried everything and nothing worked. It must be a common requirement, no? Thanks for reading this post! Any help is appreciated.Regards, Read More
Printers lose connection to Universal Printer Server
We have 6 new Canon printers MF751dw that are directly connected to Universal Print service. If there is ever a network outage or disconnection anywhere the printers lose connectivity and do not reconnect to UP. They are connected to the network as I can access the printer configuration web page. We have to power cycle the printers to reconnect them to UP. I easily duplicate this problem by unplugging the ethernet from a printer then plugging it back in. The network connection is ok however, it does not reconnect to UP and they only way to reconnect it is to power cycle the printer. It happens on every printer that we have connected to UP. Is there a way to change this behavior?
We have 6 new Canon printers MF751dw that are directly connected to Universal Print service. If there is ever a network outage or disconnection anywhere the printers lose connectivity and do not reconnect to UP. They are connected to the network as I can access the printer configuration web page. We have to power cycle the printers to reconnect them to UP. I easily duplicate this problem by unplugging the ethernet from a printer then plugging it back in. The network connection is ok however, it does not reconnect to UP and they only way to reconnect it is to power cycle the printer. It happens on every printer that we have connected to UP. Is there a way to change this behavior? Read More
Word verschiebt meine Überschriften nach oben
Hey, ich habe das Problem dass meine Überschriften sich ab der zweiten Seite zu nah an die Kopfzeilen versetzen. Wenn ich eine Überschrift auf der ersten Seite mache, springt der Cursor wegen der Textart “Überschrift” immer ein kleines Stück nach unten damit die Überschrift dann nicht direkt an der Kopfzeilen hängt. Dies macht er jedoch nicht mehr ab der zweiten Seite und manuell kann ich da auch keinen Abstand ab der zweiten Seite einstellen.
Hey, ich habe das Problem dass meine Überschriften sich ab der zweiten Seite zu nah an die Kopfzeilen versetzen. Wenn ich eine Überschrift auf der ersten Seite mache, springt der Cursor wegen der Textart “Überschrift” immer ein kleines Stück nach unten damit die Überschrift dann nicht direkt an der Kopfzeilen hängt. Dies macht er jedoch nicht mehr ab der zweiten Seite und manuell kann ich da auch keinen Abstand ab der zweiten Seite einstellen. Read More
Cross sheet functionality and maintenance of the chronological order of a formula
Hi community,
I’m working on a formula that searches a range of cells and outputs it another range of cells where the criteria are based on matches on two dropdown menus which are dependent (Columns A and B)
Summarized the formula does the following:
1. Lookup: Excel searches for a selected item from a corresponding dropdown menu in column B.
2. Retrieving Previous Data: When a match is identified (two identical items), Excel should search the designated columns to retrieve the previously entered data for that item.
3. Order of Retrieval: If there are multiple entries for the same item, Excel will prioritize the nearest entry relative to a reference row (This means below the reference row, it should not search upwards). For example, if the reference row is 11, and there are entries in rows 16 and 21 for the same item, Excel should retrieve the data from row 16. (You can test this by either blanking dropdown cells in columns A and B, and it will switch to the output location)
My problem is that I need this type of functionality across different sub-sheets so that when it starts searching in let’s say week 1 (sheet 1) it will continue its search parameters in week 2 (sheet 2) and maintain the order of retrieval as mentioned in point 3 above. Essentially linking different sub-sheets together through one formula.
I attached a sample with annotations to explain how the formula functions and how I need it to work.
The solutions I can think of are;
1. Simplyfing the formula making it less stress intensive so that it would be possible to merge all sub-sheets into one big sheet
2. Creating a master sheet where one can perform lookups using the INDIRECT and MATCH functions
I’m not sure how to fully flesh out these ideas or of other solutions however.
Hi community,I’m working on a formula that searches a range of cells and outputs it another range of cells where the criteria are based on matches on two dropdown menus which are dependent (Columns A and B)Summarized the formula does the following:1. Lookup: Excel searches for a selected item from a corresponding dropdown menu in column B.2. Retrieving Previous Data: When a match is identified (two identical items), Excel should search the designated columns to retrieve the previously entered data for that item.3. Order of Retrieval: If there are multiple entries for the same item, Excel will prioritize the nearest entry relative to a reference row (This means below the reference row, it should not search upwards). For example, if the reference row is 11, and there are entries in rows 16 and 21 for the same item, Excel should retrieve the data from row 16. (You can test this by either blanking dropdown cells in columns A and B, and it will switch to the output location)=IF(B11=””,””,IFERROR(MAKEARRAY(5,3,LAMBDA(x,y,INDEX($G$1:$I$25,XLOOKUP(A11&B11,$A$5:$A$10&$B$5:$B$10,ROW($B$4:$B$9),,0,-1)+x,y))),””))My problem is that I need this type of functionality across different sub-sheets so that when it starts searching in let’s say week 1 (sheet 1) it will continue its search parameters in week 2 (sheet 2) and maintain the order of retrieval as mentioned in point 3 above. Essentially linking different sub-sheets together through one formula.I attached a sample with annotations to explain how the formula functions and how I need it to work.The solutions I can think of are;1. Simplyfing the formula making it less stress intensive so that it would be possible to merge all sub-sheets into one big sheet2. Creating a master sheet where one can perform lookups using the INDIRECT and MATCH functionsI’m not sure how to fully flesh out these ideas or of other solutions however. Read More
Can’t cancel/Edit My Meetings
I am having an issue with my outlook meetings not allowing me to edit or cancel. If I try to cancel I get Error 3003. If I attempt to edit I get an error saying I am not the host. These are meetings I have created myself and have not given anyone else host rights to. This occurs almost immediately after I create a meeting.
I am having an issue with my outlook meetings not allowing me to edit or cancel. If I try to cancel I get Error 3003. If I attempt to edit I get an error saying I am not the host. These are meetings I have created myself and have not given anyone else host rights to. This occurs almost immediately after I create a meeting. Read More
Using azure Search datasource in Azure AI completion API is creating many prompt tokens
Hi
I have written Azure Open AI implementation integrating with Azure cognitive search, as shown below.
{
“data_sources”: [
{
“type”: “AzureCognitiveSearch”,
“parameters”: {
“endpoint”: “AZURE_SEARCH_END_POINT”,
“key”: “AZURE_SEARCH_KEY”,
“index_name”: “INDEX_NAME”,
“scope”: {
“in_scope”: true,
“top_n_documents”: 1
}
“queryType”:”vectorSimpleHybrid”,
}
}
],
Then I make Azure Open API completion call using this Azure cognitive search service. I use mode GPT 3.5.
Everything is working fine as expected.
The challenge is the number of tokens it is generating is huge. For the simple prompt like “Who is Some XYZ”, it shows ‘4000+’ prompt tokens.
How do I avoid this. I am not adding any context to this. I tested taking out the above code and the prompt token count is around 5.
Can you suggest ways to solve this?
I tested adding filter to point to one chunkId, even then the prompt token count does not come down.
I was told to run a semantic search on to search index and then give the results as input chat completion API. But not sure how to implement this.
Can you suggest or point me the right direction.
REST API call would be preferred but even python code will help.
Thank you
HiI have written Azure Open AI implementation integrating with Azure cognitive search, as shown below. {
“data_sources”: [
{
“type”: “AzureCognitiveSearch”,
“parameters”: {
“endpoint”: “AZURE_SEARCH_END_POINT”,
“key”: “AZURE_SEARCH_KEY”,
“index_name”: “INDEX_NAME”,
“scope”: {
“in_scope”: true,
“top_n_documents”: 1
}
“queryType”:”vectorSimpleHybrid”,
}
}
], Then I make Azure Open API completion call using this Azure cognitive search service. I use mode GPT 3.5.Everything is working fine as expected.The challenge is the number of tokens it is generating is huge. For the simple prompt like “Who is Some XYZ”, it shows ‘4000+’ prompt tokens.How do I avoid this. I am not adding any context to this. I tested taking out the above code and the prompt token count is around 5.Can you suggest ways to solve this? I tested adding filter to point to one chunkId, even then the prompt token count does not come down.I was told to run a semantic search on to search index and then give the results as input chat completion API. But not sure how to implement this.Can you suggest or point me the right direction.REST API call would be preferred but even python code will help. Thank you Read More
How to include additional fields in filter range
In the attached sheet columns D-R have a filter applied.
For some reason applying a filter that includes columns A-C causes the Filter button to be ghosted/greyed.
Anyone know why this is happening?
Thanks
In the attached sheet columns D-R have a filter applied. For some reason applying a filter that includes columns A-C causes the Filter button to be ghosted/greyed. Anyone know why this is happening? Extend_filter_range.xlsx Thanks Read More
Should I install the most recent update?
My dad just warned me of the most recent windows 11 updated and he said not to update to it today as it bricked some laptops. Is this true? What have you heard about it?
My dad just warned me of the most recent windows 11 updated and he said not to update to it today as it bricked some laptops. Is this true? What have you heard about it? Read More
Validate authToken from Teams-js
I’m getting an auth token from the authentication module in the `microsoft/teams-js` library. Since I want to use the `preferred_username` to link users to existing accounts in my app, I need to validate that the auth token is legit. I’d like to validate against a public key that the JWT token has not been tampered with in my server code before I link users. How can I do this? My app is a django app on the backend.
I’m getting an auth token from the authentication module in the `microsoft/teams-js` library. Since I want to use the `preferred_username` to link users to existing accounts in my app, I need to validate that the auth token is legit. I’d like to validate against a public key that the JWT token has not been tampered with in my server code before I link users. How can I do this? My app is a django app on the backend. Read More
Training Release Schedule for Partners
I am new to managing a Microsoft Partner account & was recently asked for the training release schedule. Specifically looking for information around the update to Endpoint Administrator (MD-102) exam course. I was told there used to be a way to get the course release dates but could not find anything on the partner site. If someone could help point me in the right direction, would greatly appreciate it.
I am new to managing a Microsoft Partner account & was recently asked for the training release schedule. Specifically looking for information around the update to Endpoint Administrator (MD-102) exam course. I was told there used to be a way to get the course release dates but could not find anything on the partner site. If someone could help point me in the right direction, would greatly appreciate it. Read More
Copying one Column Meta data to other column in same SharePoint library
Hello, I need help building Power to automate WF.
Copy of one Column Metadata to another column in the same SharePoint library. attached is an image for the column.
_PID metadata I need in the PID column.
Hello, I need help building Power to automate WF.Copy of one Column Metadata to another column in the same SharePoint library. attached is an image for the column._PID metadata I need in the PID column. Read More
The Brazilian ETF DIVD11 is not working at Stocks
Dear Friends,
The DIVD11 ETF, available on the Brazilian stock exchange (BOVESPA), doesn’t appear in the “STOCKS” supplement of Excel. It seems that the asset needs to be updated. How to fix this?
Dear Friends,The DIVD11 ETF, available on the Brazilian stock exchange (BOVESPA), doesn’t appear in the “STOCKS” supplement of Excel. It seems that the asset needs to be updated. How to fix this? Read More