Hi
Your explanation is perfect, however something is missing. I don't know what Table you have the information for. What I mean is, in your Flow, does it know about ListA first??? or ListB first???
A.K.A. do you have the term FUND1 or do you have the term FUND1 - Draft 1 first? The order matters in how I answer.
Let's say that you have FUND1 (by itself first).
You would do
1. Get Items , on ListB, with a Filter expression of MyColumn eq 'FUND1' and if you column name has spaces use [My Column] eq 'FUND1'
2. Add a Condition action
In the left put the expression length(AndInHerePutTheDynamicPropertyBody/Value from Step 1)
in the middle put equals
in the right 1
This will verify you only got the 1 record.
3. I know this may seem silly but add an Apply to Each in the Yes side
4. In the Apply to Each, rename it to ListB Item (just like that)
5. Inside the 'ListB Item' loop put
Get Items, for ListA and the filter would be [My Column]
In the filter we CANNOT use Contains, we need to use substringof
so it looks like this
substringof(ListAColumnToCheckGoesHere, 'InsertTheDynamicPropertyInListBThatHasTheFUND1value')
Now once again we need to validate that you received a row so
Put a Condition check right under the GetItems
Left side put the expression length(PutDynamicBody/ValueFromtheListAGetItems)
middle equals
right 1
Note: we could have skipped using Apply to each's but this is easier to type up than typing long paths to data
In the Yes side, we want to update ListA so put an Apply to Each (yes I know its silly but please do)
Now, we only expect to have 1 row to update as only (hopefully) only 1 row matches the Filter
Add an UpdateItem SharePoint action
in the ID put the Dynamic ID Property from your listA get items
populate any required fields. You do so by simply putting in the Matching Dynamic ListA property from the Get Items
In the ONE column you want updated (Strategy)
-- You would put the Dynamic Strategy Property, from the original ListB Get Items
and you are done :-)
2
Share
Report
All responses (
Answers (
