I'm working on sending several parameters to a PowerAutomate flow.
The variables for the Power Automate Flow is set to capture a String
In my items for the Pistol / Select (this is for an ATF form) I'm running the following below from my drop down menu to select either two types of categories.
If(IsBlank(Manufacture3.Text),Blank(),Distinct(PistolType.PistolType,PistolType))
When I go to submit the information, it keeps erroring out saying the following below
This message keeps popping up when ever I attempt to run my Power Automate flow, with the OnSelect statement shown below.
Set(varShowSpinner, true);
MultiplePistolTransferPDFGenerator.Run(
DateForm.SelectedDate,
DateForm_7.SelectedDate,
Last_First_MiddleMPFT.Text,
FirstNameMPT.Text,
LastNameMPT.Text,
MiddleMPT.Text,
DriversLicenseNumber.Text,
DriversLicense.Text,
DateofBirth.SelectedDate,
SexSelect.SelectedText.Result,
Hispanic.Value,
NonHispanic.Value,
AmericanIndian.Value,
Asian.Value,
Native.Value,
Black.Value,
White.Value,
SexSelect.SelectedText.Result,
Name_of_Agency.Text,
Agency_Address_City_State.Text,
EmployeeFillingoutForm.Text,
FormWasCompleted.SelectedDate,
Manufacture1.Text,
Model1.Text,
SerialNumber1.Text,
PistolSelect1.SelectedText.Result,
CaliberSelect1.SelectedText.Result,
Dateform_1.Text,
Manufacture2.Text,
Model2.Text,
SerialNumber2.Text,
PistolSelect2.SelectedText.Result,
CaliberSelect2.SelectedText.Result,
Dateform_2.Text,
PlaceofBirthCityStateCountry.Text,
WA_State.Text,
TransfereeAddress.Text,
Manufacture3.Text,
Model3.Text,
SerialNumber3.Text,
PistolSelect3.SelectedText.Value,
CaliberSelect3.SelectedText.Result,
Dateform_3.Text,
Manufacture4.Text,
Model4.Text,
PistolSelect4.SelectedText.Result,
SerialNumber4.Text,
CaliberSelect4.SelectedText.Result,
Dateform_4.Text,
Manufacture5.Text,
Model5.Text,
SerialNumber5.Text,
PistolSelect5.SelectedText.Result,
CaliberSelect5.SelectedText.Result,
Dateform_5.Text,
Manufacture6.Text,
Model6.Text,
SerialNumber6.Text,
PistolSelect6.SelectedText.Result,
CaliberSelect6.SelectedText.Result,
Dateform_6.Text,
ConnectedYES.Value,
ConnectedNO.Value
);
Set(varShowSpinner, false);
Basically I want to be able to pass in a NULL value here if nothing is selected, though it keeps giving me that error. Any suggestion would be greatly appreciated.
Thanks!
