Power Platform Community Forum Thread Details

Hi, I have a table in Excel that records email events, part of that is a calculated week number field, called WkNo. I then have a scheduled task that produces a summary for the previous week.

This has been working great for over a year, I fixed the clash where the week numbers repeated about a 2 months ago 😉

However for week 46 it just doesn't work, it's fine for 45 and 47, and yes there are records for 46. The List rows just returns 0 records.

Then it gets weird. If i change the WkNo to 50 (for testing) it still doesn't find them. If I change some from 47 to 50, it DOES find the ex47 records but still not the ex46 ones. Put things back and try with 46 again and nothing is returned.

I'm guessing there's something up with the table, but I can't see it, the records all look complete.

Any ideas where I can go with tracking down this problem?

Categories:

Using connectors