web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : G9elfrsS829k3v9+IrIoJy
Power Apps - Microsoft Dataverse
Answered

Power Automate - Approval Response - Empty Owning User felid

Like (0) ShareShare
ReportReport
Posted on 15 Sep 2021 21:01:58 by 5

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:
  • chnjoku Profile Picture
    4 on 26 Dec 2023 at 18:06:32
    Re: Power Automate - Approval Response - Empty Owning User felid

    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?

  • chnjoku Profile Picture
    4 on 26 Dec 2023 at 17:59:55
    Re: Power Automate - Approval Response - Empty Owning User felid

    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?

  • db71 Profile Picture
    2 on 01 Apr 2022 at 22:27:21
    Re: Power Automate - Approval Response - Empty Owning User felid

    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) 

  • PowerBI_1 Profile Picture
    5 on 02 Oct 2021 at 06:27:38
    Re: Power Automate - Approval Response - Empty Owning User felid

    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.

  • Verified answer
    v-jefferni Profile Picture
    on 23 Sep 2021 at 07:48:00
    Re: Power Automate - Approval Response - Empty Owning User felid

    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.

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics