When you read items from a SharePoint list and you want to filter by calculated fields in that list filter queries will fail. So how can you filter your items?
In SharePoint I’ve created a list with a calculated column. These calculations can become quite complicated and sometimes you might just want to create a flow that does the calculations for you.
There are however plenty of reason to create calculated columns. In my example I’m using the created column to calculate tomorrow.
Then as i create items in my list I see that Tomorrow has been set to tomorrow’s date.
When you use the experimental filter query option you will see that the calculated columns aren’t listed in the drop down and also when you use the GA version of the same things will not be much better
When you configure the query with add a custom item in the above action, then you will see the following error when you run the flow:
The field ‘Tomorrow’ of type ‘Calculated’ cannot be used in the query filter expression.
So that means that we can’t filter the items during the get items action and we will need an additional filter action added to our flow.
Condition Left: formatDateTime(item()?[‘Tomorrow’], ‘d’)
Condition right: formatDateTime(AddDays(utcNow(), 1), ‘d’)
When we run the flow with this additional fitler action, the flow is successful and we managed to filter by calculated fields in SharePoint.
In Power Apps you can use data sources directly or you could use collections or…
For quite a while I've been looking to set the task priority in Microsoft Planner…
When you create apps, you might find that different users get different things to do.…