So the actual Flow is not complicated, however I am looking to achieve the following and running into an issue:
- Objective: SharePoint List used as Intake Form for users. The entry sits as 'New' until we change to 'Completed'.
- Flow 1: Assign "Intake ID" using 'When an item is created' and 'Update item'. This works and assigns an ID to the entry as REQ00001, etc. The ID field is marked as 'Generating Intake ID' and then changes to 'REQ0000X' once Flow runs.
- Flow 2: Send e-mail thanking them for submitting the intake, SLA, along with fields such as:
- Intake ID: (example REQ00001)
- Requested Action: (example Add XYZ)
- Name: (their name)
So whenever I run Flow 2, it generates the e-mail with intake ID as "Generating Intake ID". I tried adding a 'Delay' step and delayed it to 5 minutes to allow for Flow 1 to run and then Flow 2 to capture the field as REQ0000X but it still comes up as 'Generating Intake ID'.
Additionally, I haven't tried this yet but I would want a Flow 3 which kicks off and sends an e-mail to the same user + 2-3 more (e.g. their manager) to say the request was completed.
Please help!