Hello friends! I have an Excel workbook to house information about employees that we are hiring into open positions at my company. I am looking to build two Power Automate flows in this workbook:
1. One that allows a user to ask for an HR approver to review and approve/reject information entered into a row (screenshot of the flow is below):
This part is working properly.
2. A separate flow that is similar to the approval process above, but instead of "Accept/Reject", I want the approver to provide responses that will update in the selected row. The user enters the Compensation Partner's email address in the input and attaches buyout information. That information is queried in a compose action. Then, an approval is started, but instead of the approver responding with Approve/Reject, I want them to see text fields that they can provide answers to the following: Buyout 1 Type, Buyout 1 Wage Type, Buyout 1 as $ Amt, and Buyout 1 Effective Date. Once the information is provided and submitted as a response, the row in Excel will update.
I am not exactly sure how to set up a start/wait for response action when the response is not a standard Accept/Reject, Yes/No, etc. There's additional data entry involved here from the approver.
Can anyone provide guidance on how I could set this up? If it does not make sense what I'm asking, please let me know and I will provide more context. Thank you!
