Dataverse Table/Rows and Date

[SteveWWHA]

Hi All

I'm wondering if its possible to create an app that will give me the following information: - 

Dataverse Table Name

Number of Rows in Table

Oldest and Newest Date in Table

Essentially, i am currently migrating data from an on prem  SQL DB into a PowerApps dataverse and trying to sort of match up what i have done as best i can. What i'm trying to understand is if i can: - 

Connect to the Dataverse

Have a drop down to select the table

Hit a button which will give me the oldest/newest date and number of rows

Any help would be appreciated

Thanks

[v-xiaochen-msft · Accepted solution]

Hi @SteveWWHA ,

You need use hard code.

Dropdown onchange:

Set(Count,Blank());Set(First,Blank());Set(Last,Blank())

Button onselect :

If(Dropdown1.Selected.Value="TestL9",Set(Count,CountA(TestL9.'Created On'));Set(First,First(TestL9).'Created On');Set(Last,Last(TestL9).'Created On'),Dropdown1.Selected.Value="TestL10",Set(Count,CountA(TestL10.'Created On'));Set(First,First(TestL10).'Created On');Set(Last,Last(TestL10).'Created On'))

Best Regards,

Wearsky