You’re offline. This is a read only version of the page.
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.
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?
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?
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)
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.
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:
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.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
