Power Automate - Approval Response - Empty Owning User felid

(0) Share

Report

Posted on by 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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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-lookups

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.

Was this reply helpful? Yes No
PowerBI_1 5 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
db71 2 on at

Like (0)

Report
Copy link

Link copied!

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)

Was this reply helpful? Yes No
chnjoku 4 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
chnjoku 4 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No