You’re offline. This is a read only version of the page.
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.
Yes, after the key set up in the owner table, it works now. Thanks!
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!
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.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
