Hello!
I have a script implemented to add a new worksheet and table to my workbook at the beginning of every month. With this new table every month, I'm trying to have a flow run whenever it is modified. The name of the new monthly table is formatted as 'MMM_yyyy' so for example "Oct_2021" is the current table. How do I make a flow that only triggers based upon the sheet/table belonging to the current month?
To elaborate, this would be something along the lines of using 2 "compose" actions with the following expressions respectively: "formatDateTime(utcNow(),'MMM')" & "formatDateTime(utcNow(),'yyyy')" and combining the outputs of the 2 expressions with an underscore between them to ensure we are always checking the current month's table for modifications to trigger the flow.
In essence, I'm trying to add dynamic content to a trigger. Is this possible? Sorry if this is hard to understand, I am bad at explanations. Thanks in advance for any guidance you can provide!
