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
Most Valuable Professional

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

#### Copilot Cookbook Challenge | WINNERS ANNOUNCED | Win Tickets to the Power Platform Conference

We are excited to announce the "The Copilot Cookbook Community Challenge random winners have been selected for the Challenge.  Thank you to everyone who participated in this challenge.    Copilot Cookbook Gallery:Power Apps Cookbook Gallery: 1. @swaminawale  1. @renatoromao     2.  @SpongYe  2.   @nickpotts10  *Please note if for any reason a winner declines, we will have another random drawing.   Check out all of the Cookbook Submissions: 1. Copilot Studio Cookbook Gallery: https://aka.ms/CS_Copilot_Cookbook_Challenge 2. Power Apps Copilot Cookbook Gallery: https://aka.ms/PA_Copilot_Cookbook_Challenge   There will be 5 chances to qualify for the final drawing: Early Bird Entries: March 1 - June 2Week 1: June 3 - June 9Week 2: June 10 - June 16Week 3: June 17 - June 23Week 4: June 24 - June 30WINNERS ANNOUNCED - JULY 8th     At the end of each week, we will draw 5 random names from every user who has posted a qualifying Copilot Studio template, sample or demo in the Copilot Studio Cookbook or a qualifying Power Apps Copilot sample or demo in the Power Apps Copilot Cookbook. Users who are not drawn in a given week will be added to the pool for the next week. Users can qualify more than once, but no more than once per week. Four winners will be drawn at random from the total qualifying entrants. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once. If they are drawn multiple times, another user will be drawn at random. Prizes:  One Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 (\$1800 value, does not include travel, lodging, or any other expenses) Winners are also eligible to do a 10-minute presentation of their demo or solution in a community solutions showcase at the event. To qualify for the drawing, templates, samples or demos must be related to Copilot Studio or a Copilot feature of Power Apps, Power Automate, or Power Pages, and must demonstrate or solve a complete unique and useful business or technical problem. Power Automate and Power Pagers posts should be added to the Power Apps Cookbook. Final determination of qualifying entries is at the sole discretion of Microsoft. Weekly updates and the Final random winners will be posted in the News & Announcements section in the communities on July 29th, 2024. Did you submit entries early?  Early Bird Entries March 1 - June 2:  If you posted something in the "early bird" time frame complete this form: https://aka.ms/Copilot_Challenge_EarlyBirds if you would like to be entered in the challenge. Early Bird Submissions: @renato Week 1 Results:  Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1.  @Mathieu_Paris 1.   @SpongYe 2.  n/a2.   @Deenuji 3.  n/a3.   @Nived_Nambiar  4.  n/a4.   @ManishSolanki 5.  n/a5.    n/a   Week 2 Results:  Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1. Kasun_Pathirana1. ManishSolanki2. cloudatica2. madlad3. n/a3. SpongYe4. n/a4. n/a5. n/a5. n/a     Week 3 Results:  Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1. Parul_Yadav_Neo1. n/a2. SpongYe2. n/a3. n/a3. n/a4. n/a4. n/a5. n/a5. n/a   Week 4 Results:  Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Copilot Cookbook Gallery:Power Apps Cookbook Gallery:1. @nickpotts10  1. @ShrushtiShah  2. @Suniti_0020 2. @swaminawale 3. n/a3. @farukhis786 4. n/a4. @ManishSolanki  5. n/a5.  n/a