Power Platform Community Forum Thread Details

Hello. Is my syntax below correct? I seem to only be getting the true results and not the false.

If
(
varCreatedByGM = "true",
Set(varPPQStatus, "VP Scope Review")&&
Set(varCurrentOwner, varVP)&&
Set(varEmailRecipient, varVP_Email)&&
Set(varGMDec, "Approve Scope")&&
Set(varGMDecDate, Today())&&
Set(varCurAprID, varVPId)&&
Set(varSelected, varRetailCount+varServicesCount+varFoodCount+varFuelCount)&&
Set(varRetailResponse, 0)&&
Set(varServicesResponse, 0)&&
Set(varFoodResponse, 0)&&
Set(varFuelResponse,0)
,(
Set(varPPQStatus, "GM Scope Review")&&
Set(varCurrentOwner,varGM)&&
Set(varEmailRecipient, varGM_Email)&&
Set(varCurAprID, varGMID)&&
Set(varSelected, varRetailCount+varServicesCount+varFoodCount+varFuelCount)&&
Set(varRetailResponse, 0)&&
Set(varServicesResponse, 0)&&
Set(varFoodResponse, 0)&&
Set(varFuelResponse,0)
));

Thank you

Categories:

Building Power Apps

Now I feel silly. I saw my mistake as soon as I hit the submit button. I had too many parenthesis.

If
(
varCreatedByGM = "true",
Set(varPPQStatus, "VP Scope Review")&&
Set(varCurrentOwner, varVP)&&
Set(varEmailRecipient, varVP_Email)&&
Set(varGMDec, "Approve Scope")&&
Set(varGMDecDate, Today())&&
Set(varCurAprID, varVPId)&&
Set(varSelected, varRetailCount+varServicesCount+varFoodCount+varFuelCount)&&
Set(varRetailResponse, 0)&&
Set(varServicesResponse, 0)&&
Set(varFoodResponse, 0)&&
Set(varFuelResponse,0)
,
Set(varPPQStatus, "GM Scope Review")&&
Set(varCurrentOwner,varGM)&&
Set(varEmailRecipient, varGM_Email)&&
Set(varCurAprID, varGMID)&&
Set(varSelected, varRetailCount+varServicesCount+varFoodCount+varFuelCount)&&
Set(varRetailResponse, 0)&&
Set(varServicesResponse, 0)&&
Set(varFoodResponse, 0)&&
Set(varFuelResponse,0)
);