Support me to correct my formular

(1) Share

Report

Posted on by SP-20030321-0

Hi admin,

I studied new Power app for supporting my job. I just create the new one and I dont know what is the error with my formular. Could you take a look to correct my formular and for "Submit buttom" . Thank you to all.

Receive sample.docx

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@SP-20030321-0,

You have created the controls seperately, and there is no formula you have written for submit logic and try with the form controls in Power Apps

Submit (Button)-> On Select -> Try with SubmitForm(FormName) if you are using the form control.

Form Control

https://piyushksingh.com/2018/09/20/powerapps-edit-and-submit-form/

https://www.matthewdevaney.com/10-things-you-should-know-about-power-apps-forms/

If you are design the individual controls like this you need to use the Patch function

Patch

https://www.matthewdevaney.com/7-ways-to-use-the-patch-function-in-power-apps-cheat-sheet/

https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-image-column-in-power-apps/

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
SP-20030321-0 6 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank Regavendar, Could you advice for my case? I just study so I think I don't know how to change as your suggestion.

Was this reply helpful? Yes No
Suggested answer

DP_Prabh 381 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SP-20030321-0,

To perform operations such as adding a new record to a table, you can use form controls. Allow me to guide you through the process step by step.

1. In your canvas app. Go to Insert button and type form you will see two types of form one is modern control "form" and other one as "Edit form". You may select any form.

2. When it is displayed on screen it will say you to add a data source so add your Data source that can be Dataverse or SharePoint. Once you select a table for example I have selected Dataverse table named "ProjectTasks" that will be shown in DataSource property of Form.

3. All the fields will be shown to you on screen and if you want you may add additional as well from field property by edit button

4. Now as we are creating a new record from this form so its default mode property should be set to "New".

5. For submitting the record to Dataverse we will add a submit button and add code as
SubmitForm(formName); //replace formName with your form1/form2 name check from properties only at top it is given.

After this the record will be saved to Data source and for more learning you may watch this youtube video as well (https://youtu.be/HHXKfB1iAH4?si=vsvqee2t4nvP2qx9)

And after this do follow Microsoft documentation on same (Understand canvas-app forms - Power Apps | Microsoft Learn)

For functions (EditForm, NewForm, SubmitForm, ResetForm, and ViewForm functions - Power Platform | Microsoft Learn)

I hope this works for you!

Was this reply helpful? Yes No