You’re offline. This is a read only version of the page.
102
I'm having issues populating a Lookup field in SharePoint with flow they way my flow works is when a document is saved to SharePoint Document Library it does a HTTP Rest call to pull in Data from our CRM tool and updates the document Library but also does a second HTTP rest call to pull in Line items to create a new List. This is where I'm having issues. I have a Lookup filed that is looking for the unique order number for the document I just saved in my Orders document library in SharePoint. I have a Line item List and then a sub line item list for tracking information. Each list has a lookup I would like to be able to have the Sub Line Item list lookup a calculated filed in the Line Item list and the Line Item List point to the Orders document Library. I'm unsure how to get the Lookup ID value
Hi @gbuhre,
Do you want the Lookup field (ConnectWise Opportunity Id field) within your Line item list to be populated with the ConnectWise Opportunity Number value within your Order document library?
If you want the Lookup field within your Line item list to be populated with the ConnectWise Opportunity Number value within your Order document library, please make sure that the "Apply to each 3" action is inside the "Apply to each" action within your flow firstly.
If the "Apply to each 3" action is inside the "Apply to each" action within your flow, within ConnectWise Opportunity Number field of "Create item" action, type the id dynamic content of "Parse JSON" action (Like typing id dynamic content of "Parse JSON" action within ConnectWise Opportunity Number field of "Update item" action ).
If I understand incorrectly, please let me know here. If you could provide more details about your scenario, we would provide a proper workaround for you.
Best regards,
Kris
Share
Report
All responses (
Answers (
