Down the Rabbit Hole! External Sharing of SP List with powerapps Form & Email notification

So I discovered a lot about this,and i think I have a way out.
1. The "old data" was because I had versioning enabled, and users set to view only Approved items (or at least "approved item VERSIONS - which were old of course". All the recent documents were set up "pending" state, due to me doing an "update item" in the flow, after the approval. I have now set users to be able to view drafts, but also added a "Set Approval Status" Step at the end of my flow (one for reject, one for approve)
2. It is true that no matter what I do, I cannot get the O365 connector to work with a Runtime User, and I also can't get a child flow to isolate my powerapp from the O365 connector.
SO
I'm going to put a helper column in the database which I will set to "1" when an email needs to be sent. I'll have another flow, with a change trigger, conditional on seeing this "1". At that point, it will pull the data, send the email and reset the trigger to "0" to avoid recursion.
I'm hoping that will work.