cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Y value calculation for Data Cards disappearing

Hi,

My app has a screen with about 70 datacards, some of which do not appear for certain users. To position the datacards, I calculate the Y value with a simple formula, but now that I am finished with creating the screen, I see that the formulas have been deleted. In their place is a simple number.

For example, one formula for DataCard 2's Y value might be:

DataCard1.Y + DataCard1.Height

Or DataCard3's Y value might be:

If(DataCard2.Visible = true,

DataCard2.Y + DataCard2.Height,

DataCard1.Y + DataCard1.Height

)

There were no errors in the formulas when I wrote them. But now the formulas have been replaced with a number, such as "400".

Any help would be greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

Try this:

If(DataCard2.Visible = true,

Value(DataCard2.Y) + Value(DataCard2.Height),

Value(DataCard1.Y) + Value(DataCard1.Height)

)

If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my User Group (pt-PT)!

Last Post on Community

My website!

2 REPLIES 2
Super User

Datacard Y values are a finicky thing... If you update anything, anything at all that might affect Y (such as any of their heights, or the forms height), then the values will revert back to static numbers.

What I would recommend instead is to increase the number of columns in your Form, then use the drag-and-drop interface for the datacards from the form field editor. Once they are in a 'good enough' visual order, I would then change the Width of the datacards depending on formulae.

So for example, if there's normally 3 cards on that row, and one needs to be hidden , then you make the Width values of the first two equal to

``````If(Datacard3.Visible,
Parent.Width/3,
Parent.Width/2
)``````

Width is less likely to (but still can be) reset by the form when things change.

 @iAm_ManCat My blog

 Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! Thanks! You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy Sancho Harker, MVP
Super User

Try this:

If(DataCard2.Visible = true,

Value(DataCard2.Y) + Value(DataCard2.Height),

Value(DataCard1.Y) + Value(DataCard1.Height)

)

If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my User Group (pt-PT)!

Last Post on Community

My website!

Announcements

#### December 2023 User Group Update: Welcoming New Groups and Upcoming Events

A new month means it's time to celebrate and welcome the new user groups that have joined our community. We are excited to announce that we have more than 8 New Groups, which is no surprise after the amazing Microsoft Power Platform Conference. This month, we are breaking them out by the different community categories. If your group is listed here, give this post a kudo so we can celebrate with you! Don't forget to take a look at the many events happening near you or virtually! It's a great time of year to connect and engage with User Groups both locally and online.   Please Welcome Our NEW User Groups   Power Platform: PowerIT User Group: Nottingham Power Platform User Group: Bergen Power Platform User Group: Danmark Nashville Power Platform User Group Microsoft Ambassador Program y Mujer Latina Technolochicas NCWIT Community Copilot Studio:  Copilot User Group Italia Dynamics365: Dynamics User Group AdriaticDynamic 365 Azerbaijan   December User Group Events   01 Dec 2023 Aprendiendo Desarrollo web, creando mi primer power app y power page. 01 Dec 2023 Q4 Hybrid Philadelphia Dynamics 365 & Power Platform User Group Meeting05 Dec 2023APAC Dynamics 365 FastTrack Bootcamp - BI and Analytics07 Dec 2023Bay Area Power Platform Meetup: Learn, Share, and Connect07 Dec 2023Indiana D365/AX December User Group Meeting07 Dec 2023Dynamics User Group Meeting: Houston09 Dec 2023 December '23 - NEW Power Apps User Group Meeting - Online 12 Dec 2023December Cleveland Power Platform User Group Meeting12 Dec 2023 RW2 Data Stewardship Open Forum Discussion 13 Dec 2023  Black Country Power Platform User Group - December 2023 - West Midlands