Answered

Showing Mandatory Fileds with Asterisk (*)

(1) Share

Report

Posted on by AkshayManke

Hi, Needing one help related to Making/Showing Mandatory Columns in PowerApps.

Trying to build application using a SharePoint List at the backend. Initially when i started developing the app, any of the field in the SharePoint was not mandatory but later i made it mandatory as per the requirement.

Now in the PowerApp I am expecting an asterisk (*) to each of field header as a symbol to Mandatory Field. But I am not getting the (*). Tried to refresh the data source many times. Also when i am clicking on Submit button, i am not getting any error message in the same screen where the form is, whereas i am getting redirected to HomePage and then i am getting the Notification at the top of the app screen that some issue is there. The button code is as below.

UpdateContext({varSpinner:true}); SubmitForm(Form1); Navigate(HomeScreen)

I want that, if any if the field is empty then the form should not be submitted and the user must be on the same screen.

How can i achieve that?

Regards,

Akshay

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Verified answer

Mr-Dang-MSFT Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!

Hi @AkshayManke ,

It sounds like you want to make fields required in an app that you have already added the data source.

Each card of the form has a "Required" property that is set to true or false. This lets you require fields that may not be required at the level of the data source. Set this to true for the fields you want required and the asterisk will appear.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @AkshayManke ,

Do you want to make fields in your Edit form as Mandatory Field?

Do you make these fields in your SP List as Required fields?

On your side, please consider refresh the SP list connection in your canvas app. Then go to your Edit form, remove the field data cards from there, then re-enable them again, then these Asterisk (*) would be shown up for these Mandatory Fields in your SP List.

In addition, I also agree with @Mr-Dang-MSFT 's thought almost. The Asterisk (*) symbol for field data cards in Edit form is based on the "Required" property of the data card in your Edit form. So you also consider set the Required property of the Data card in your Edit form to following:

true

to make field data card as Mandatory Field in your Edit form.

Regards,

Was this reply helpful? Yes No
AkshayManke 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xida-msft,
Yes, the canvas app is having lots of fields added with the setting (Font Size, Type, etc.) configured using variables hence it will difficult to add new fields and reconfigure them again.
Instead i will use the option suggested by @Mr-Dang-MSFT , to change the 'Required' property value to true. This will save the time.
I will test this and will accept the answer as solution shortly.
Regards,

Was this reply helpful? Yes No
AkshayManke 2 on at

Like (0)

Report
Copy link

Link copied!
Hello @Mr-Dang-MSFT,

I tried changing the filed 'Required' Property Value to 'true'. I got the asterisk (*) but still i am redirecting/navigating to my HomeScreen. Do i need to add any code in the Submit Button to test if all the values are entered in the Mandatory fields, then only the form must be submitted and navigated to HomeScreen else user to get notification that required filed inputs are missing.

Can you please guide me to achieve this?
Below the button code for your reference.
UpdateContext({varSpinner:true}); SubmitForm(Form1); Navigate(HomeScreen)

Thanks,
Akshay

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @AkshayManke ,

Regarding the needs that you mentioned, I think the Form1.Valid formula could achieve your needs. The Form1.Valid formula would detect if all required fields in your Edit form are populated with proper value already.

Please modify your OnSelect formula as below:

UpdateContext({varSpinner:true}); If( Form1.Valid, // modify formula here SubmitForm(Form1);Navigate(HomeScreen), Notify("Thare are some Required fields are not populated with proper value, please check!", NotificationType.Error) );

Regards,

Was this reply helpful? Yes No
AkshayManke 2 on at

Like (0)

Report
Copy link

Link copied!

Hello @Mr-Dang-MSFT & @v-xida-msft, I got the solution from both of your help. So i am accepting your both reply as solution.
Thanks a lot for the help.!!
Akshay

Was this reply helpful? Yes No
hotkarvind 2 on at

Like (0)

Report
Copy link

Link copied!

I have found simple and fast solution on this.
1. Select card which you want to make compulsory.
2. right Click on card and say Unlock.
3. After unlocking card again select 'Required' from object property (see left top corner below new screen),
4. you will find default value for Required is 'False' change it as 'True'
5. Then select card un-select card you will find * Mark in the card.
If any problem persisting in this process let me know

Was this reply helpful? Yes No