Power Platform Community Forum Thread Details

Hello,

I am currently developing a Power Apps application that includes several columns:

EngineeringRequired (Yes/No)

MarketingRequired (Yes/No)

OperationRequired (Yes/No)

QualityRequired (Yes/No)

Additionally, we have corresponding status columns:

EngineeringStatus (Text)

MarketingStatus (Text)

OperationStatus (Text)

QualityStatus (Text)

Scenario:

If any of the “Required” columns (e.g., EngineeringRequired, MarketingRequired, etc.) are set to “Yes,” the corresponding “Status” column (e.g., EngineeringStatus, MarketingStatus, etc.) should be set to “Approved.” Only after these conditions are met should the Patch function be executed.

Example:

If EngineeringRequired is true, then EngineeringStatus should be set to “Approved.”

Similarly, this check should be performed for all columns before proceeding with the Patch function.

Categories:

Building Power Apps

Hi ursNani,

Here's how you can achieve this -

Lets assume you are using Dropdowns to get the user inputs.

The Default property of the Dropdown2 will be this (make sure AllowEmptySelection is set to true):

If(
    Dropdown1.Selected.Value = "Yes",
    "Approved",
    Blank()
)

And the patch function will be the following (BTW, you can also perform this check in the Patch statement but lets keep it simple):

Patch(
    DataSource,
    Defaults(DataSource),
    {
        EngRequired: Dropdown1.Selected.Value,
        EngStatus: Dropdown2.Selected.Value
    }
)

Here's how it looks: