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.
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.
Solved! Go to Solution.
Figured it out! What I did was create a blank value in SQL in my table for Pistol and Caliber select. Thus when I have no value there, that works and it goes right through. Problem solved 🙂
Sorry, a bit confused here.. what is the Type3 you are setting ?
If this is what you used to set the Type3 value
then why can't you simply change this to
Orelse, you have an option to check the value in the powerautomate it self and set it to empty instead of null.
And also, If I were to design this - I would not set these many params to PowerAutomate, which is not only confusing & un readable but also difficult to extend. I would rather use a JSON formatted text and send it as a record to the Powerautomate.
Could you please expand where you are using this formula (on what event) and what is the error and how its been used to send to Power Automate?
@ansrikanth can you elaborate a bit regarding what you are looking for here? Just so I know what I need to send back here to make a bit more sense as to what I'm trying to do.
I Understand you are sending some parameters to a Power automate flow, one of the parameter is sending a Null value which is causing problem in the power automate to set a string variable.
What I didn't understand is where you are using the formula
and how it is related to your power automate flow.
Not really related, the reason I was doing it that was way was to force the NULL value, from the error I was getting. For getting the items for that dropdown list, usually I'll use
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us on June 28 for our monthly User Group leader call!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.