I am creating a button and associate it with the power automate below. I have add in the app but is say missing connector.
any idea what connector to add?
Button Codes
Set(
varFlowMessage,
{response: ""}
);
Set(
sUserPIN,
"PH007135"
);
Set(
sRequestStatus,
If(
!IsBlank(Request_Status.Selected.Value),
" and RequestStatus eq('" & Request_Status.Selected.Value & "') ",
""
)
);
Set(
sRFKDS,
If(
!IsBlank(txt_RFKDS),
" and substringof('" & txt_RFKDS & "',RFKDS) ",
""
)
);
Set(
sCurrentStep,
If(
!IsBlank(txt_Current_Step),
" and substringof('" & txt_Current_Step & "',CurrentStep) ",
""
)
);
Set(
sCurrentReviewer,
If(
!IsBlank(txt_Current_Reviewer),
" and substringof('" & txt_Current_Reviewer & "',CurrentReviewer/Title) ",
""
)
);
Set(
sCountry,
If(
!IsBlank(drp_Country.Selected.Value),
" and Country eq '" & drp_Country.Selected.Value & "'",
""
)
);
Set(
sDivision,
If(
!IsBlank(drp_Division.Selected.Value),
" and Division eq '" & drp_Division.Selected.Value & "'",
""
)
);
Set(
sGroup,
If(
!IsBlank(drp_Group.Selected.Value),
" and Group eq '" & drp_Group.Selected.Value & "'",
" and substringof('" & User_Group & "',Group)"
)
);
Set(
sInitator,
If(
!IsBlank(txt_Initiator),
" and substringof('" & txt_Initiator & "',Requester) ",
" and substringof('" & User().FullName & "',Requester) "
)
);
UpdateContext(
{
pin: Substitute(
Office365Users.MyProfile().UserPrincipalName,
"@mellon.com",
""
)
}
);
Set(
sGroup,
If(
!IsBlank(drp_Group.Selected.Value),
" and Group eq '" & drp_Group.Selected.Value & "'",
""
)
);
Set(
varFlowMessage,
AsiaRFKDS_Prod.Run(
sUserPIN,
sInitator,
sParticipants,
Date_To.SelectedDate,
Date_From.SelectedDate,
sRequestStatus,
sRFKDS,
sCurrentStep,
sCurrentReviewer,
sCountry,
sDivision,
sGroup,
""
)
);
Notify(
varFlowMessage.response,
NotificationType.Success
);
Set(
sInitator,
If(
!IsBlank(txt_Initiator),
" and substringof('" & User().FullName & "',Requester) and substringof('" & txt_Initiator & "',Requester) ",
" and substringof('" & User().FullName & "',Requester) "
)
);
Set(
sParticipants,
User().FullName
);
PowerAutomate:
