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.