You’re offline. This is a read only version of the page.
I have a flow that looks for changes in the last week to a sharepoint list. First is fetches "items modified", then it adds those Item ID numbers to an array, then it runs through an "apply to each: get changes for an item or a file (properties only)" step. It seems to be doing EXACTLY what I want it to do as far as what it is pulling, but I can't seem to figure out how to then use the data it pulls as it doesn't seem to create any sort of "output".
How can I use this output (picture 2) to update the original array?
Original Get Items Data:
| ID | TItle | Date Modified | Modified by | Top Issues | Risks & Opps |
| 32 | Project Title | 3/1/2020 | Erin Nicole | Things | Stuff |
| 33 | Project #2 | 4/1/2020 | Erin | Stuff | Things |
Changed Items Output: <--- can't even figure out how to get this in a usable format
| ID | Has Column Changed: Project Title | Has Column Changed: Status Date | Has Column Changed: Project Lead |
| 32 | False | True | False |
| 33 | True | True | False |
Final Output: <-- let alone this!
| ID | TItle | Date Modified | Modified by | Top Issues | Risks & Opps | Has Column Changed: Project Title | Has Column Changed: Status Date | Has Column Changed: Project Lead |
| 32 | Project Title | 3/1/2020 | Erin Nicole | Things | Stuff | False | True | False |
| 33 | Project #2 | 4/1/2020 | Erin | Stuff | Things | True | True | False |
I'm happy to dig - I just seem to not even be googling the right things - any suggestions?
.
Hi there
Would it be possible for you to open up your flow and screenshot to show how you have written the formulas and flow steps? I am trying to create a flow that picks up all the changes in a library within a week and then it emails me a list of changes that have happened that week only. Is that possible based on your flow?
Apply to each loops do all their work inside the loop and there really is no output other than success or failure. The typical workaround is to initialize a string or array variable before entering the loop and then append the information that you want to use after the loop exists to the string or array. For example if you want a semicolon delimited list of email addresses to send an email to you would initialize a string, append each email to that string inside the Apply to each, then use the string variable to address an email after you exit the loop.
Share
Report
93
All responses (
Answers (
