Microsoft 365 and Office

Creating Multiple Folders in SPO Library using key column as folder name and update the Folder Metadata Columns from Excel File.I created the Power Automate flow as: Trigger: When a file is created or modified (properties only)Action: Get file content (SharePoint)List rows present in a table (Excel Online (Business)Apply to each(Inside "Apply to each"): Created new folder(Inside "Apply to each"): Update file propertiesRefer to TWO Pics, Folders were created as per Excel and folder names were also added as per Key Column. But SPO Folder's Metadata columns are not updated from Excel.Could anyone

I have a number of folders shared with me by other OneDrive users. I've added these to My Files to appear alongside the folders on my OneDrive account. Up until yesterday, they appeared as folders on my PC, alongside the other folders which belong to my OneDrive account. Now these folders that are shared with me are appearing as shortcut links instead of folders on my PC. This has happened to 3 different PCs which are all connected to the same OneDrive account. I have uninstalled OneDrive, cleared the cache, etc. and reinstalled on one PC, but the problem remains. I've removed shared folders,

Is it possible to have the 365 Personal product with HIPAA compliance and encrypted email?

I'm trying to link a table in two workbooks. I created the table and went to the second workbook and entered = then selected the whole table in the first workbook then press enter. Only the first cell (A1) shows up. I have to select A1 and drag down to show all the rows then drag all the rows over to show all the columns. When I watch videos of linking tables the table will autofill when you enter the formula. I can't get it to work. It also won't create new rows on the linked table automatically, I have to go in and drag the last row for it to show.

On the Microsoft Defender Weakness page, I see a filter named "Exposed Device." Under this filter, there are three options: "Affects my organization," "Does not affect my organization," and "Not available." I need to understand what this filter represents and its use case.

I am trying to create a power automate scheduled flow but I have this error "You do not have permissions to open this file in the browser".The step is "Add a row into a table" from Excel Online (OneDrive). I can select the file, but I cannot select a Table.Could not retrieve values. The dynamic invocation request failed with error: { "status": 401, "message": "You do not have permissions to open this file in the browser.

Normally when I type a =CUBEVALUE or =CUBEMEMBER formula excel helps you out by showing either the available connections or the members of each dimension in the formula after typing the quotation mark for both external and internal connections. Recently, something happened to my excel that even for the simplest data model with a single small table after I upload the table to the power pivot and I type =CUBEMEMBER(" there is no suggestion after the quotation mark, so it is very difficult to build formulas like this.I know it is not the connection, as if I create a pivot from data model, it wor

How do I access Microsoft copilot in my Word document?

Hello, I'm using an Omen Laptop and every time I use Word or even type an email in Outlook, my cursor will return to the middle of the sentence or will skip down to another part of a document. Of course this causes me frustration and also over-writes what I have just written.If anyone has any suggestions to fix this I would appreciate it. I would love to use Word more but something is definitely wrong so I can't write any documents longer than a few paragraphs before it becomes ridiculous.Many thanks.

Why is it.impossible to contact microsoft by phone.or.e en a chat?

I was working with an Excel sheet, and the top taskbar disappeared. I'm not sure what I did, but I need to undo it!Thanks!

My Microsoft OneDrive folder has been taking a minute more to open a folder; each folder and each subfolder. It's unusable and Microsoft should have made this a priority fix, but for some unknown reason, apparently to even their support personnel, it hasn't been fixed.I'm not sure why Microsoft hasn't fixed this problem, unless its a 'competition' thing, but they're making it a lot harder on the subscribers (I presume they want to keep) than this has to be. I've actually started looking around for other cloud storage to avoid this program because of it. Perhaps they have also instructed thei

MS subscription is too expensive. I'm a pensioner. Could you lower the price for me?

I need to be able to record on ms teams and so it seems I must switch from personal to business standard (I want desktop functionality). I pay my subscription annually in September so would like to know I will be refunded for the remainder of the personal term when I make the switch. I would like to do so asap but need help with the process to ensure all my existing office docs and emails etc are still available in the current format I have them.

I DO NOT WANT COPILOT. It looks like I can get rid of it by changing to Microsoft 365 Classic Personal but I don't know what programs come with this subscription.I need Access, Outlook, Excel, and Word. Can anyone tell me the programs that come with this Subscription? Or tell me more about it? Somehow without my knowledge Microsoft changes my subscription from 69.00 to 99.00 very sneaky.

In the past, when you click on the Conditional Formatting drop down and the New Rule you would see an area where you can add a formula for the rule. Now all I see is a New Formatting Rule window with Style and a Minimum & Maximum options as shown below. Even when I go to the Manage Rules window and click the plus sign to add a new rule it takes me back to this screen. Weird and frustrating. Any help would be greatly appreciated.

I'm trying to copy and paste a pdf file into a page on my Loop workspace. I receive a message that says 'We couldn't load 1 image. Check if images are under 10 MB and in SVG, JPEG, GIF, TIFF, HEIF, BMP, ICO or WebP formats'. Is there a reason I can't copy in the Pdf - I'm following the instructions that appear to work for others. The same issue occurs for word and excel files. The file size is below the size limit. I was able to upload a PNG but was not able to upload a JPEG.I'm experiencing this issue when logged in to our family 365 account across mac, ipad and pc.

This applies to Outlook. What does this error message mean: "Internal MAPI error. An invalid parameter was passed to a MAPI function." I received the error message when I was transferring emails over from an SSD

I want to copy the middle row of each block. A block is where BK column contains contiguous 0s. So block1 is A52:BJ61, block2 is A65:BJ67... I have 105 blocks, so I want a copy formula for rows where formula recognizes automatically the blocks based on column BK.As a result I would like to see on another sheet the row56 or row57, row66, row 88 or row89

How to make outlook hyperlinks appear like the URL instead of the page TITLE