cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Posfog
Helper I
Helper I

Put check in place in formula to make sure data is present?

Hi All,

 

I have the following button with the following forumla running off the onselect and wondered if there a way to stop the data being sent to all the share point list if 'Main Form' is showing an error due to missing data?

As currently if someone has forgot to put the date details in the button sends data to all other lists apart from 'Main Form' due to missing data

 

 

 

SubmitForm('Main Form');
SubmitForm('Hazard form');
SubmitForm('Cost form');
SubmitForm('5s Form');
SubmitForm('SWC Form');
SubmitForm('Downtime form');
SubmitForm('Quality form');
ResetForm('Main Form Blue AJ200P');
ResetForm('Hazard form');
ResetForm('Cost form');
ResetForm('5s Form');
ResetForm('SWC Form');
ResetForm('Downtime form');
ResetForm('Quality form')

 

 

 

Hope that makes sense?

 

Regards

P

3 REPLIES 3
MrNappa
Kudo Collector
Kudo Collector

You can use OnSuccess/OnFailure properties of your 'Main Form'. Refer to SubmitForm documentation. So you probably want the button to only call the submitform of the main form, and then in the 'OnSuccess' you can do the subsequent SubmitForm calls.

Hi @MrNappa,

Would this keep the ID numbers of all the SP lists then the same (as long as they are in sync), as currently if all SP lists are on number ID 99 and the user forgets to put date in the "main form" stays on 99 and the rest go up by one.

 

 

Regards

P

eka24
Super User
Super User

If all the fields or some of them are required then, Click the datacard/ Datacards and Mark as required.

Another option is to take each datacardvalue example
If(IsBlank(datacardvalue.Text),Notify("Fill all Data",SumitForm(A);SumitForm(B))

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (4,072)