Hello
I've got some files on a sharepoint folder that is updated almost daily. The last modified file is sent out to the team on Thursday mornings.
I would like to automate this using Power Automate.
I use the "schedule an action" workflow and then use the "get specified file (properties only)" action. But I can't seem to figure out how to instruct the workflow to pick the last modified file in the sharepoint folder.
This thread has got something similar to what I am looking for. But I cannot get it to work.
A few issues here.
1. My files are in the following location Site address -->"Documents" folder --> "General folder" - I cannot seem to select the general folder. I am able to select my site address. But for Library name, the only options available is "Documents" or "Custom". And the options available within Custom are options that I do not recognise.
2. Is "get specified file (properties only)" the right option if I want the file to be sent as an attachment. I don't understand what "properties only" mean.
3. I tried to use the points from the thread above to select the last modified file, but when I test the flow, it gives me an error saying that "modified column does not exist". Picture attached below
Any guidance on this would be much appreciated.
Thanks
Best regards
Zam
hi @Zam maeby is because you have modified and is Modified with capital letter. Please try. 😉
Proud to be a Flownaut!
Thanks for pointing this out. It seemed to get through okay after capitalising the "M". But it failed further downflow.
I have attached the screenshots of my flow and the error messages.
Image 1 - flow structure
Image 2 - error message (the error was on the 3rd component of the flow, i.e "Apply to each 2")
Image 3 - location of file that I want as attachment. It is in Documents --> General
Would be great if you could look at the screenshots and help me understand what I am doing wrong.
Image 2
Image 3
Image 1
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
33 | |
32 | |
25 | |
25 | |
21 |
User | Count |
---|---|
64 | |
56 | |
44 | |
35 | |
29 |