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")))
Solved! Go to Solution.
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.
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")))
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.
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")))
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!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
164 | |
94 | |
64 | |
63 | |
61 |
User | Count |
---|---|
236 | |
162 | |
95 | |
83 | |
81 |