The Power Of Everyday Missionaries

I am writing a Power automate to copy emails from an Outlook mailbox to SharePoint. I am using Get emails (V3) and want to retrieve emails received on a particular date.

power automate - How to write Search Query in Get Emails (v3)? - Stack ...

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 Everyday Missionaries 3

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.

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 Everyday Missionaries 6

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

The Power Of Everyday Missionaries 7

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 ?

The Power Of Everyday Missionaries 8