cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBI_1
Regular Visitor

Power Automate - Approval Response - Empty Owning User felid

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-jefferni
Community Support
Community Support

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.

vjefferni_0-1632383286507.png

 

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.

View solution in original post

2 REPLIES 2
v-jefferni
Community Support
Community Support

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.

vjefferni_0-1632383286507.png

 

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.

View solution in original post

PowerBI_1
Regular Visitor

Hi  ,

 

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,828)