Category: Microsoft
Category Archives: Microsoft
Outlook hacked
Hi, my Outlook was hacked and received blackmail emails demanding bitcoin.
I changed my password, enabled 2FA and use MS Authenticator app. Also did a factory reset.
How can I protect myself, as my activity shows hundreds of unsuccessful sign ins daily, as the hacker is trying to breach my password again. Don’t receive any alerts warning me though.
Hacker claims a trojan virus is on my phone which is invisible to antivirus software. No idea whether this is complete nonsense. Need some advice and guidance. I went to the Police but they were not bothered saying they get dozens of incidents daily.
Hi, my Outlook was hacked and received blackmail emails demanding bitcoin. I changed my password, enabled 2FA and use MS Authenticator app. Also did a factory reset. How can I protect myself, as my activity shows hundreds of unsuccessful sign ins daily, as the hacker is trying to breach my password again. Don’t receive any alerts warning me though. Hacker claims a trojan virus is on my phone which is invisible to antivirus software. No idea whether this is complete nonsense. Need some advice and guidance. I went to the Police but they were not bothered saying they get dozens of incidents daily. Read More
Network assessment
hi folks,
for a customer we have to made a “Network assessment” within his current azure environment. Task we plan to use is for a 1st step to use the Network from Insights to see the health, connectivity and traffic information. Next where we want to look is under Network – monitoring-Diagram.
Do you have further services, solutions to look or add to make a assessment of the customer network?
Thanks for your replies
hi folks, for a customer we have to made a “Network assessment” within his current azure environment. Task we plan to use is for a 1st step to use the Network from Insights to see the health, connectivity and traffic information. Next where we want to look is under Network – monitoring-Diagram.Do you have further services, solutions to look or add to make a assessment of the customer network? Thanks for your replies Read More
Open OST File in Outlook 2019 With All Items
Take the help from Advik OST to PST Converter tool. This application will convert OST to PST format. Because MS Outlook import data in PST file format only. With this software you can export all data from OST file into PST file type. The conversion will be 100% accuracy.
Steps to Open OST file in Outlook 2019
Run Advik OST to PST Converter in your PC.Click Select Files to add OST file in application.Choose mailbox folders to export.Select Output file as PST format.Click Convert button.
After converting OST file into PST, open MS Outlook in your PC. Navigate to File > Import/Export> Import Outlook Data File. Now import PST file from this menu.
Above method is workable with MS Outlook 2013, 2016, 2019, and other editions.
Take the help from Advik OST to PST Converter tool. This application will convert OST to PST format. Because MS Outlook import data in PST file format only. With this software you can export all data from OST file into PST file type. The conversion will be 100% accuracy. Steps to Open OST file in Outlook 2019Run Advik OST to PST Converter in your PC.Click Select Files to add OST file in application.Choose mailbox folders to export.Select Output file as PST format.Click Convert button.After converting OST file into PST, open MS Outlook in your PC. Navigate to File > Import/Export> Import Outlook Data File. Now import PST file from this menu. Above method is workable with MS Outlook 2013, 2016, 2019, and other editions. Read More
How to Import PST to Office 365 Mailbox?
This is very simple with Advik PST File Converter. This utility is specially designed for people who wants to import PST to Office 365 Mailbox. The program basically export emails, contacts, calendar and other data from PST to Office 365 Webmail. You can import multiple PST files to Outlook 365 in bulk as well. It will preserve email attributes and folder heirarchy too.
Steps to Import PST to Office 365 Mailbox
Launch Advik PST File Converter in your PC.Click Select Files and add Outlook.pst file.Select mailbox folders and items from PST file.Select Office 365 as export option.Enter Office 365 login credentials.Click Convert button.
Finished! This is how you can import PST to Office 365 Webmail Mailbox without Outlook.
This is very simple with Advik PST File Converter. This utility is specially designed for people who wants to import PST to Office 365 Mailbox. The program basically export emails, contacts, calendar and other data from PST to Office 365 Webmail. You can import multiple PST files to Outlook 365 in bulk as well. It will preserve email attributes and folder heirarchy too. Steps to Import PST to Office 365 MailboxLaunch Advik PST File Converter in your PC.Click Select Files and add Outlook.pst file.Select mailbox folders and items from PST file.Select Office 365 as export option.Enter Office 365 login credentials.Click Convert button.Finished! This is how you can import PST to Office 365 Webmail Mailbox without Outlook. Read More
Dynamically populate summary sheet via hyperlink to data in another sheet
Hi everyone, new to the community, I’d be v. grateful for any advice on this head-scratcher. Not sure if I’m asking the question in the right way so please ask if anything unclear.
I’m on a Mac using Office 365. I have a multi-tabbed workbook that is used to record print specifications for different pieces of corporate collateral.
The first sheet is a summary/aggregator of information from all other sheets to enable easy cross-checking and comparison. Reference images and numerical/text data relating to each item are entered to individual sheets (with tab name as the item name) and I’d like to find a way to dynamically pull into the summary sheet key images and data from individual sheets with the ability to add or remove sheets in future and have the summary sheet update automatically.
I know how to add manual links to the data sets, but if a sheet is added, I have to go back to the summary and add more manual links for the corresponding row to be updated. I’d like to find a way for this to happen automatically.
SUMMARY SHEET SET-UP
Tab name = AA_SUMMARY with the Name Box entry as ‘INDEX’Column A = numbers 1-100 on individual rows, starting row 5 (to allow for sheet title etc in rows 1-4)Column B = empty (aesthetic spacer)Column C = contains a list of all the tab/sheet names, pulled in via =INDEX(SheetNames,A5) type formula. This relies on having the numbers in column A to work, I believe, as without the numbers, the index runs along the row, and I want it to run down the column.Column D = hyperlink to the individual sheet named in C via =HYPERLINK(“#'”&B2&”‘!A1″,”Go To Sheet”). Does double duty as navigation and also is what I’ve been using to direct formula to relevant sheet (see lower down). Columns E+ = these are the cells I want to populate with data from the other worksheets. All columns have a header which corresponds to a category of information present in the other worksheets. The idea being that if you look along a row, you get all the key information for that sheet – like this this, where the text in red italics automatically pulls in – regardless of whether you add sheets or remove sheets.
Ref imagecategory 1category 2category 31 NAME OF WORKSHEET 1Go to sheet[image]data 1data 2data 3 2 NAME OF WORKSHEET 2Go to sheet[image]data 1data 2data 3
This set-up enables sheet names to be added or removed dynamically if new ones are added to the work book, or old ones deleted.
DATA-ENTRY SHEET SET-UP
Tab name = individual name relevant to the item, I’ve not added a named range via Name BoxRows 1-3 = sheet headings Row 5, across columns A-H = reference image inserted in-cellRow 6 = blank (aesthetic spacer)Row 7, columns A-H = merged containing the item name which is pulled in from the tab name via =TEXTAFTER(CELL(“filename”,A1),”]”)Row 8, columns A-H = individual category headers which match the category 1 / category 2 (etc) headers on the summary sheetRow 9, columns A-H = empty cells where relevant data is entered
Image pulled in here via ‘insert image in-cell)
Item:Name of item pulled in here via =TEXTAFTER(CELL(“filename”,A1),”]”)Category 1Category 2Category 3Category 4Category 5Category 6Category 7Category 8enter data 1enter data 2enter data 3enter data 4enter data 5enter data 6enter data 7enter data 8
(sorry for odd looking table – the editor won’t allow me to merge the image, spacer and item cells at full width across the lower columns.)
THE PROBLEM
I’m hitting a wall trying to find a formula which knows to look at the hyperlink sheet destination, go to that sheet and pull in info from cells 9A > 9H.
If I manually add: = and click the hyperlink cell to pull in the sheet name, then navigate to that sheet and click the relevant cell in that sheet, (eg: formula looks like: =LETTERHEAD!A9 ) it does return the correct data to that cell in the summary. But if then copy that formula to the following rows, it just pulls in the original sheet name, rather than the one relevant to that row and won’t dynamically update itself.
So the issue seems to be finding a formula that instructs to look left to the hyperlink for each row automatically, then reference the relevant cell in the destination sheet.
I hope that makes sense, and any advice v. gratefully received.
Thanks in advance!
Soph.
Hi everyone, new to the community, I’d be v. grateful for any advice on this head-scratcher. Not sure if I’m asking the question in the right way so please ask if anything unclear.I’m on a Mac using Office 365. I have a multi-tabbed workbook that is used to record print specifications for different pieces of corporate collateral. The first sheet is a summary/aggregator of information from all other sheets to enable easy cross-checking and comparison. Reference images and numerical/text data relating to each item are entered to individual sheets (with tab name as the item name) and I’d like to find a way to dynamically pull into the summary sheet key images and data from individual sheets with the ability to add or remove sheets in future and have the summary sheet update automatically. I know how to add manual links to the data sets, but if a sheet is added, I have to go back to the summary and add more manual links for the corresponding row to be updated. I’d like to find a way for this to happen automatically.SUMMARY SHEET SET-UPTab name = AA_SUMMARY with the Name Box entry as ‘INDEX’Column A = numbers 1-100 on individual rows, starting row 5 (to allow for sheet title etc in rows 1-4)Column B = empty (aesthetic spacer)Column C = contains a list of all the tab/sheet names, pulled in via =INDEX(SheetNames,A5) type formula. This relies on having the numbers in column A to work, I believe, as without the numbers, the index runs along the row, and I want it to run down the column.Column D = hyperlink to the individual sheet named in C via =HYPERLINK(“#'”&B2&”‘!A1″,”Go To Sheet”). Does double duty as navigation and also is what I’ve been using to direct formula to relevant sheet (see lower down). Columns E+ = these are the cells I want to populate with data from the other worksheets. All columns have a header which corresponds to a category of information present in the other worksheets. The idea being that if you look along a row, you get all the key information for that sheet – like this this, where the text in red italics automatically pulls in – regardless of whether you add sheets or remove sheets. Ref imagecategory 1category 2category 31 NAME OF WORKSHEET 1Go to sheet[image]data 1data 2data 3 2 NAME OF WORKSHEET 2Go to sheet[image]data 1data 2data 3 This set-up enables sheet names to be added or removed dynamically if new ones are added to the work book, or old ones deleted. DATA-ENTRY SHEET SET-UPTab name = individual name relevant to the item, I’ve not added a named range via Name BoxRows 1-3 = sheet headings Row 5, across columns A-H = reference image inserted in-cellRow 6 = blank (aesthetic spacer)Row 7, columns A-H = merged containing the item name which is pulled in from the tab name via =TEXTAFTER(CELL(“filename”,A1),”]”)Row 8, columns A-H = individual category headers which match the category 1 / category 2 (etc) headers on the summary sheetRow 9, columns A-H = empty cells where relevant data is entered Image pulled in here via ‘insert image in-cell) Item:Name of item pulled in here via =TEXTAFTER(CELL(“filename”,A1),”]”)Category 1Category 2Category 3Category 4Category 5Category 6Category 7Category 8enter data 1enter data 2enter data 3enter data 4enter data 5enter data 6enter data 7enter data 8 (sorry for odd looking table – the editor won’t allow me to merge the image, spacer and item cells at full width across the lower columns.) THE PROBLEMI’m hitting a wall trying to find a formula which knows to look at the hyperlink sheet destination, go to that sheet and pull in info from cells 9A > 9H. If I manually add: = and click the hyperlink cell to pull in the sheet name, then navigate to that sheet and click the relevant cell in that sheet, (eg: formula looks like: =LETTERHEAD!A9 ) it does return the correct data to that cell in the summary. But if then copy that formula to the following rows, it just pulls in the original sheet name, rather than the one relevant to that row and won’t dynamically update itself. So the issue seems to be finding a formula that instructs to look left to the hyperlink for each row automatically, then reference the relevant cell in the destination sheet. I hope that makes sense, and any advice v. gratefully received. Thanks in advance!Soph. Read More
FileHandler in the OneDrive context menu in “My Files” not showing the displayName (submenu missing)
When using a Microsoft 365 file handler add-in (OneDrive File Handlers 2.0) with two custom actions. The following inconsistency appears for the context menu in the document library “My Files”. Usually, with two custom actions there should be an expandable submenu. But this is missing only for some users and not for others, as I’ve checked the behavior with two different users.
See the “addIns” definition of the application manifest below.
Observed behavior:
Only in “My Files” in OneDrive, the context menu shows the custom actions differently than in the other document libraries. The “displayNames” are not shown at all, as the sub menu is missing. Rather only the “actionMenuDisplayName” is shown for each custom action which does not seem intended.
Context menu:
OpenPreview…actionMenuDisplayNameactionMenuDisplayName
Expected behavior:
The expected behavior if there is only one file-handler add-in installed would be the following for the context menu, to have a sub-menu that expands and that shows the displayNames of the custom actions:
Context menu:
OpenPreview…actionMenuDisplayName > Submenu containing “displayName” of action 1 and “displayName” of action 2
The default behavior is as expected for the document libraries in SharePoint and Teams (files) even when accessing sharepoint sites in OneDrive via quick access the behaviour is as expected.
Application manifest:
“addIns”: [
{
“id”: “some-id”,
“type”: “FileHandler”,
“properties”: [
{
“key”: “actions”,
“value”: “[{“type”:”custom”,”displayName”:”Action 1″,”shortDisplayName”:”Act 1″,”icon”:{“png1x”:”…email address removed for privacy reasons”},”url”:”someEndpoint”,”availableOn”:{“file”:{“extensions”:[“listOfFiletypes”]},”allowMultiSelect”:false}}, {“type”:”custom”,”displayName”:”Action2″,”shortDisplayName”:”Act2″,”icon”:{“png1x”:”…/email address removed for privacy reasons”},”url”:”someEndpoint”,”availableOn”:{“file”:{“extensions”:[“listOfFiletypes”]},”allowMultiSelect”:false}}]”
},
{
“key”: “appIcon”,
“value”: “{“svg”:”…icon.svg”,”png1x”:”…email address removed for privacy reasons”,”png1.5x”:”…email address removed for privacy reasons”,”png2x”:”…email address removed for privacy reasons”}”
},
{
“key”: “actionMenuDisplayName”,
“value”: “Application”
},
{
“key”: “version”,
“value”: “2”
}
]
}
],
When using a Microsoft 365 file handler add-in (OneDrive File Handlers 2.0) with two custom actions. The following inconsistency appears for the context menu in the document library “My Files”. Usually, with two custom actions there should be an expandable submenu. But this is missing only for some users and not for others, as I’ve checked the behavior with two different users.See the “addIns” definition of the application manifest below. Observed behavior:Only in “My Files” in OneDrive, the context menu shows the custom actions differently than in the other document libraries. The “displayNames” are not shown at all, as the sub menu is missing. Rather only the “actionMenuDisplayName” is shown for each custom action which does not seem intended.Context menu:OpenPreview…actionMenuDisplayNameactionMenuDisplayName Expected behavior:The expected behavior if there is only one file-handler add-in installed would be the following for the context menu, to have a sub-menu that expands and that shows the displayNames of the custom actions:Context menu:OpenPreview…actionMenuDisplayName > Submenu containing “displayName” of action 1 and “displayName” of action 2The default behavior is as expected for the document libraries in SharePoint and Teams (files) even when accessing sharepoint sites in OneDrive via quick access the behaviour is as expected. Application manifest: “addIns”: [
{
“id”: “some-id”,
“type”: “FileHandler”,
“properties”: [
{
“key”: “actions”,
“value”: “[{“type”:”custom”,”displayName”:”Action 1″,”shortDisplayName”:”Act 1″,”icon”:{“png1x”:”…email address removed for privacy reasons”},”url”:”someEndpoint”,”availableOn”:{“file”:{“extensions”:[“listOfFiletypes”]},”allowMultiSelect”:false}}, {“type”:”custom”,”displayName”:”Action2″,”shortDisplayName”:”Act2″,”icon”:{“png1x”:”…/email address removed for privacy reasons”},”url”:”someEndpoint”,”availableOn”:{“file”:{“extensions”:[“listOfFiletypes”]},”allowMultiSelect”:false}}]”
},
{
“key”: “appIcon”,
“value”: “{“svg”:”…icon.svg”,”png1x”:”…email address removed for privacy reasons”,”png1.5x”:”…email address removed for privacy reasons”,”png2x”:”…email address removed for privacy reasons”}”
},
{
“key”: “actionMenuDisplayName”,
“value”: “Application”
},
{
“key”: “version”,
“value”: “2”
}
]
}
], Read More
Flagged emails don’t show up in To Do
My flagged emails no longer show up in To Do. I’ve tried flagging emails on Windows, iPhone, iPad and the web and none of them send the message to To Do. MS To Do shows the flagged email list and tells me that “Messages you flag will show up as tasks here” but this isn’t true.
I tried turning flagged emails off in the To Do settings, then back on. I tried restarting the machine. Problem persists.
My company moved to Office 365 about the same time that New Outlook came out, I suspect one of these things broke my ability to flag an email in outlook and have it show up in MS To Do. I liked this functionality as I could process emails by flagging them and then archiving them on my iPhone or iPad or wherever and they would reliably show up on my To Do list.
Anyone have any ideas what may have broken this functionality?
Thanks,
Michael
My flagged emails no longer show up in To Do. I’ve tried flagging emails on Windows, iPhone, iPad and the web and none of them send the message to To Do. MS To Do shows the flagged email list and tells me that “Messages you flag will show up as tasks here” but this isn’t true. I tried turning flagged emails off in the To Do settings, then back on. I tried restarting the machine. Problem persists. My company moved to Office 365 about the same time that New Outlook came out, I suspect one of these things broke my ability to flag an email in outlook and have it show up in MS To Do. I liked this functionality as I could process emails by flagging them and then archiving them on my iPhone or iPad or wherever and they would reliably show up on my To Do list. Anyone have any ideas what may have broken this functionality? Thanks,Michael Read More
What To Do When Getting Quick-Books Error 1327 after update?
I keep getting Quick-Books Error 1327 while trying to install or update Quick-Books. What does this error mean, and how can I fix it?
I keep getting Quick-Books Error 1327 while trying to install or update Quick-Books. What does this error mean, and how can I fix it? Read More
regexextract function not installed
I just downloaded the latest 365 updates, but the new regexextract function is not working. I just get #NAME? Excel version 2406, build 17726.20078. June 17, 2024. I am on a Windows 10 machine, but I don’t believe that should matter.
I just downloaded the latest 365 updates, but the new regexextract function is not working. I just get #NAME? Excel version 2406, build 17726.20078. June 17, 2024. I am on a Windows 10 machine, but I don’t believe that should matter. Read More
How to Resolve Quick-Books Error 6010 100 after new update?
I’m experiencing “Quick-Books Error 6010 100” while trying to open my company file. How can I resolve this issue?
I’m experiencing “Quick-Books Error 6010 100” while trying to open my company file. How can I resolve this issue? Read More
Why is My Quick-Books sync manager not working after recent update?
Quick-Books Sync Manager not working – keeps freezing and failing to sync my data. How can I fix this issue?
Quick-Books Sync Manager not working – keeps freezing and failing to sync my data. How can I fix this issue? Read More
FIDO2 Key Audit Logs
Hi,
Does anyone have any KQL Queries that will give me a list of users that have used FIDO2 Keys as their method of authentication, or any audit logs that I can look up for all users to validate that these keys are being used as opposed to being available to be used.
We have FIDO2 Keys set as available to users in the estate and I know that they are being used where required, but in the users Sign-in logs, it isn’t very clear as to where it proves that the user used FIDO2 as the authentication method.
When looking at a user that is using FIDO2 Key for their authentication, it doesn’t show in the Basic Info tab in Entra Sign-in logs that FIDO Key use was used specifically?
I have a Conditional Access Policy set as Report Only to also help test this which enforces Authentication Strength for Phishing Resistant MFA, and the users I am looking at that I know use FIDO2 for authentication, would have successfully passed that CAP should it be enabled; so I know that it’s working fine. I just need to be able to prove this in the audit logs for multiple users.
Hi, Does anyone have any KQL Queries that will give me a list of users that have used FIDO2 Keys as their method of authentication, or any audit logs that I can look up for all users to validate that these keys are being used as opposed to being available to be used. We have FIDO2 Keys set as available to users in the estate and I know that they are being used where required, but in the users Sign-in logs, it isn’t very clear as to where it proves that the user used FIDO2 as the authentication method. When looking at a user that is using FIDO2 Key for their authentication, it doesn’t show in the Basic Info tab in Entra Sign-in logs that FIDO Key use was used specifically? I have a Conditional Access Policy set as Report Only to also help test this which enforces Authentication Strength for Phishing Resistant MFA, and the users I am looking at that I know use FIDO2 for authentication, would have successfully passed that CAP should it be enabled; so I know that it’s working fine. I just need to be able to prove this in the audit logs for multiple users. Read More
What To Do When Getting Quick-Books Error 193 after latest update?
I’m experiencing Quick-Books Error 193 when trying to access my company file. How can I resolve this issue and prevent it from happening again?
I’m experiencing Quick-Books Error 193 when trying to access my company file. How can I resolve this issue and prevent it from happening again? Read More
Troubleshooting and Resolving Sync Manager Not Working Issues in Quick-Books
I’m having trouble with the Sync Manager in Quick-Books; it’s not working properly. Every time I try to sync my data, it fails or gets stuck. I’ve tried restarting Q.B and my computer, but the issue persists. What steps can I take to resolve this problem? Are there any specific settings or troubleshooting methods that I should check?
I’m having trouble with the Sync Manager in Quick-Books; it’s not working properly. Every time I try to sync my data, it fails or gets stuck. I’ve tried restarting Q.B and my computer, but the issue persists. What steps can I take to resolve this problem? Are there any specific settings or troubleshooting methods that I should check? Read More
Locked out of work account
Hi folks,
I setup Microsoft Authenticator as the 2FA on my work account on a phone which was destroyed. I’m trying to setup the authenticator on my new phone, but whenever I try to sign into the account, the only MFA option I’m given is to verify using the authenticator which is no longer accessible (I’m the only user on the account as well).
I’ve tried resetting the password, sending email to my alternate email address, getting microsoft to call my office number, and just keep ending up at the same spot. Is there an option I’ve missed which says “I no longer have access to the authenticator app”? Is there ANY other way I can verify my identity and regain access to the account?
Thanks
Hi folks, I setup Microsoft Authenticator as the 2FA on my work account on a phone which was destroyed. I’m trying to setup the authenticator on my new phone, but whenever I try to sign into the account, the only MFA option I’m given is to verify using the authenticator which is no longer accessible (I’m the only user on the account as well). I’ve tried resetting the password, sending email to my alternate email address, getting microsoft to call my office number, and just keep ending up at the same spot. Is there an option I’ve missed which says “I no longer have access to the authenticator app”? Is there ANY other way I can verify my identity and regain access to the account? Thanks Read More
Purview eDiscovery: Exported email shown as forwarded – when no other evidence of being forwarded.
eDiscovery results include an email shown as forwarded (both a blue arrow in the message list against the email, and in the copy of the email “i You forwarded this message on 04/06/2024 18.36”) for which there is no other evidence of the message being forwarded.
eDiscovery searches have identified no email sent from the account at or around the reported time (18.36) of the reportedly forwarded email. A Purview Audit search of the user’s activity shows no matching activity around that time.
Why would the message be shown as forwarded when it apparently has not been?
eDiscovery results include an email shown as forwarded (both a blue arrow in the message list against the email, and in the copy of the email “i You forwarded this message on 04/06/2024 18.36”) for which there is no other evidence of the message being forwarded. eDiscovery searches have identified no email sent from the account at or around the reported time (18.36) of the reportedly forwarded email. A Purview Audit search of the user’s activity shows no matching activity around that time. Why would the message be shown as forwarded when it apparently has not been? Read More
How to become solution partner ?
Hi,
We are an IT software development firm seeking to become a Microsoft Solution Partner. We are looking for guidance on the requirements and the necessary steps to start this process. Any assistance from experienced professionals in this area would be greatly appreciated.
Hi,We are an IT software development firm seeking to become a Microsoft Solution Partner. We are looking for guidance on the requirements and the necessary steps to start this process. Any assistance from experienced professionals in this area would be greatly appreciated. Read More
Sharepoint combined with Dynamics 365 – Throttling issues
Hi everyone,
I’m reaching out to get some insights on how others have tackled a challenge we’re facing:
Throttling-limit issues in SharePoint when accessed from Dynamics 365: How have you managed these problems? Are you using multiple default libraries and site libraries that can be selected from CRM, or is there another best practice you recommend?
Thanks in advance for your help!
Hi everyone,I’m reaching out to get some insights on how others have tackled a challenge we’re facing:Throttling-limit issues in SharePoint when accessed from Dynamics 365: How have you managed these problems? Are you using multiple default libraries and site libraries that can be selected from CRM, or is there another best practice you recommend?Thanks in advance for your help! Read More
How we can create a link to the Planner Task inside power apps
I have a canvas power apps application which show a list of planner tasks, as follow;-
Set(varInProgress,true);
ClearCollect(finalResult,{PlanTitle:””,TaskTitle:””,Status:””,AssignedToUserId:””,DueDate:””});
Clear(colRelatedGroupsIds);
Clear(colRelatedPlanners);
Clear(colRelatedPlannerTasks);
ClearCollect(colTeamSitesItem,Filter(‘Team Sites’,1=1));
ClearCollect(colAllGroups,Office365Groups.ListGroups().value);
ForAll(colAllGroups As group,
ForAll(colTeamSitesItem As i2,
If(Lower(group.displayName)=Lower(i2.’Team Site Name’),
Collect(colRelatedGroupsIds,group.id))));
ForAll(colRelatedGroupsIds As group,
Collect(colRelatedPlanners,
Planner.ListGroupPlans(group.Value).value);
ForAll(colRelatedPlanners As planner,
Collect(colRelatedPlannerTasks,
Planner.ListTasksV3(planner.id,group.Value).value);
ForAll(colRelatedPlannerTasks As task,
ForAll(task._assignments As taskAssignment,
Patch(finalResult,Defaults(finalResult),
{
PlanTitle:planner.title,
AssignedToUserId:taskAssignment.userId,
Status:task.percentComplete,
TaskTitle:task.title,
DueDate:task.dueDateTime
})
));RemoveIf(colRelatedPlannerTasks,true));RemoveIf(colRelatedPlanners,true));
Set(varInProgress,false);
then i am populating the finalResult collection inside gallery. my question is how i can build a url/link for the planner task? so when the user click on the link it will redirect the user to the Planner Task, seems all the available methods’ properties do not provide the task url:-
so can we get this or build it manually? any advice?
I have a canvas power apps application which show a list of planner tasks, as follow;- Set(varInProgress,true);
ClearCollect(finalResult,{PlanTitle:””,TaskTitle:””,Status:””,AssignedToUserId:””,DueDate:””});
Clear(colRelatedGroupsIds);
Clear(colRelatedPlanners);
Clear(colRelatedPlannerTasks);
ClearCollect(colTeamSitesItem,Filter(‘Team Sites’,1=1));
ClearCollect(colAllGroups,Office365Groups.ListGroups().value);
ForAll(colAllGroups As group,
ForAll(colTeamSitesItem As i2,
If(Lower(group.displayName)=Lower(i2.’Team Site Name’),
Collect(colRelatedGroupsIds,group.id))));
ForAll(colRelatedGroupsIds As group,
Collect(colRelatedPlanners,
Planner.ListGroupPlans(group.Value).value);
ForAll(colRelatedPlanners As planner,
Collect(colRelatedPlannerTasks,
Planner.ListTasksV3(planner.id,group.Value).value);
ForAll(colRelatedPlannerTasks As task,
ForAll(task._assignments As taskAssignment,
Patch(finalResult,Defaults(finalResult),
{
PlanTitle:planner.title,
AssignedToUserId:taskAssignment.userId,
Status:task.percentComplete,
TaskTitle:task.title,
DueDate:task.dueDateTime
})
));RemoveIf(colRelatedPlannerTasks,true));RemoveIf(colRelatedPlanners,true));
Set(varInProgress,false); then i am populating the finalResult collection inside gallery. my question is how i can build a url/link for the planner task? so when the user click on the link it will redirect the user to the Planner Task, seems all the available methods’ properties do not provide the task url:- so can we get this or build it manually? any advice? Read More
Need help with developer account registration form
Hello, everyone!
I want to publish my extension on Microsoft Edge Add-ons. I was following the guide Publish a Microsoft Edge extension and it linked me to this page to register as a developer.
I then filled the form, with all required fields filled out, and clicked submit. But it then tell me to “choose a state or province” under the “State/Province” input box, even though I’ve filled it out!
After playing with the form for a while, I discover that if I select “United States” or “Canada”, the “State/Province” input box turns into a drop-down list, and I can select one from the list. I haven’t tried submitting the form though, as that would set the country for my account to the US and it’s not possible to change it later.
I suspect this is a bug on Microsoft’s server. But in any case, I would greatly appreciate your help to get me through this registration form.
Hello, everyone! I want to publish my extension on Microsoft Edge Add-ons. I was following the guide Publish a Microsoft Edge extension and it linked me to this page to register as a developer. I then filled the form, with all required fields filled out, and clicked submit. But it then tell me to “choose a state or province” under the “State/Province” input box, even though I’ve filled it out! After playing with the form for a while, I discover that if I select “United States” or “Canada”, the “State/Province” input box turns into a drop-down list, and I can select one from the list. I haven’t tried submitting the form though, as that would set the country for my account to the US and it’s not possible to change it later. I suspect this is a bug on Microsoft’s server. But in any case, I would greatly appreciate your help to get me through this registration form. Read More