I have two Sharepoint lists:
LAB01 which houses records submitted by users, and
Technical Spaces which is a 'dashboard' of information for management oversight.
What I want to do is create a flow which checks daily whether a LAB01 form ReviewDates is today, and if so, change the 'LAB01' column on the Technical Spaces dashboard to 'Requires Review' before sending an email out to the creator of the record, but it seems that this sounds a lot easier than it is in practice!
I have a Get Items which is OData Filter Queried to only return items from LAB01 where the ReviewDates column = today - this is working no problem.
When I tried to create a similar OData Filter Query on the Get Items for Technical Spaces I have hit a couple of problems:
- I originally wanted to filter the TechSpaces list by whether 'LAB01' = 'Complete' but because LAB01 is a Choice column this wouldn't work.
- I tried leaving the filter blank and using a Condition to check if they Building and Room Number are the same, and if so update the LAB01 column
(I have tried to highlight which dynamic content refers to which list because they're all named the same.)
Although this said that it succeeded, it returned 'False' as the condition, despite there definitely being one record with the Building and Room Number the same
I then tried creating the Condition in the OData Filter instead, but then it puts it in an apply to each which means I can't refer to the dynamic content of the items which are returned
Am I over complicating this? Does anyone have a solution for me?
Any input is much appreciated!
