I have a flow that
Get Items from a sharepoint list,
Filter Arrays that list to the records created in the last 7 days,
Selects the items I want (Date, Project Name, Current Activity)
Creates HTML table
It's been working fine until this week. Now it won't recognise any records created after a certain date, which coincides with 90 days after I created the Sharepoint, the Flows and the PowerApps.
I don't think I have a licence problem, because other test flows doing the same thing from different lists seem to work fine.
Solved! Go to Solution.
Could you please share a screenshot of your flow's configuration?
Further, could you please show a bit more about your SharePoint list?
I have made a test on my side and don't have the issue that you mentioned. My flow's configuration as below:
@greaterOrEquals(formatDateTime(item()?['Created'], 'MM/dd/yyyy'), formatDateTime(addDays(utcNow(), -7), 'MM/dd/yyyy'))Add a "Select" action, From set to output of "Filter array" action, within Map entry, type the following entries:
Note: within value box, type the following formula:
item()?['ColumnName']Add a "Create HTML table" action, From set to output of "Select" action.
The flow works successfully as below:
Please check if there is something wrong with your formula within your "Filter array" action. In addition, you could consider take a try to re-create your flow to check if the issue is solved.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Many congratulations to the Season 1 2021 Flownaut Crew!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
Check out the community blog page where you can find valuable learning material from community and product team members!