Unanswered

SharePoint Form Height

(0) Share

Report

Posted on by sudheervvs

I want to set SharePoint Form height to sum of all 'Visible' data cards' heights. Is this possible? I tried this, but it doesn't seem to work as expected. My form height is reduced significantly and loads with a scroll bar. I have set the form's height to something like the below formula.

Please note that some of my data card's visibility is dynamic based on certain conditions like another data card value or current logged in user etc.

Height:

Sum(

If(

'DataCard1'.Visible,

'DataCard1'.Height

If(

'DataCard2'.Visible,

'DataCard2'.Height

)

If(

'DataCard3'.Visible,

'DataCard3'.Height

)

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@sudheervvs
The SUM formula is not necessary here. It is meant for adding together values inside a collection. Instead, you can simply use the + operator.

If('DataCard1'.Visible,'DataCard1'.Height,0) +If('DataCard2'.Visible,'DataCard2'.Height,0) +If('DataCard13'.Visible,'DataCard3'.Height,0)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
sudheervvs 32 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney Tried this too, but the result is same.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@sudheervvs
OK, that's the only solution I can offer. It works for me... If you give a few screenshots though it might help. Be sure to include the left navigation menu in any screenshots.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
sudheervvs 32 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney Sorry I am unable to share screenshots here due to security restrictions. Can you please clarify if the form's height will be set first or the data card's visibility gets set first? I suspect it is something to do with the load sequence of form/data cards and hence some of the data cards might not have become visible at the time the form's height formula is being calculated.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@sudheervvs
Nope, sorry without screenshots I cannot help any further. I cannot visualize the problem you are having: it works for me so I need to see what is different.

You could always make another example that does not have private data and share.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."