Hey Guys, was wondering how I can get the record ID when creating a new record within the edit form and where is the best place to get this from. I have created a canvas app using a sharepint list. When clicking on New Record and completing the required fields, I want to user to assign it to a list of email addresses. This should split the record into how many selections the users makes in the assigned to field (combo box) coming from a collection. I have created a data card from the assigned to field which is a text field. I have created a button within to patch the new record to the assigned to emails. It looks like this
My idea is to allow the user creating the record to assigned it to one or more users within the combo box and then clicks the Assign Now button which will patch the details to create however many assigned to users is selected with the same details. I would need
1) How I should formula the patch function to achieve this?
2) How I can within the newly create records from the patch, include the initial record ID, however since this is a new record and it does not have an ID yet, how could I achieve this? Maybe OnSuccess I could patch the record, but I would need to get the ID of the parent record to include in the assigned to records and I would need the formula I can use within the OnSuccess?
I would appreciate any guidance and formula's to achieve this or maybe there is an easier way, which I am not thinking about.
