Answered

Create collection from another collection with some calculation

(1) Share

Report

Posted on by shrikantswnt

118

I have a collection with the name "collForGraphVMS" with the below mentioned columns Title, From, To and Auther. This is regarding users who will visit From date to To date daily.

I need a new collection with the below output. i.e. Total number of people visiting on a date

Date	Count
2/23/2025	3
2/24/2025	3
2/25/2025	4
2/26/2025	3
2/27/2025	3
2/28/2025	3
3/1/2025	3
3/2/2025	3
3/3/2025	3
3/4/2025	0

Please sugger some ForAll loop or any other way.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Suggested answer

Schjoermann 18 on at

Like (0)

Report
Copy link

Link copied!

Hi Shrikantswnt,

Try the following clearcollect to achieve what you are looking for.

That should give you a result looking like the attached.

If this answers your request, please mark the answer as a verified answer.

ClearCollect(

colCountGroupedData,

AddColumns(

GroupBy(

colForGraphVMS,

Date,

Grouped //this is the groupname

),

Count,

CountRows(Grouped)

)

)

Was this reply helpful? Yes No
Verified answer

shrikantswnt 118 on at

Like (0)

Report
Copy link

Link copied!

@Schjoermann Thanks for the reply. I did some changes and got the result. please check my below code :

//For Graph

ClearCollect(collFilterForGraph,Blank());

ForAll(

Sequence(DateDiff(DateAdd(Today(),-1), DateAdd(Today(),29), TimeUnit.Days)),

Collect(collFilterForGraph,

{

date : Text(DateValue(DateAdd(Today(),Value)),"dd-mmm"),

UserCount: CountRows(Filter(collVMS,

(DateValue(DateAdd(Today(),Value)) >= DateValue(ThisRecord.ExpDateTime)) && (DateValue(DateAdd(Today(),Value)) <= DateValue(ThisRecord.To))

)

)

}

)

);

Was this reply helpful? Yes No