To set certain DataCardValue fields to a default value based on the selection made in another field, you can use the "Switch" function in Power Apps. Here is an example formula that you can use:
Switch(DataCardValue06.Selected.Value, "X", UpdateContext({varDefault: "N/A"}));
In this formula, we are using the Switch function to check the value of DataCardValue06. If the selected value is "X", we are using the UpdateContext function to set the varDefault variable to "N/A". You can replace the "varDefault" with the name of the DataCardValue fields that you want to set to "N/A".
After setting the variable, you can use it to set the default value for the DataCardValue fields that you want to update. Here's an example formula for DataCardValue07:
If(IsBlank(DataCardValue07.Selected.Value), varDefault, DataCardValue07.Selected.Value)
This formula checks if a value has already been selected for DataCardValue07. If it's blank, it uses the varDefault variable as the default value. If a value has already been selected, it uses that value.
You can use similar formulas to set default values for DataCardValue08 and DataCardValue09. Make sure to update the names of the fields and variables as needed.
If my answer was helpful in solving your issue, please consider marking it as the solution by clicking the 'Mark as solution'.
