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
Solved! Go to 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
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
User | Count |
---|---|
24 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
26 | |
10 | |
9 | |
8 | |
7 |