I’ve got two flows (created from the provided templates).
- 'Record form responses in SharePoint' (this moves my data from a Form to List)
- 'Send an email to responder when response submitted in Microsoft Forms' (this triggers two emails, one to myself and one to the the person who submitted the Form)
The first field in my List is ID (which is automatically generated). I want to obtain this item (ID) and insert it into both emails mentioned above (for reference purposes)
But I can’t find this item to include it in my flow 2 (the email). I can only find ResponseID (which produces a completely different number).
From checking the Outputs from the Create item in my first flow, I can clearly see the below being generated:
"ItemInternalId": "86",
"ID": 86,
But when I go into my second flow to use these items from the Dynamic content, the only field I can pull in which looks vaguely similar is ResponseID, which as you can see isn’t what I want. I suspect that response_id gets offset when List entries are deleted.
"response_id": 78
I've tried various expressions to try and pull ItemInternalId or ID into the 'Send an email - Body' step but they either cause a fail or produce blank results, I must be missing a trick.
Any help much appreciated.
