You’re offline. This is a read only version of the page.
14
Not fully understanding lookups, here's a brief explanation of my scenario:
What I don't understand is how this lookup is made and populated automatically? Without using a 'relate rows' action in a flow, and I haven't provided a foreign key anywhere, but the lookup is automatically populated in Table A with a link to a row in Table B?
I did notice that the two tables somehow share a column. Not just display name, but the actual column name, and they are both of type text. I'm not sure how this happened. Could there be a 'relate rows' somewhere that I haven't been able to find or another explanation.
I have read the documentation on lookups many time, but can't understand how data would be populated without first relating the rows.
Thanks for your help!
__fan__
I went through this confusion before. Here is what I did to try to make sense of what is exactly happening when we create one-to-many relationship.
NOTE: Using DataFlows, you can import Data to the Lookup Column and it will link to the Values in the ONE table, BUT you have to make sure the ONE table has a KEY and it is that ID UNIQUE Column you created.
Try creating a record if it is not getting populated try editing an existing record.
To identify from where it is getting triggered,
1. javascript - check if any onchange event registered for the lookup field or formproperties to check for onsave event handler.
2. OOB workflow - settings->processes, Activated Process view - filter primary entity to Table A and category to workflow. Open if any workflow registered and look for update step.
3. Plugin - Open default solution-> sdk message processing steps, filter primary object type to Table A
If it answers your question, kindly give kudo and accept it as solution.
Regards,
Prakash
Hi @Prakash4691 thanks for your help!
It is not the same record being populated. A unique row is being matched along the shared column in each table. I have looked for update row and relate row actions... nothing.
I am not sure if it is changing on create or on update. Is there a way to trace this back, or even to see what process populated the data? This might provide some more insight.
Thanks,
__fan__
Hi @microsoft_fan ,
Is it auto populating on create or update of table A?
There might be 3 place where you can check,
1. OOB workflow - create, update (trigger)
2. Javascript - onsave, onchange (event handler)
3. Plugin - create, update (trigger)
In power automate look for "update row" action.
Is it the same record of Table B been populated on Table A for all the records?
Regards,
Prakash
#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 (
