cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LiLiBeca
New Member

Added a new column (lookup), but it doesn't show up in the dataflow mapping step

I have added a new column called "Owner" in the table, see below,

LiLiBeca_0-1615524936544.png

but when I try to update the dataflow to map that new column, it's not showing up, see below,

LiLiBeca_0-1615525158634.png

Anyone knows why? Thanks in advance.

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Fubar
Solution Sage
Solution Sage

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-datafl...

View solution in original post

EricRegnier
Super User II
Super User II

Hi @LiLiBeca,

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:

EricRegnier_0-1615619165798.png

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!

View solution in original post

3 REPLIES 3
Fubar
Solution Sage
Solution Sage

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-datafl...

View solution in original post

EricRegnier
Super User II
Super User II

Hi @LiLiBeca,

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:

EricRegnier_0-1615619165798.png

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!

View solution in original post

Yes, after the key set up in the owner table, it works now. Thanks!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Kudoed Authors
Users online (26,740)