Now, the problem is I want to have a custom list which will show me Area Name, Area Weight and a dropdown to show list of all impacts (and auto select which impact value user has already selected) Can anyone help with that?
The custom list is not showing final results properly. This is what I get to see
The properties called Area Weight and Area Name are stored in the Area collection right? If the relationship between the Area collection is One to Many you can access like Area’s > Weight, Name but if it’s Many to Many you need a list to show that areas inside of the impact on area record.
So you can make the text component a list by clicking three dots on top and make list and then you can connect it to the Areas collection and filter it for current impact on area and add name and weight from magic text!
For the drop-down, does the Impact relationship is empty?