Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Display * instead of the same column's value in consecutive data rows

(0) ShareShare
ReportReport
Posted on by

hi all,

instead of displaying the same value 3 times if a sorted gallery has 3 rows I would like to display only the first row's column value and all consecutive rows with *

Is that possible?

thx

 

  • candide Profile Picture
    candide on at
    Re: Display * instead of the same column's value in consecutive data rows

    @v-xiaochen-msft 

    well it's been a while when I posted this question, now there's some time to answer to your suggestion.

    I got several errors using your technique. Maybe there's a slight difference as I'm not using a sharepoint list but a dataverse table. I set up a demo like this:

     

    The control to adapt has a text property

     

    ThisItem.Title

     

    candide_0-1711208979453.png

     

    the gallery has an Items property

     

    Col

     

     

    candide_1-1711209086298.png

     

    and the Screen02 has a OnVisible property

     

    Clear(Col);ForAll(ShowColumns(tblTest02,"tstSymptome"),If(Title2 in Col.Title,Collect(Col,{Title:"*"}),Collect(Col,{Title2:Title2})))

     

     

    candide_2-1711209285536.png

     

    I varied some values in this last case but no success.

    Still errors

    • ShowColumns(tblTest02,"tstSymptome")
      candide_3-1711209420495.png

      but the table has these columns:

      candide_4-1711209516287.png

      and I'm not sure with the Title property and the gallery control Title2.

      More ideas?

     

  • Re: Display * instead of the same column's value in consecutive data rows

    Hi @candide ,

     

    Please try to create a collection.

    vxiaochenmsft_0-1702955541543.png

    vxiaochenmsft_1-1702955553936.png

    Clear(Col);ForAll(ShowColumns(LIST46,"Title"),If(Title in Col.Title,Collect(Col,{Title:"*"}),Collect(Col,{Title:Title})))
    vxiaochenmsft_2-1702955579259.png

     

    vxiaochenmsft_3-1702955589141.png

     

    Best Regards,

    Wearsky

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard