cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AJ_08
Frequent Visitor

No Data in Excel Target, but Flow Run Was Successful

I'm building a recurring flow to copy Excel rows to a different workbook every two weeks, then delete it. I've removed the delete for now because although the flow runs successfully, there is no data in the target Excel workbook. The filter is based on the column Order_Date. I'm testing with data from 12 days ago, just to pull the more recent old data from the test files. There should be 24 rows added to the target workbook.

 

I've tried the Filter Query in the List Rows action and Filter Array (separate and together) with no luck. If I run with the Filter Query only, there are a variety of errors.  Any recommendations to actually get the data to the target are welcome!

 

Recurring_List Rows.pngFilter Array_Add Row.png

6 REPLIES 6
abm
Super User
Super User

Hi @AJ_08 

 

Please watch my tutorial video regarding how to filter excel date columns.

 

https://www.youtube.com/watch?v=r1LhHU5lXkM

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
AJ_08
Frequent Visitor

I watched your video and noticed the filter date is fixed. My filter date will always very, based on today's date. That's why I'm using getPastTime. I tried addDays with a negative integer with no luck, I just need help to identify why no data is in the target sheet, but it's showing as successful.

Hi @AJ_08 

 

Yes that will give you the idea how to filter. So what you need to do is find your filter day based on today date in a compose action step. Then pass that in next action step. In my case I don't need to work out and hardcoded that value. That's all the difference is.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Hi @AJ_08 

 

Please follow the below steps.

 

image.png

 

Above the expression are as follows:

 

getPastTime(12,'Day','dd/MM/yyyy')
 
addDays('1899-12-30', int(item()?['DateOfBirth']), 'dd/MM/yyyy')
 
If you need further help please let me know.


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials
AJ_08
Frequent Visitor

Thanks @abm, I'll give this a shot and let you know. 

AJ_08
Frequent Visitor

Thanks again @abm! Watching the video again with this makes sense now. Power Automate is seeing the date in the correct format - finally. Still, no data is being added despite there being about 20 rows of content. I'm using Add a Row as the next action, instead of Update a row, as there's no data in the target sheet. While there are several inputs, there are no outputs with the Order Date of 2/25/2021

 

Compose getPastTime(13,'Day','MM/dd/yyyy')

 

Filter Array addDays('1899-12-30',int(item()?['Order_Date']),'MM/dd/yyyy') is equal to Outputs variable

(also tried 12-30-1899)

 

Any resources you recommend? Google and search haven't produced any leads to read or watch.

 

Compose.pngNo Outputs in Array.png

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,065)