I have a SharePoint list with Code, Period and Status. I want my flow to create items in my SharePoint List with different codes. Flow will be triggered every month inserting multiple Codes with current date into the Period column. For the Period Column I have an expression:
formatDateTime(utcNow(), 'yyyy-MM')
Everything works fine, but for each code i have separately step (So like 40 steps). I want an expression that will include every Code (I prefer to enter them manually). How to do it? - every month tere will be the same set of Codes.
Also every month when the flow is created I want to send an Email to a few Users that Data has been added to Sharepoint list, but not separately for each item - only one Email in month