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 Commander
Kudo Commander

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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,147)