cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kran
Helper II
Helper II

Canvas app + business rule + excel?

I have a situation were I want to create a canvas app where the data source will be a large excel file.

Is it still possible to create business rules in Power apps that validates the data that is being entered?

9 REPLIES 9
eka24
Super User III
Super User III

Watch this tutorial from Reza on form validation. I hope it resolves your issues:

https://youtu.be/XvevCq6qhX4

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Thanks for your reply. But I can´t see anywhere that he´s doing validating by using business rules?

eka24
Super User III
Super User III

Can you give details of those business Rules to be used in Canvas App with the excel.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

For e.g. that a field most start with the prefix ABC otherwise a warning will be displayed. Thanks!

eka24
Super User III
Super User III

For instance on OnSelect of a save button, you can put this code:

 

If(StartsWith (TextInput1.Text,"ABC"), SubmitForm (FormName), Notify("Textbox1 should start with ABC", Notification.Error))

 

Documentation:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-startswith

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

https://www.youtube.com/channel/UCjkyqaAf_ww8T98V99lkfow/

@eka24thanks for your reply. I understand this is one way to create validations in a canvas app form, however you are not using Business Rules in Power Platform with your approach.

eka24
Super User III
Super User III

Business Rules is applicable in Model Driven App. Similar approach in Canvas is what I showed earlier in the post. Rules in Canvas doesn't exist anymore :

https://www.google.com/url?sa=t&source=web&rct=j&url=https://powerapps.microsoft.com/en-us/blog/canv...

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Business rules is also applicable in canvas apps )not only model driven apps). My question is if that is going to work even though my data source is not Dataverse.

eka24
Super User III
Super User III

I would be glad if you can share on business Rules in Canvas App as it is in Model Driven App. That may help to determine if it would work on excel.

My understanding is Model Driven App with Dataverse.

 

Kindly share your knowledge on the business Rules with canvas which  is different from the validation I gave earlier based on your "ABC" request

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (36,973)