
Announcements
Dear Community!
Been scrambling my head around this and looked around but couldn't find the right answer.
I have the following flow:
1. when a new SP list item is created then
2. gets a Row - from an excel file stored on one drive.
3. sends email with the data looked up from that excel.
This works well.
The excel file has to be updated every day.
What I want to change is Step 2 - so replacing excel with another SharePoint list ( that I already have).
However I cannot achieve this because in Get Item step I can only lookup by ID of the list item and I want a different column
so instead of the ID on the branch I want another column which apparently isnt available.
Any ideas?
many thanks!
Hi @Anonymous
Have a look at this post. Might give you some ideas.