Power Platform Community Forum Thread Details

Update: I have found the issue already. Thanks for all that read

Hi all, i have a flow which retrieves from email messages. However, the last row is not being written. I will show snips of parts of my codes and i hope that you guys can help. Thanks

Firstly, this variable sets the different subfolders that the email gets read from. There are a total of 50 subfolders, and when being split, it will become a list of values from 0-49.

Secondly, this variable here sets the different keywords which are being read from the email messages. Similarly, there are a total of 50 keywords and when being split, it becomes a list of values from 0-49.

This variable is set to 0.

Next, a for loop is being used to loop through each of the subfolders from subfolders list.

Next, I will be showing a sample on how the email is being read. The Mail folder is based on the for loop. The subject is being retrieved from the list of keywords starting from the variable "CurrentVar" of 0 (set in the variable shown above). This variable will then increase by 1 after a folder is being read (see 2nd image below retrieving outlook messages).

After retrieving the email messages from the folder, it will go through a series of conditions and update it inside the excel with the status. However, this is the part where I am having an issue with. Even though there is just nice 50 rows, which is equivalent to the list of keywords and subfolder, 0-49, the last row does not seem to be writing it out. I have checked through the logs of the flow and it reads something but it just does not get written out here. Anybody knows why? Appreciate your help.