User Profile
annetoal
Brass Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Work mode and Commercial Data Protection
A new Work/Web slider control has appeared at the top of the copilot.microsoft.com for users who have Copilot for M365. When Work mode is selected, the absence of the green "Protected" shield in the upper-right corner of the page raises concerns about the activation of Commercial Data Protection. This observation extends to the Copilot sidebar as well. It prompts the question: Is Commercial Data Protection still enforced while in Work mode? Thanks, AnneSolved1.3KViews0likes1CommentWhite text in Dark Mode
When text in HTML appears black in email, the same HTML produces white text in Teams, if the user has set Dark Mode. If not in dark mode, the text displays correctly. What is the best way to make the text display the same in light and dark mode? Thanks, Anne1.3KViews0likes0CommentsImages displaying in Outlook
Microsoft 365 user. 1. When email arrives containing images, Outlook Desktop shows a message that the image can't be displayed. But when the email is forwarded to another user, the display changes so that the image is displayed in the mail. How can this be fixed? 2. Emails with HTML links are clickable in Outlook Desktop but not in Outlook Web App. Why? Thank you, AnneSolved1.2KViews0likes2CommentsJSON formatting of SharePoint list
I am using some JSON code from Reza Dorrani's GitHub to make an approval timeline in a SharePoint list. The code allows you to have 4 different statuses: Status Color Position New Blue Left Pending Yellow Center Approved Green Right Rejected Red Right I would like to add a fifth status: Deleted with a Black pointer in the Right position. Would someone please look at the JSON code and tell me what needs to be done? { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "style": { "position": "relative", "width": "100%", "height": "70px" }, "children": [ { "elmType": "div", "style": { "position": "absolute", "display": "flex", "align-items": "center", "justify-content": "center", "width": "100%", "height": "100%" }, "children": [ { "elmType": "div", "style": { "width": "100%", "height": "5px" }, "attributes": { "class": "ms-bgColor-neutralSecondaryAlt" } } ] }, { "elmType": "div", "style": { "position": "absolute", "display": "flex", "align-items": "center", "justify-content": "=if([$Status]=='Pending','center',if([$Status]=='New','left','flex-end'))", "width": "100%", "height": "100%" }, "children": [ { "elmType": "div", "style": { "width": "25px", "height": "25px", "border-radius": "50%", "cursor": "pointer" }, "attributes": { "class": "=if([$Status]=='Rejected','ms-bgColor-red',if([$Status]=='Pending','ms-bgColor-yellow',if([$Status]=='Approved','ms-bgColor-green','ms-bgColor-blue')))" }, "customCardProps": { "directionalHint": "rightCenter", "openOnEvent": "click", "isBeakVisible": true, "formatter": { "elmType": "div", "style": { "width": "300px", "height": "300px", "padding": "10px 20px 10px 20px", "background-color": "#E6E6E3" }, "children": [ { "elmType": "div", "txtContent": "=if([$Status]!='New',[$ApprovalComments],'No History Available'", "style": { "width": "100%", "height": "100%" } } ] } } } ] } ] } Thanks in advance, AnneSolved3.2KViews0likes2CommentsWhen is a locked file not locked?
Power Automate errors out when it tries to update SharePoint properties on a file that is locked for editing. If you clicked a link to a SharePoint file and you weren't completely logged in to Office365, would SharePoint still see the file as "locked for editing?" I am thinking about situations where you might still have an old browser window open to O365 but your login session had timed out. Thank you, AnneContents of a "required info" cell
In a SharePoint library where the "required" flag is set, it displays a "Required info" message and turns yellow. What are the internal contents of that cell? I'm trying to do an ODATA filter query in Power Automate and finding that reviewDue eq null no longer works. Thanks, AnneSolvedInconsistent "document locked" times
I'm working on a Flow that uses a Do until loop to keep trying to update SharePoint properties, if it finds the file is locked. The Do until loop is set to run for 1 day with 290 tries. When the file is closed, the Flow updates properties and completes the run. Testing has been showing inconsistent run times before the Flow completes. My latest test ran for 6 hours 12 minutes. The file in question was open in another tab on my computer. At 6:12, Flow determined the file was closed, updated the properties, and completed the run. I did not close the file. Does Office 365 close files that have been open but inactive a long time? I am using Edge browser which "sleeps" an inactive tab. Would this sleep condition make Office 365/SharePoint think that the file had been closed? Thank you, Anne665Views0likes0CommentsColumn validation on email address
I have a column that contains email addresses. I would like SharePoint to check the email address when it is entered to make sure the emails are being entered properly. the address must have a@followed by school.edu the address left of the@ must be formedfirst.last I've tried inputting some code I found on the net but so far I've found that every address is rejected. Using SharePoint Online in Office 365. I read a comment from a user that this doesn't work in SharePoint Online. Does anyone have any information? Details: SharePoint Library, column is namedapproverEmail. Code I've been trying to work with follows: =AND(ISERROR(FIND(" ", [approverEmail],1)),IF(ISERROR(FIND("@", [approverEmail],2)),FALSE,AND(ISERROR(FIND("@",[approverEmail], FIND("@", [approverEmail],2)+1)),IF(ISERROR(FIND(".", [approverEmail], FIND("@", [approverEmail],2)+2)),FALSE,FIND(".", [approverEmail], FIND("@", [approverEmail],2)+2) < LEN([approverEmail]))))) Thanks, Anne1.4KViews0likes0Comments
Groups
Recent Blog Articles
No content to show