I am really hoping someone can help as I am trying to get the PowerAutomate to work before the SharePoint 2010 workflow stop working on 11/1. TIA!!
I am working on a PO Approval process and the form is created using Infopath 2013. The approver is dynamic and users use the people picker to select the approver.

The form is saved as XML and it is saved in SharePoint as XML forms library (looks very similar to SharePoint List). Approver is saved as single line text. I created a new column named ApproverEmail to try to capture the email address using PowerAutomate.
I setup a quick Flow to update the ApproverEmail column:
When an item is created -> XML forms library
Get User Profile (v2) -> Approver
Update item -> Approver Email: Mail

When I run the flow, I kept getting the "ResourceNotFound" and "User not Found" error.

I have tried with several approvers and got the same error. I confirmed they are all licensed users in the O365 tenant. Any help would be appreciated!!