cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SteveWWHA
Frequent Visitor

Dataverse Table/Rows and Date

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @SteveWWHA ,

 

You need use hard code.

vxiaochenmsft_0-1629772037994.png

Dropdown onchange:

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

vxiaochenmsft_1-1629772053241.png

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'))

 

vxiaochenmsft_2-1629772096140.png

 

Best Regards,

Wearsky

 

 

View solution in original post

1 REPLY 1
v-xiaochen-msft
Community Support
Community Support

Hi @SteveWWHA ,

 

You need use hard code.

vxiaochenmsft_0-1629772037994.png

Dropdown onchange:

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

vxiaochenmsft_1-1629772053241.png

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'))

 

vxiaochenmsft_2-1629772096140.png

 

Best Regards,

Wearsky

 

 

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (2,729)