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

#### Back to Basics Tuesday Tip #9: All About the Galleries

This is the ninth post in our series dedicated to helping the amazing members of our community--both new members and seasoned veterans--learn and grow in how to best engage in the community! Each Tuesday, we feature new content that will help you best understand the community--from ranking and badges to profile avatars, from Super Users to blogging in the community. Our hope is that this information will help each of our community members grow in their experience with Power Platform, with the community, and with each other!     Today's Tip: All About the Galleries Have you checked out the library of content in our galleries? Whether you're looking for the latest info on an upcoming event, a helpful webinar, or tips and tricks from some of our most experienced community members, our galleries are full of the latest and greatest video content for the Power Platform communities.   There are several different galleries in each community, but we recommend checking these out first:   Community Connections & How-To Videos Hosted by members of the Power Platform Community Engagement  Team and featuring community members from around the world, these helpful videos are a great way to "kick the tires" of Power Platform and find out more about your fellow community members! Check them out in Power Apps, Power Automate, Power Pages, and Copilot Studio!         Webinars & Video Gallery Each community has its own unique webinars and videos highlighting some of the great work being done across the Power Platform. Watch tutorials and demos by Microsoft staff, partners, and community gurus! Check them out: Power Apps Webinars & Video Gallery Power Automate Webinars & Video Gallery Power Pages Webinars & Video Gallery Copilot Studio Webinars & Video Gallery   Events Whether it's the excitement of the Microsoft Power Platform Conference, a local event near you, or one of the many other in-person and virtual connection opportunities around the world, this is the place to find out more about all the Power Platform-centered events. Power Apps Events Power Automate Events Power Pages Events Copilot Studio Events   Unique Galleries to Each Community Because each area of Power Platform has its own unique features and benefits, there are areas of the galleries dedicated specifically to videos about that product. Whether it's Power Apps samples from the community or the Power Automate Cookbook highlighting unique flows, the Bot Sharing Gallery in Copilot Studio or Front-End Code Samples in Power Pages, there's a gallery for you!   Check out each community's gallery today! Power Apps Gallery Power Automate Gallery Power Pages Gallery Copilot Studio Gallery

#### Visit the Community Lounge at Microsoft Ignite!

Are you attending Microsoft Ignite in Seattle this week? If so, we'd love to see you at the Community Lounge! Hosted by members of our Community team, it's a great place to connect, meet some Microsoft executives, and get a sticker or two. And if you're an MVP there are some special opportunities to meet up!     The Community Lounge is more than just a space—it's a hub of activity, collaboration, and camaraderie. So, dive in, explore, and make the most of your Microsoft Ignite experience by immersing yourself in the vibrant and dynamic community that awaits you.Find out the schedule and all the details here: Community Lounge at Ignite! See you at #MSIgnite!