cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rho1967
Helper III
Helper III

SQL table data nice layout

Hi,

I have a Table with the names


Name
Date

 

It looks like this

Name     Date

test        12/12/2021
test        13/12/2021
test        14/12/2021
test        15/12/2021


test2       01/01/2021
test2       02/02/2021
test2       03/03/2021
test2       03/03/2021

 

How do I get it shown as

test 12/12/2021 - 13/12/2021 - 14/12/2021 - 15/12/201
test2 01/01/2021 - 02/02/2021 - 03/03/2021 - 03/03/2021

 

Hope someone can help

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

Hi @rho1967 

You can do this by grouping the data by "name",  and concatenating the date values like so:

AddColumns(GroupBy(sqlTable,"Name","DateDetails"),
           "DateValues", 
            Concat(ThisRecord.DateDetails, Date & " - ")
)

 

timl_0-1639090329677.png

 

 

View solution in original post

1 REPLY 1
timl
Super User
Super User

Hi @rho1967 

You can do this by grouping the data by "name",  and concatenating the date values like so:

AddColumns(GroupBy(sqlTable,"Name","DateDetails"),
           "DateValues", 
            Concat(ThisRecord.DateDetails, Date & " - ")
)

 

timl_0-1639090329677.png

 

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,620)