Hi Everyone,
I have a flow that gets triggered when a new item is submitted in MS Forms.
In this flow, I am creating a record in my SharePoint list called Database 1. In Database 1, I have a column called "Risk Name" which is a single line of text column.
The second action in my flow is to create an item in Database 2. In Database 2, I have a column called "Risk Name" which is a lookup column from Database 1.
While creating a new record in Database 2, the "Risk Name" column needs the lookup ID, as lookup column values can only be stored as IDs.
How can I get the lookup value ID of the "Risk Name" created in Database 1 and use it for creating a new record in Database 2?
Could anyone please help me to fix this isssue
