Unanswered

How to get sharepoint list items between two date and export the items into excel ?

(0) Share

Report

Posted on by SKY05

Hi All,

I want to get the list items between two date and export those items into excel. It is working fine when I do not use filter condition. But when I use filter then data source is going as null in Power Automation flow.

Here is the code:

ClearCollect(colSPListItems,ShowColumns(Filter(ListName,

startDate.SelectedDate >= Created And endDate.SelectedDate <= Created),"Title","FirstName","LastName","Status"),
Set(varFileLink,ExportToExcel.Run(JSON(colSPListItems,JSONFormat.IgnoreBinaryData &JSONFormat.IgnoreUnsupportedTypes
)).filelink);Launch(varFileLink));

Thanks,

SKY

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @SKY05 ,

You have your Flow command inside the Clear Collect - also instead of the Collection, try this. NOTE: I have only addressed the structure and assumed the Flow and the input are correct

With( { wItems: ShowColumns( Filter( ListName, startDate.SelectedDate >= Created And endDate.SelectedDate <= Created ), "Title", "FirstName", "LastName", "Status" ) ) }, Set( varFileLink, ExportToExcel.Run( JSON( wItems, JSONFormat.IgnoreBinaryData & JSONFormat.IgnoreUnsupportedTypes ) ).filelink ) ); Launch(varFileLink);

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
SKY05 20 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much for your reply. But still collection is null in Power Automate flow.
Below code is working fine. Only when I add filter condition to retrieve items between two days then collection is null.
Working code:-
ClearCollect(colSPListItems,ShowColumns(ListName,"Title","FirstName","LastName","Status"));
Set(varFileLink,ExportToExcel.Run(JSON(colSPListItems,JSONFormat.IgnoreBinaryData&JSONFormat.IgnoreUnsupportedTypes)).filelink);Launch(varFileLink);
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Please help into this .. Code is working fine to export list items into excel. Only when I use filter condition to retrieve items between two date then collection is null in Power Automation flow.

Thanks,
SKY
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@SKY05 ,

The issue is your filter, not the Flow - if you do this in a gallery Items, do you get any records ?

Filter( ListName, startDate.SelectedDate >= Created And endDate.SelectedDate <= Created )