Answered

How to pull data from a SharePoint List

(0) Share

Report

Posted on by jlowthert

I have a flow that is triggered by adding an item to a list. That works. It kicks off an approval. Approval is assigned to the original requestors manager which I use Get Manager V2 and that works. I have the approval responses update the original sharepoint list item. That all works perfectly. The issue I am having is the next step. If Manager1 contain "Name" then you are done and if it doesn't, then do
My problem is this - for this condition I use dynamic content "Manager 1". It is listed under "When item is created" but that info does not get populated in the sharepoint list until after the item is created. When I am trying to compare with this field, even though it was updated and now has data - my only option in the Dynamic Data section is from the "When item is created: section and at that time, there was no data in that field.
This sound confusing so here is a screenshot:

Image 8.png

ManagerName1 originally has no data. The section above (Apply to each 2) populates the field. how do I use that to compare?

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

efialttes 14,756 on at

Like (0)

Report
Copy link

Link copied!

Hu!
So you use 'Update item' in your 'Apply to each 2', right?
You can simply add a 'Get item' action block just before your Condition, use its outputs for Condition inputs. Or you can even use 'Update item' outputs in your Condition inputs
Hope this make sense

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@jlowthert

Why not just use data from Dynamic properties for the Get Manager action that you used earlier in your Flow. You could use Display name, email, etc. for your condition.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @jlowthert ,

Your issue is expected since if you choose the Manager dynamic content from the trigger, the Manager dynamic content would always be null since you fill the value in the following steps.

I agree with @efialttes that you could add a "get item" action before the condition to get the new column value for this item and then you could choose the new Manager dynamic content from the get item action in the Condition.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No