Hi,
I'm not sure how if this is possible and I'm it is and I'm missing something obvious. I have 3 tables named App Portfolio, Licensing and the existing Microsoft Entra table.
The App Portfolio table has a column called 'Technical Owner' which is a lookup to the Entra table.
The Licensing table has a lookup to the App Portfolio table on the App Name column and when I add a new record to the Licensing table I can get a list of applications from the App Portfolio which is great. I also want to get the Technical Owner as well but it doesn't seem to work? Have I missed something?
If I can get the Technical Owner from the App Portfolio is it possible to change it on the Licensing table and have it update the App Portfolio table?
Essentially there will be 5 or 6 tables that require the 'Technical Owner' column and I'd if it's changed on one table I'd need it to update all other tables.
Is this possible in a model driven app?
Make sure you publish all customizations and refresh your browser. The form component control should let you pick the lookup column, see the related table and select a "related form". Form order shouldn't matter and it should let you pick exactly which form to display. Note that only the first tab will display so add everything you need there.
Ah nice, thank you, this works.
My second question relating to the 'Form Component Control' is that I have a 'main' view that I want users to enter lots of information in the App Portfolio but I don't want to use this view as a Form Component Control form on other tables.
I created a new form named 'TechOwner' in the App Portfolio table, copied the form ID GUID and added it to the 'Form Component Control' but it still shows the main form and not my new one. I'm assuming the form order in the settings matters and I'm not able to do this in a secondary form?
If you want to see the technical owner you can use the Quick View forms and insert it in your form. Link it with the lookup for app portfolio and you’ll be able to see the Technical Owner.
if you want to Edit the value directly from the licensing, you can use the ‘Form’ control instead of the ‘Quick View’. This will insert the entire form from the App Portfolio in an editable mode.
if you want synchronization across specific rows, i’d recommend setting that up in Power Automate.