The Power Of Remembering: Wkvi Obit News And Condolences

I'm working on a Power Automate flow that updates items in a SharePoint Online list. However, I'm facing an issue where certain columns (including Person/Group fields) are not appearing in the "Update item" action.

The Power of Remembering: Wkvi Obit News and Condolences 1 Exclusive Content Member Only — Sign Up Free 🔒 Unlock full images & premium access

Power Automate – Some SharePoint List Columns Not Appearing in "Update ...

Is this just part of the building process? Or If I have one query A that loads across the network and 5 follow up queries that refer to query A will power query / excel be reading the across the network 1 time or five times? What is the proper way in Power Query to refer to an existing query and reduce data pulls across the network?

The Power of Remembering: Wkvi Obit News and Condolences 3 Exclusive Content Member Only — Sign Up Free 🔒 Unlock full images & premium access

Power Query code to refer to another query (and how buffering works)

The Power of Remembering: Wkvi Obit News and Condolences 4 Exclusive Content Member Only — Sign Up Free 🔒 Unlock full images & premium access

Am trying to get output in Power Automate as only "Mv_somethingunkown", while just searching as Mv as the array will be dynamic and after Mv the text will be changed everytime.

The Power of Remembering: Wkvi Obit News and Condolences 5 Exclusive Content Member Only — Sign Up Free 🔒 Unlock full images & premium access

But in Power Automate, if I use the "Send an HTTP Request" action (under "Office 365 Outlook") and send a request to that same endpoint, it returns a lot of the message information but not the categories. I have also tried the "Get Email (V2)" and "Get Emails (V3)" actions, neither of them includes categories in the output either.

The Power of Remembering: Wkvi Obit News and Condolences 6 Exclusive Content Member Only — Sign Up Free 🔒 Unlock full images & premium access

I signed out and in multiple times in "power automate". I also opened the "sharepoint app" in Office365 (whatever you're supposed to do with it) which worked fine. The sharepoint connector in power automate also seems to be happy: Any ideas how to get the sharepoint connection running again ?