Jun 27 2017 01:15 AM
I have two lists A and B. List A has a lookup column to associate a record with a record from list B. When a record is created in list A I need to updated a Status column in list B.
I've started the Flow with:
On step 3 the value for Id ('Unique identifier of item to be updated') should come from the Lookup column in list A but all I see in the dynamic content is ID from Get Item.
What am I missing? How do I retrieve the value from the Lookup column?
Jul 18 2017 10:36 AM
I'm having the same problem. I've tried using Compose, but I get stuck with an array, rather than just the value and I can't get any further. I feel like I'm nearly there, but can't make the final leap.
Posts/Pages I've tried to use as reference:
It also feels like we can't be the only people trying this. Anyone?
Jul 18 2017 12:14 PM - edited Jul 18 2017 01:47 PM
@Jacques van der Hoven, I just figured it out using the hammer/machete approach. Someone please tell me there's an easier way. The basic issue is object v. value. The Dynamic Contents blocks are objects, but that Id field wants a value.
Setup: I have two training sessions lists: SessionList and SignupList. Anytime someone signs up for a session, I want to increment the 'Signups' field in the SessionList for the relevant session by 1, up to the max for that session.
Steps:
@equals(triggerBody()?['Sessions_x003a_ID'], '')So "Sessions_x003a_ID" = "Sessions: ID"
triggerBody()?['Sessions_x003a_ID']
"@triggerBody()?['Sessions_x003a_ID']?['Value']"
I've attached a screenshot of the final result in case that's helpful. The smaller image shows what a Condition's 'advanced mode' looks like (though it's for another field I was working with, so the values are different than the instructions above).
Hope this helps someone else.
As I said, there has to be a better way, but I've spent hours banging my head against this and found none. Would love better (actual?) documentation on this tool.
Jan 12 2018 05:35 AM - edited Jan 12 2018 05:40 AM
Thanks - this got me started, in the end what worked - and for me was very easy was this, I found my lookup value came as a pair with its id, in this case "Channel ID", the value isn't in the list I trigger off, so SharePoint must store it hidden - revealed by Flows.
In my case I post on to a team channel webhook, but could just as easily update the "Channel" list.
Jan 12 2018 06:01 AM
Interesting. When you say 'came as a pair', how do you mean that? I'm probably missing something obvious, but do you have a screenshot showing this pairing?
Jan 12 2018 06:10 AM
Both the altered list id, and the id of the list where I lookup for a value (Channel list) are shown:
So the pair in this case is the Channel list's "Title" and associated "Channel ID"
Jan 12 2018 06:21 AM
Excellent. I'll check it out on my end. Thanks!