Hello - I am creating a flow to create a new item in a Sharepoint List when an item is added to another Sharepoint List and bring over some of the data.
I have it set up so that it creates a new item for each Item Type in the first spreadsheet, and I want to bring in the ID field from the first spreadsheet to each of the new records so that it is a clickable link to the record.
So spreadsheet 1:
Order ID (single line text), Items Ordered (choice - multiple)
spreadsheet 2:
Inventory ID (single line text), Order ID (?), Item Ordered (single line text)
Here is my flow:
So this works, but I can't figure out how to link the Order ID. Currently the "Order ID id" field is lookup to the Order ID field in Spreadsheet 1. If I select the dropdown, it lets me add existing ID numbers, and then they show up as a link, but I want it to add the new ID number from the record that is generating the new items.
I tried adding to another simple text field, and it comes through correct but it is not a link to the other item.
Any help is appreciated!!
