I have been trying to develop a flow and hitting an issue. I will list out the steps I would ideally like to accomplish.
I have a SharePoint library with a "category" field. For some categories, when a file is uploaded, it needs to send an email per file an hour after it is uploaded. For the other categories, I need it to send a consolidated email 3x a day (9am, 1pm, 5pm). I have a couple of columns of data that are in the html table that comes out the 3x a day.
Here is the part that I am stuck on: I need to be able to track view counts to the files... I originally was using the file link "dynamic content", but it doesn't track views in SharePoint as it opens the file directly and not through a share link within SharePoint. My workaround was going to be to have a switch condition to provide a link to the views I have set up per category. I can't get the workflow of swapping a dynamic variable to work out to provide the link for each file row based on its category. The best I have been able to do is get it to stack each category being compiled for the table's link column in each column.
I can provide screenshots or whatever other information you are needing. I have to get this completed ASAP for my bosses.