I have a Master Location List (Table A) on a parent SharePoint site and a partial copy of this list on a subsite (Table B). I want to keep the two in synch with Flow. (Side note: I was using a site lookup column on the parent site, but I have had difficulty accessing site column information with Flows triggered by the subsite.)
I have made a flow that runs on the Table A when an item is create or modified. Right now, I'm trying to create the "what to do if the item is modified" branch of the flow, hence Condition 1. My flow works fine until you get to Condition 2 - which never finds a match so the update item is never run. I know Table B has a matching record. (Another flow actually created the matching record in Table B from Table A; I used excel to check the matches on the Service Location Field between the two lists.)
I noticed in the run details is that the condition only seems to get checked for 100 "Get items' when their are 149 records in the list. I've set the view to show 200 items, I've verifyied that field type (single line text) and size are the same. I've sorted the view differntly. Do you have any ideas as to why the condition might always be false?
Solved! Go to Solution.
Thanks Fausto. I this got me in the right direction. I like this better, as it doesn't spend time looping through the destination table. I'm having trouble getting the Filter Query to work. I get the message - The expression "Service Location Code eq 'AA_AA_AA'" is not valid. I first tried putting the single quotes in Filter Query (like image) and leaving them out with the same error. I would have guessed that the column name isn't the problem because I wan't not getting that error anymore, but it is... since I have spaces in the name. Using the output from the unfiltered get items you find the below. Once you change the left half of the equation to the below, it works!
I have a flow that works when an item is created that adds it to the other list if it doesn't exist; I'll merge the two together when I get this one working! I'm sure that will be another challenge! Thanks for your time!
I'm glad my suggestions got you in the right direction to achieve what you need with Flow. Please do not hesitate to reach out if you need any assistance in the future.
Fausto Capellan, Jr
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!