Power Automate - Approval Response - Empty Owning User felid

[PowerBI_1]

Dears,

   I'm trying to get owning user from the Approval Response table however, the whole field is empty.

Meanwhile, the source table "user" of owning user field has data.

So any ideas why this column is empty.

[v-jefferni · Accepted solution]

Hi @PowerBI_1 ,

Owning user and Owning team columns are always empty now, you will need to use owner column instead. Please refer to below doc about polymorphic lookups and owner column:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-references#polymorphic-loo...

Since I have no idea of what's the purpose of you to get owner of the approval request, but you may refer to below doc to see the whole steps of creating approval flows:

https://docs.microsoft.com/en-us/power-automate/get-started-approvals

https://docs.microsoft.com/en-us/power-automate/modern-approvals

You will be able to get owner id from the Approval Response table then filter the user table to get its display name when creating the flow.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[PowerBI_1]

Hi  v-jefferni,

Thanks for the feedback.

I'm using a reminder branch in my flow, I need to send it to users who didn't respond.

So I'm trying to check the approval response table by filtring by approval response id (msdyn_flow_approvalresponseidx_approvalid) and owning users (owninguser/internalemailaddress) as per below query:

msdyn_flow_approvalresponseidx_approvalid eq '@{toUpper(body('Create_an_approval')?['name'])}' and owninguser/internalemailaddress eq '@{item()}'

I was applying the following steps stated below video (@28:40) : 

https://www.youtube.com/watch?v=ZupQ0AbDl0I&list=PLTyFh-qDKAiFUGTtwSwFT79Y7_jq_Aipe&index=16

I'm going to try Owner (value) instead.

Thanks again.

[db71]

Hello,  I am wondering if you would mind sharing if you were able to get this expression modified and working for the approval reminders.  I am also trying to follow up on the video, and using Dataverse
(msdyn_flow_approvalresponseidx_approvalid) and owning users (owninguser/internalemailaddress) 

[chnjoku]

Hi @v-jefferni ,

After trying what was described in the video, the flow works as it should but only for my profile.

That is, in an approval request that is sent by me to multiple people (including me), if someone else in this request were to approve, they would still get reminders. But if I were to approve, the reminders would stop.

Could it be because of the Approval Response table? Could possibly only be logging my approval responses alone?

[chnjoku]

Hi @PowerBI_1 ,

After trying what was described in the video, the flow works as it should but only for my profile.

That is, in an approval request that is sent by me to multiple people (including me), if someone else in this request were to approve, they would still get reminders. But if I were to approve, the reminders would stop.

Did you experience this issue as well or can you share how you solved it?