Notifications
Announcements
I have added a new column called "Owner" in the table, see below,
but when I try to update the dataflow to map that new column, it's not showing up, see below,
Anyone knows why? Thanks in advance.
You probably need to set a Key (alternate key) without one the lookup fields do not show up in the mapping. The following link has a bit of description etc.
https://dynamicscitizendeveloper.com/2020/04/21/how-to-map-a-lookup-field-in-a-power-platform-dataflow/
Hi @Anonymous,
To clarify, unfortunately it's not supported to map Owner type of columns/fields with Dataflows even when alt keys are defined on the User table (@Fubar FYI). You'll need to create a new custom Lookup pointing to User (systemuser) table and then your Dataflow will auto detect it. Here's an example:
If you really want to then set the Owner, have a Power Automate flow that triggers when the custom User lookup is updated to set the Owner column. If you absolutely need that in sync/real-time, you can use a classic workflow.
Hope this helps!
Yes, after the key set up in the owner table, it works now. Thanks!
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 721 Most Valuable Professional
Michael E. Gernaey 320 Super User 2025 Season 2
Power Platform 1919 268
