Hi everyone! im having a really curious issue retrieveng information froma google sheets file, its a list of movies by projection date, when there is more than one movie in the same date it retrieves information without issues, but when there is only one registry for especific date it hangs with error 408, checked format, checked formulas and filters and it only happens when the registry for that date is unique. Help please! added example file.
If you create a table with many dates repeating for the movies and one date having only one movie, the flow will search for all cells for that date and break with timeout
in my example if y ask to search by date and select de 23 (a day with only one registry) when i go and ask google sheets to get data filtering by date, it hangs
so for it to be easy to test im adding the google sheet as csv and the basic flow used, if you try to search on the 23rd or 29th of january that only has one movie it hangs maybe this will be easier to identify with this test, for all the other days that have more than one movie it will list the movies
Ok so since it gets only 1 row, it doesn't add it to a list variable but it will be simply a string variable. Then the Shift set variables are not working as expected.