Unanswered

Enabling a button when all the required fields are filled

(0) Share

Report

Posted on by ZeroEight

Hello Everyone ! I have a canvas app where I have kept some fields as required or mandatory and some fields are not mandatory. As per the requirement there is a finish button which needs to be enabled when all the required fields are filled.
I am using this function but no luck :
If(
IsEmpty(
Filter(
colRequiredInTransportSet,
IsBlank(QR_Code) || IsBlank(SAP_Mat_No) || IsBlank(Item_SN) || IsBlank(Manufacturer_Short)
)
),
DisplayMode.Edit,
DisplayMode.Disabled
)

In this colRequiredInTransportSet I have this info :
ClearCollect(
colRequiredInTransportSet,
Filter(
'Log.t_Transport_Set',
Required = true
)
);
Any and every help is appreciated. Thanks !!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (1)

cha_cha 4,932 Moderator on at

Like (0)

Report
Hello @ZeroEight

You can modify your formula to use the CountRows and Filter functions together to check if all required fields are filled:

If( CountRows( Filter( colRequiredInTransportSet, IsBlank(QR_Code) Or IsBlank(SAP_Mat_No) Or IsBlank(Item_SN) Or IsBlank(Manufacturer_Short) ) ) = 0, DisplayMode.Edit, DisplayMode.Disabled )

This formula will count the number of records in the colRequiredInTransportSet collection that have at least one blank field. If the count is zero, then all required fields are filled, and the finish button will be enabled. Otherwise, the button will be disabled.

I hope this helps! Let me know if you have any further questions.

Was this reply helpful? Yes No
ZeroEight 38 on at

Like (0)

Report

Hi @cha_cha - Still no luck , I have applied this function on display mode.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report
Hello @ZeroEight

Maybe start with a Label first and add this code to its Text property. Let's see if it's counting properly.

CountRows( Filter( colRequiredInTransportSet, IsBlank(QR_Code) Or IsBlank(SAP_Mat_No) Or IsBlank(Item_SN) Or IsBlank(Manufacturer_Short) ) )

Can you please confirm what type of controls the following are as we maybe using a wrong function to check the its content:

QR_Code

SAP_Mat_No

Item_SN

Manufacturer_Short

Was this reply helpful? Yes No
ZeroEight 38 on at

Like (0)

Report
Hi @cha_cha :
Can you please confirm what type of controls the following are as we maybe using a wrong function to check the its content:
QR_Code : Text
SAP_Mat_No : Text
Item_SN : Text
Manufacturer_Short : Text

When I applied this in the text property it is counting as 31 rows. I have attached the screenshot.

CaCapture.PNG

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

Hi @ZeroEight

We are unto something but will need to figure it out step by step as I don't have access to your dev environment directly.

Can you please confirm that in the picture below, I am pointing a gallery control and it is possible that this gallery will show multiple rows of data?

Also, please send screenshot of the button that you intend to show/hide when the required fields are filled or not.

Was this reply helpful? Yes No
ZeroEight 38 on at

Like (0)

Report

Hi @cha_cha : I thank you very much for your time and effort to help me into this. Below are the details :

Can you please confirm that in the picture below, I am pointing a gallery control and it is possible that this gallery will show multiple rows of data? Yes , I have attached the other screen shot.

ca2Capture.PNG

Was this reply helpful? Yes No
ZeroEight 38 on at

Like (0)

Report

The button which needs to be enabled is FINISH COMPONENT button. All the frames in red are required/mandatory field. After the successful entry in those red highlighted frames. Finish component needs to be enabled.

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

Hello @ZeroEight

Additional question, I am presuming that the ones I'm pointing with Red Arrow are the ones required. and the ones black are left empty, am I correct?

Presumably that we figure out how to Enable/Disable the button, may I know how do you intend to update the data? What happens when that button is clicked? I'm asking this cause I have a workaround for your requirement about the button but this might break the code that you have for your Finish component button.

Was this reply helpful? Yes No
ZeroEight 38 on at

Like (0)

Report

Hi @cha_cha : As if now on the finish component button we have not applied any code. As per the functionality wise once all the required fields are populated/filled the finish component should enable. Once enabled we just need to patch status of the record from In progress to done. Hence once all the required values are filled we just need to update the status of that record to a table.

Was this reply helpful? Yes No
ZeroEight 38 on at

Like (0)

Report

One more info to be clear , As per the above screenshot which you highlighted the red frames till that point we are updating patching the data. hence we dont have to do much on finish component button. Just to update the status we need that button.

Was this reply helpful? Yes No