web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps SQL table data nice la...

Power Apps

Answered

SQL table data nice layout

(0) Share

Report

Report

Posted on by rho1967

141

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

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

timl 36,932 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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 & " - ") )

Was this reply helpful? Yes No

Join the conversation