cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jesenavaranjan
Level: Powered On

Microsoft Flows Stored Procedure to submit form

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

 

Hi my question is about using store procedures to submit a form

Do I have to introduce a variable for each of my fields in order to submit the form?

The reason I am considering using store procedures rather than Submit/Patch is because there is some error checking that SQL stored procedures could do while executing, for example checking that the ID is not already taken.

 

Jese

1 ACCEPTED SOLUTION

Accepted Solutions
Dawidvh
Level 10

Re: Microsoft Flows Stored Procedure to submit form

Hi Jesse,

 

You don't need to use forms if you are using patch already. This is a very good article about using patch instead of forms.

https://powerusers.microsoft.com/t5/General-Discussion/Difference-Between-SubmitForm-and-Patch/td-p/...

 

Let me know if you don't come right.

5 REPLIES 5
Dawidvh
Level 10

Re: Microsoft Flows Stored Procedure to submit form

Hi jesenavaranjan.

 

I am not aware of your full requirement, but there might be easier ways to see if IDs have already been allocated, by centrally allocating them for an example. Do you want to elaborate more on the requirements to see if other options exist? If you are sure that you want to use Flow to update the values to the SQL table, you have to initialize a variable to easily specify the 'Ask in PowerApps' for passing data from PowerApps to Flow. How many fields are there? The alternative would be to pass the JSON object as a string to Flow and to then parse that string which will be very fast at runtime, but might have a few considerations.

 

Let me know what your requirements are to see how we can further assist.

 

jesenavaranjan
Level: Powered On

Re: Microsoft Flows Stored Procedure to submit form

Hiya!

 

So the entire form would have maybe 10-15 different fields.

 

I am thinking to use a Store Procedure, due to the fact that I am basing my form off a view.

 

But alternatively I could use Patch right to send the data to two different tables?

 

What would be the better method to do this?

 

Jese

Highlighted
Dawidvh
Level 10

Re: Microsoft Flows Stored Procedure to submit form

Hi Jesse

 

If there aren't speed issues to the database (like on premises data gateway through a slow network connection), then I would suggest to use Patch directly from PowerApps. As you said PowerApps won't be able to patch the view, so just Patch the two tables directly from PowerApps for the update of data.

 

By passing strings to Flow you could speed things up significantly at runtime, but if speed is not an issue, Patch would be easier.

 

Let me know if you don't come right.

jesenavaranjan
Level: Powered On

Re: Microsoft Flows Stored Procedure to submit form

Great!

 

Now, how do I get my gallery to go to a view/new form with the view details

Would I just use 2/3 forms all within the same page?

Or I could use text fields within one form to link to each and every field

& then use patch.

 

Jese

Dawidvh
Level 10

Re: Microsoft Flows Stored Procedure to submit form

Hi Jesse,

 

You don't need to use forms if you are using patch already. This is a very good article about using patch instead of forms.

https://powerusers.microsoft.com/t5/General-Discussion/Difference-Between-SubmitForm-and-Patch/td-p/...

 

Let me know if you don't come right.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 50 members 4,262 guests
Please welcome our newest community members: