I have Table1 as main list (parent) and Table 2 uses column City as Lookup (table1) to get more fields like State & Country.
Table 3 looks up "School" from Table 2 but I also need the City, State and Country to be visible in this list.
SharePoint list cannot go to nested level lookups in the default setup. Any experts of PowerAutomate who have tried this and made it work ?
-Table 3 should get the values from Table 1 whenever the Table 3 list item is changed or created.
