I'm struggeling with my Flow. I created a Forms document for my company to track the daily tasks from our employees. We track them from 15. to 15. of every month. Till now we track them with paper (everyone is writing their tasks on a paper and we collect them at the 16. every month). But we want to collect them now digital with my Forms document. But to make thing even easier for u I wanted to create a Flow which filters the entries from 15. to 15. and put them in a new Excel document and send it via Teams to me. And there is the problem. I tried to build a flow with Copilot and Chat GPT (they gave me nearly the same build). But the Flow isn't able to filter and create a new document. It's always failing. Maybe someone can help me with this or has a working example where I can build mine from. I took a screenshot from the Flow (it's in german)
One thing I see in your screenshot, the step "Tabellen abrufen" is "Get tables" action and this action only retrieves a list of table names and IDs in an Excel file. It does not retrieve the rows/data. That is why your "Filter array" had nothing to filter.
So replace "Tabellen abrufen" with "List Rows Present in a Table" action. In German something like "In Tabelle vorhandene Zeilen auflisten”.
Then after retrieving the rows, filtering by date can fail if the dates aren't handled correctly. Excel stores dates as serial numbers (count of days since Jan 1, 1900). Your Filter array likely compares dates, but one side is a string (e.g. “2025-10-15”) and the Excel date is a number (e.g. 44923). This leads to either a type mismatch or a wrong comparison.
Please show what you have entered in "Array filtern".
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
1,045
