Hello all,
This is my first post here and It's been 2 months I am using Power Automate.My question is in my flow, I need to retrieve employees from the Employee list with filter query( substringof('30', MMHubEmployeeGroup) or substringof('31', MMHubEmployeeGroup) or substringof('32', MMHubEmployeeGroup) or substringof('33', MMHubEmployeeGroup) or substringof('34', MMHubEmployeeGroup) or substringof('35', MMHubEmployeeGroup)) and sites to follow from the list IntranetSites list where the the group number is between 30 to 35.Currently, I'm using 2 loops to process this information, but the flow is running into a timeout error due to the large number of records.What would be the best approach to handle this more efficiently.Thank you!