Hi
I made
a post a few weeks ago and was advised that Get Items is what I needed to fix the issues I'm having (having to update emails in multiple forms if there's a change of department head). I have been trying to make this work since and have not managed to get it to do what I need. I've read a lot of help pages and how to guides but none of them have actually helped.
What I want to happen is when a department is picked on the form, the flow in power automate picks the relevant budget holder from a list to send an approval email to.
I've created a two column list that has 81 rows in it (including headers). The columns are titled "Department" and "Email". The contents of the Department column is set up in the exact same way as the list of departments in my forms so should be an exact match. Each department is named differently. The list is on sharepoint and I can pull it into Get Items fine. In the flow it lets me add the Email column from the Get Items stage. When I try to run a test it fails instantly due to a Bad Request at the Get Items stage.
I've tried using different filters based on what I've read but the result is always the same. My list is just called Test currently.
substringof('Test',Email) - Error "Column 'Email' does not exist."
Department eq 'Test' - Error "Column 'Department' does not exist."
substringof(Department,'Test') - Error "The function operator 'substringof' is not supported or its usage is invalid."
I'm not sure what I need to put in the Filter Query to get this working. The list is not a large dataset and, from what I've read, most of the filter options appear to be about reducing the amount of data is looked at. I need it to look at the full list as any of the departments could be entered on the form.
Am I even anywhere close to the right track with the filter queries I've used above? I'm completely stuck.
