Answered

Show or Hide datacards based on a number entered into a text field.

(0) Share

Report

Posted on by golfnutt82

1,362

Hello,
I have this situation and would like to know if this is possible in Power Apps.

I am setting a variable (varShow) when the fields change property is set to a number between 1 and 6

If(DataCardValue62.Text = "1", Set(varShow,true)); If(DataCardValue62.Text = "2", Set(varShow,true)); If(DataCardValue62.Text = "3", Set(varShow,true)); If(DataCardValue62.Text = "4", Set(varShow,true)); If(DataCardValue62.Text = "5", Set(varShow,true)); If(DataCardValue62.Text = "6", Set(varShow,true));

For each field in the top row I set the visible property as follows.
If(DataCardValue62.Text="",false,If(DataCardValue.Text = "1",varShow))
The visible property for the next row would be the same if "2" is entered and so on.

Number of Obligations	1 - 6
Obligor Number 1	Obligation Number 1	New Maturity 1
Obligor Number 2	Obligation Number 2	New Maturity 2
Obligor Number 3	Obligation Number 3	New Maturity 3
Obligor Number 4	Obligation Number 4	New Maturity 4
Obligor Number 5	Obligation Number 5	New Maturity 5
Obligor Number 6	Obligation Number 6	New Maturity 6

Depending on the number of obligations show that number of rows.
So, if 1 is entered, show only the top row; if 2 is entered, show the first and second rows; if 3 is entered, show the third row, and so on.
How can I make this happen in my power app.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Nandit 1,568 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi golfnutt82,

You have not mentioned the control you are using to display these rows. Are you using a Form?

Assuming your fields are connected to SharePoint columns.

You can set a variable on the OnChange Property.

I am using a Classic Text Input Control with Format set to Number:

Set(varRowsNum, Self.Text)

In your Form,

On the first set of fields, use the following code in the Visible property:

(Value(varRowsNum) = 1 || Value(varRowsNum) < 6) && !IsBlank(varRowsNum) && !(Value(varRowsNum) = 0)

On the second set of fields, Visbile propery would be:

(Value(varRowsNum) = 2 || Value(varRowsNum) < 6) && !IsBlank(varRowsNum) && !(Value(varRowsNum) = 0 ||Value(varRowsNum) = 1)

This is how it will look:

If you are not using a form, you have the above table stored somewhere and you just want to display data based on the number entered in the Text Input.

I have created a collection to mimic your data.

Add a gallery to the screen with the following in the Items:

FirstN(DataSource, varRowsNum)

This is how it will look:

Do share if you are using something else. more than happy to assist.

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
golfnutt82 1,362 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello Nandit,
Thank you for your reply.

so, for each datacard in the row I only have to change (Value(varRowsNum) = 1 or 2 or 3 or 4 to display the next row that matches the variable?

#3
(Value(varRowsNum) = 3 || Value(varRowsNum) < 6) && !IsBlank(varRowsNum) && !(Value(varRowsNum) = 0 ||Value(varRowsNum) = 1) #4 (Value(varRowsNum) = 4 || Value(varRowsNum) < 6) && !IsBlank(varRowsNum) && !(Value(varRowsNum) = 0 ||Value(varRowsNum) = 1)

Was this reply helpful? Yes No
Verified answer

golfnutt82 1,362 on at

Like
a
(1)

Report
Copy link

Link copied!

Ok, I was able to figure this out.

I used the variable varRowsNum in the OnChange event for the datacard.

If "1" is chosen from the Number of Obligations
If(varRowsNum = "1",true) && varTabSelected=6 || If(varRowsNum = "2",true) || If(varRowsNum = "3",true) || If(varRowsNum = "4",true) || If(varRowsNum = "5",true) || If(varRowsNum = "6",true) && varTabSelected=6

If "2"
If(varRowsNum = "2",true) || If(varRowsNum = "3",true) || If(varRowsNum = "4",true) || If(varRowsNum = "5",true) || If(varRowsNum = "6",true) && varTabSelected=6

If "3"

If(varRowsNum = "3",true) || If(varRowsNum = "4",true) || If(varRowsNum = "5",true) || If(varRowsNum = "6",true) && varTabSelected=6

If "4"

If(varRowsNum = "4",true) || If(varRowsNum = "5",true) || If(varRowsNum = "6",true) && varTabSelected=6

If "5"

If(varRowsNum = "5",true) || If(varRowsNum = "6",true) && varTabSelected=6

If "6"

If(varRowsNum = "6",true) && varTabSelected=6

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,992 Super User 2025 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

// General formula for showing or hiding datacards
If(
Value(varRowsNum) >= ThisItem.Number && varTabSelected = 6,
true,
false
)

Was this reply helpful? Yes No