Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

Solution with flexible defaults for fields

(0) ShareShare
ReportReport
Posted on by 25

Hello,

 

I have a modeldriven app and tables in a soltution. The solution is distributed to multiple customers. 

On the table X there is a field description and a lookup field from table Y. Table X and Y can be filled by the different customers with records that they want.

 

When a customer makes a record in table X and just fills in the description nothing needs to happen.

When a customer makes a record in table X and also fills the LookUP field from table Y, then automatically the value of the name field of table Y needs to be filled in the description field of that record. 

 

My question is how can I do this real time in a solution, so not through a Power Automate flow? (because then the user has to refresh to see if the changes have taken effect. 

 

  • Business Rules is not possible
  • Is a proces an option? If so how do you configure this?

 

Thank you in advance for your solutions!!

 

 

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,273 on at
    Re: Solution with flexible defaults for fields

    Hi @Brutus ,

     

    In this situation you have a 1 to Many relationship from Table X to Table Y.   Setting the value on Table X will not allow (without a custom workflow action) to set the value of the Name on Table Y since this is a child / many relationship from X.  

     

    You could create a Plugin or a Custom Actitvity (https://learn.microsoft.com/en-us/power-apps/developer/data-platform/workflow/sample-create-custom-workflow-activity)  and call from the synchronous workflow to set the value but this will require code.  Power Automate would be possible but this is asynchronous vs. synchronous.

     

  • Parvez Ghumra Profile Picture
    Parvez Ghumra 1,572 on at
    Re: Solution with flexible defaults for fields

    @Brutus Yes, you can use a real-time/synchronous workflow to achieve this.

     

    In your solution, choose New > Automation > Process > Workflow and fill out the necessary details such as scope, trigger, table to trigger on and then proceed to fill out the logic

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,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics