
Hi
I am building a power app flow from the Microsoft form submissions, automatically adding a new table to the Event Calendar. The caveat is that when I add a new row to the table, there are two tables in Excel, one for 2023 and 2024. I want to create some kind of condition like if someone fills the event form for events happening in 2023, it triggers fields in 2023 else in 2024.
You can use a switch based on the year with one for 2023 and one for 2024. Then in the switch point your Add a row into a table action to the correct table for each switch. For the default in the switch you could send yourself an e-mail, which would indicate someone submitted something that was for neither 2023 or 2024 and you need to update your flow to accommodate this condition.