Power Automate
Budget: £10 – £20 GBP
I have created a simple form with the following:
Name:
Country: Option to select 5 countries
Also, I have an excel file with 5 tabs, each tab with a table using the name of the country and inside I have a column “Code” with 500 rows with unique numbers, and an empty column called Requested by:
Every time someone submits the form, I need to update the file with the name of the person submitting the form and according to the country selected without using the codes more than once
For example, if “Charly Brown” has sent the form selecting the UK as a country, I need to go to the UK tab and add “Charly Brown” name in the Requested By.
Then I need to send an email with the codes we have assigned to this person
Name:
Country: Option to select 5 countries
Also, I have an excel file with 5 tabs, each tab with a table using the name of the country and inside I have a column “Code” with 500 rows with unique numbers, and an empty column called Requested by:
Every time someone submits the form, I need to update the file with the name of the person submitting the form and according to the country selected without using the codes more than once
For example, if “Charly Brown” has sent the form selecting the UK as a country, I need to go to the UK tab and add “Charly Brown” name in the Requested By.
Then I need to send an email with the codes we have assigned to this person
Related categories:
Power Automate