Putting all records with the same date into one record that can be opened to individual sub-records

[Simon29]

hello friends,

I am new to PowerApps and I have one problem.

I have created such an application where several records with the same date are created. However, I would need to do such a thing that only one record with the date would be created and then it would be clicked and then individual sub-records would appear.

Could something like that be done please? If so, how please?

thank u 🙂 

[Devvj · Accepted solution]

Hi @Simon29 

If I understand correct you basicly want to have a list of dates, where you then choose one and get all the records created under that specific date?

Then you would need to add a new Gallery where you display just the dates, I dont know what datasource you use, but this example uses SharePoint.

In gallery1 use this code for the Items-property

Distinct(TestList, Text(Created, DateTimeFormat.ShortDate))

On the second gallery2 use this code

Filter(TestList, Text(Created,DateTimeFormat.ShortDate) = Gallery1.Selected.Value)

That way you get a list of dates, and upon select it shows the corresponding items with the same created date in gallery2

Hope that gives you an idea of a solution atleast, noted that the solution above dont work (well) on large datasets that are higher then the delegation limit.
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

 

[Simon29]

Maybe one more question.
What does it mean large datasets that are higher then the delegation limit? Whats the exact number or some value?

Thank u 🙂 

[Devvj]

Hi, 

Delegation limit means the total amount of items PowerApps can handle without delegate work to the external service.

So there is a chance you wont see your wanted items at all if there are more thrn 2000. 

The delegation limit is 2000 records/items, it can be changed under Settings in PowerApps.

I think the default value is set to 500, but you can increase that to maximum 2000.

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.