Hi
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
Sends Email
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.
Any ideas?
thanks
Eric
Solved! Go to Solution.
Hi @Eric3,
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.
Image reference:
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.
Best regards,
Kris
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
13 | |
7 | |
4 | |
4 | |
4 |
User | Count |
---|---|
11 | |
8 | |
6 | |
5 | |
4 |