Save data and submit form

(0) Share

Report

Posted on by Tapesh

825

Hi All,

I m trying to work on some functionality which is create a collection of input values in text filed and then save them to SPlist, also i want that, if the value is Zero by default in Weekly total, he should get the error else he should be able to submit the form. and reset the form to Zero value.

can this be possible ?

if yes help me whats ways i can achieve this.

Experts advice is really appreciated.

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Tapesh ,

If you can share more details of the App implementation process, it will be more helpful for us to solve the problem.

Do you mean you want to add a condition before submitting the form to check if the Weekly total field is zero?

Please try this on Submit Button.OnSelect property:

If(WeeklyTotalTextBox.Text="0", Notify("Error Message",NotificationType.Error), SubmitForm(FormName))

Hope this helps.

Sik
Tapesh 825 on at

Like
a
(0)

Report
Copy link

Link copied!

HI

The condition is now,

i this was working fine before but now has and issue, I'm working on something like,

ON screen 1, I have form1, and then the button which takes it to next screen which is form2,

so now i want that, when you submit the form2, the condition which you saw should execute, and if yes, then submit form1 , So basically submitting From1 and From2 at once, and when Form1 is successfully submitted then there is patch function on my Form1 of Onsucess which should execute.

I know its bit messy but if you any other solution for such thing is also welcome.
v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Tapesh ,

Truly, I feel a little confused about your needs. Are there any sample or screenshots to describe your needs?

Do you mean to apply the condition to Form2's Submit Button.OnSelect property?

If so, set SubmitForm2Button.OnSelect property as follows:

If(WeeklyTotalTextBox.Text="0", Notify("Error Message",NotificationType.Error), SubmitForm(Form1);SubmitForm(Form2))

Sik
Tapesh 825 on at

Like
a
(0)

Report
Copy link

Link copied!
Thats Great i just sorted out that with your above suggestion and some other missing stuffs,

but yea @v-siky-msft

Im stuck here in this major situation where i need to see my gallery items only which has Full Name as that's the single record you can in image below but also want to show status but that's not single its repeated , is there a way to only update status only once? as this is updated when the flow runs behind, and when the approver approves this also updates all other records in the same Full name. which is the reason my gallery is looking like this.

Do you have any solution or suggestion to this?
Please see the screen shots below and formula
on Items property of Gallary:
SortByColumns( Filter( 'Petty Cash & GL Code', // here we are saying that the status variable must be "All", // which will then not filter any items, or else the status must match the variable StatusResult="All" || Status = StatusResult & 'Full Name', // here we are saying, the textbox text is a blank or else it must // additionally filter the above by EmployeeName based on the Textbox Text SearchBox.Text = "" || StartsWith('Full Name', SearchBox.Text) ), "Title", If(SortDescending1, Descending, Ascending) )
ON Submit button of Onselect event of Form:
If(Value(DataCardValue26.Text) = 0,true, Notify("Weekly total value must be more then 0", NotificationType.Error);); Set( SelectedUnitName, 'Edit_Unit Name_Input_1'.Selected.Value ); ResetForm(Edit_Total_Form); SubmitForm(WeeklyFrom_Edit); Set(VarWeekTotal, DataCardValue26);
On Success of Submit Form:
ResetForm(Edit_Total_Form); ResetForm(WeeklyFrom_Edit); Navigate(Total_EditScreen); ResetForm(Edit_Total_Form); ForAll( Recordss, Patch( 'Petty Cash & GL Code', Defaults('Petty Cash & GL Code'), { Title: User().FullName, TripDescription: Trip, Catering_HouseKeeping: Catering_HouseKeeping, Casual_Transport: Casual_Transport, Equipment_Shortlife: Equipment_ShortLife, Programme_LifeSkills: Programme_LifeSkills, Cleaning_Household: Cleaning_Household, Medical_FirstAid: Medical_FirstAid, Heat: Heat, Bank_Charge: Bank_Charges, Sports: Sports, 'Misc ': Postage, Total: Total, WeeklyTotal: WeeklyTotal, 'Date ': Datetime } ) ) ;
Also please see the sharepoint image how does this looks and how gallery looks likeSharepoint ListGallery