Hello, this is driving me nuts!
I can successfully Get a (SINGLE) Row from an Excel Online table, do some AD lookups, and Update a (SINGLE) Row in the same Excel Online Table.
But where is "Apply to Each"! Excel Online does not have Get Rows, only Get a Row.
Please advise, thank you.
Solved! Go to Solution.
Ok, well, the indicator that a user is not found in Office365Users is an empty Body [] array. To test whether an array is empty or not, see this other post.
Ok. I found Apply to Each. You have to search for it now, its not part of "+New Step" any longer. (may want to update your docs here Flow Team).
But now I'm being asked for "Output from the previous step". There is not output form a Flow button push.
Any ideas?
OK! Figuring this out on my own (as I should be!)
Questions:
Ran into another problem. What happens when the email address i'm looking up using Office365Users is NOT in AD any longer? I can't seem to find an indicator.
I tried:
Any ideas?
Ok, well, the indicator that a user is not found in Office365Users is an empty Body [] array. To test whether an array is empty or not, see this other post.
User | Count |
---|---|
102 | |
40 | |
29 | |
23 | |
16 |
User | Count |
---|---|
132 | |
52 | |
50 | |
36 | |
26 |