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.
Three Super User rank tiers have been launched!
Features releasing from October 2020 through March 2021
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!