Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Answered

Entra and updating multiple tables

(1) ShareShare
ReportReport
Posted on by 11

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?

  • ivan_apps Profile Picture
    ivan_apps 2,187 on at
    Re: Entra and updating multiple tables

    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.

  • cRaYoN Profile Picture
    cRaYoN 5 on at
    Re: Entra and updating multiple tables

    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?

  • Verified answer
    ivan_apps Profile Picture
    ivan_apps 2,187 on at
    Re: Entra and updating multiple tables

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard

Featured topics