Hello,
I'm struggling getting something to work correctly and I'd like to find a solution with you.
I have a flow which gets folders within a document library to check whether users have uploaded the right document or not. Each folder has its own user and they all need to upload a file and enter a category value (which is a choice column in the library). If they haven't uploaded the correct file at a certain time of the month, they get a reminder email.
As you will see from the screen capture, I have an apply to each for folders that sends an HTTP request to SP to get the number of files for each folder, so I know if they have uploaded at least one file. If they haven't they get a notification, and if they have, I then have another apply to each for files that gets the category value for each file, combine all those values together and I then have a condition to check whether the correct value is there or not and a notification is sent.
The problem I have is that when I combine all strings, the function doesn't take into account the apply to each folder in which it is. It simply combines ALL strings, whatever the folder. So obivously the rest of the flow is not correct.
Is there a way to combine strings from within an apply to each or is there maybe another way to build this flow? FYI, I combine strings so users get only one notification even if they uploaded multiple files because I only need to check if at least one file has the correct category.
Many thanks.
