I currently have a power automate flow to automatically respond to personalized information request emails.
When we receive an email that includes the word “contributions” in the subject, with power automate we automatically respond to the email with the amount of the contributions received by the employee.
This amount is located in a table called “data”, in OneDrive that has the following fields
Cod_empl, email, amount, shipped and date.
Cod_empl corresponds to the employee's code, email, is the employee's email, amount, is the amount that has corresponded to him in the contributions, sent is a field that has value Yes, if we have sent a reply email and date is the date of sending the reply email.
This year we are going to make a bonus payment instead of making another flow, I intend to integrate this new response sending into the current flow. In the data table I will add a new field called type, with the values "A" for contributions and "B" for bonuses.
My question is how to modify the flow so that when it receives emails in which the subject includes the word "Contributions", the flow looks in the table for the amount of code "A" and responds to the email with that amount. If the received email has the word "Bonus" in the subject, the flow looks in the table for the amount of code "B" and replies to the email with that amount.
Please, how would I have to modify the flow??
