Canvas App - Datatable display today date

(0) Share

Report

Posted on by AVTS

538

I am having follwing datatable display in the canvas app .

Table name : Managerview

Requirement1:

I wanted to display records which is created on today date only.

Requirement 2:

I wanted to display the yesterday qty for same MaterialNo also.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Sid_Jafri 478 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AVTS ,

You can achieve first requirement through this
Filter(datasource, Text('Created On',ShortDate) = Text(Today(), ShortDate))

Regarding second requirement, you need the quantity of yesterday for same material as column or want to bring the previous day record of same material as a row?

Please Thumbs up if my post helped you solve your issue.

Was this reply helpful? Yes No
AVTS 538 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your quick support.
I am evaluating for both below,
1,quantity of yesterday for same material as column
2,want to bring the previous day record of same material as a row

Was this reply helpful? Yes No
Sid_Jafri 478 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AVTS ,

This how you can add as a row
ClearCollect(colMaterial, Filter(Datasource, Text(Created, ShortDate) = Text(Today(), ShortDate)));
ClearCollect(colMaterialPrevious, Filter(Datasource, Text(Created, ShortDate) = Text(DateAdd(Today(),-1), ShortDate) && mno in colMaterial.mno));
ClearCollect(colMaterialMerge, colMaterial, colMaterialPrevious)

use the colMaterialMerge as source for your gallery

Below for Add as column
ClearCollect(colMaterial, Filter(Test, Text(Created, ShortDate) = Text(Today(), ShortDate)));
ClearCollect(colMaterial,AddColumns(Filter(datasource, Text(Created, ShortDate) = Text(DateAdd(Today(),-1), ShortDate) && mno in colMaterial.mno),"Previous mno", mno));
User the colMaterial for your gallery

Please Thumbs up if my post helped you solve your issue.

Was this reply helpful? Yes No
Sid_Jafri 478 on at

Like
a
(0)

Report
Copy link

Link copied!

@AVTS

Please let me know if that works, please mark this resolved so others can benefit

Was this reply helpful? Yes No