Canvas App - Send Data

[AVTS]

Hi , I have developed canvas app which incldes flows for email send with csv attachement.

With below code i am getting email attachement in which  all data from tables are appearing.

Test1.Run(User().Email,JSON(ShowColumns(Dailyinventory,"crf99_materialdesc","crf99_materialno","createdon","crf99_bbd","crf99_qty")))

What i need is data posted on today date,

Following code i tried but i am getting error.

Test1.Run(User().Email,JSON(ShowColumns(Dailyinventory,Text("createdon",DateTimeFormat.LongDate)=Text(Today(),LongDate)) ,"crf99_materialdesc","crf99_materialno","crf99_bbd","crf99_qty")))

[RandyHayes · Accepted solution]

@AVTS 

Please consider changing your Formula to the following:

Test1.Run(User().Email,
  JSON(
    ShowColumns(
        Filter(Dailyinventory, IsToday(createdon)), 
        "crf99_materialdesc", "crf99_materialno", "crf99_bbd", "crf99_qty"
    )
  )
)

I hope this is helpful for you.

[AVTS · Accepted solution]

Thanks somewhere it took me for final solution .

Test1.Run(User().Email,JSON(ShowColumns(Filter(Dailyinventory,Text('Created On',DateTimeFormat.LongDate)=Text(Today(),LongDate)),"crf99_materialdesc","crf99_materialno","crf99_bbd","crf99_qty")))

[RandyHayes]

@AVTS 

All fine, but you don't need to convert dates to text to compare and it will not be delegable.  So just keep that in mind.

Glad you got what you needed!