What PowerFX command should I use to update a Parent record via a custom button?

(1) Share

Report

Posted on by Viva

Hi everyone!

I do not know if I am in the right place, but I need help with writing a command in Power FX to trigger a custom button in our model-driven app in PowerApps. I searched the internet but could not find the right solution.

Scenario:

I have created a custom button in the model-driven app on the table 'Opportunity Line'. I need this button to update a toggle on the parent Opportunity when a user uses this button (set it to true). As a result, a cloud flow will be triggered.

Currently, I am using this command, but when I click the button, nothing happens:

Patch(

    Opportunities, // Parent entity name

    LookUp(

        Opportunities,

        Opportunity = ThisRecord.Opportunity // Match the OpportunityID in the child record with the parent

),

        'Convert to Sample Request': true

)

I know I am doing something wrong but I don't know what, as I am very new to Power FX commands.

Thank you!

All responses (2)

Answers (1)

Verified answer

Inogic 402 on at

Like (1)

Report

What PowerFX command should I use to update a Parent record via a custom button?

Hi,

This Fx formula will not work on your scenario as it get confused to which opportunity he wants to update. Use the below Power fx formula which will update the toggle field on the parent opportunity.

Patch(Opportunities, Self.Selected.Item.Opportunity,{Forecast:'Forecast (Opportunities)'.Yes})

In this formula Forecast is my toggle field in the Parent Opportunity which gets updated to ‘Yes’ when clicked on the button present in the Opportunity line.

Inogic Professional Services
An expert technical extension for your techno-functional business needs
Power Platform/Dynamics 365 CRM
Drop an email at crm@inogic.com
Service: https://www.inogic.com/services/
Power Platform/Dynamics 365 CRM Tips and Tricks: https://www.inogic.com/blog/
Leah Ju Microsoft Employee on at

Like (0)

Report

What PowerFX command should I use to update a Parent record via a custom button?

Hi Partner,

Do you have to use Power FX command for this purpose?
Maybe consider using a workflow or javscript?

About Power Fx patch function, you can refer to the following documentation:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-patch#modify-or-create-a-record-in-a-data-source

What PowerFX command should I use to update a Parent record via a custom button?

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey

Leaderboard

Featured topics

Product updates

What PowerFX command should I use to update a Parent record via a custom button?

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Meet the Top 10 leaders for December

Start Your Super User Journey

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates