Hi All,
I am really hoping someone can point me in a direction because I am lost.
What I have is a SQL table and a Sharepoint list (PICS) with lots of photographs.
The SQL table (SQT) looks like:
ID P1 P2
1 False False
2 True False
3 True True
Each of the photos in the PICS Sharepoint list has an ID value corresponding to the SQL table.
What I want to achieve is a scheduled flow that queries the sql table for IDs where P1 and P2 are both true.
Then finds any corresponding photos in the Sharepoint list and move them to a network share or separate Sharepoint list.
If anyone can give me some advice on how this can be done, it would be greatly appreciated.
Solved! Go to Solution.
Hi @kevinsray
This is what you looking for. Here I have set my trigger as manual. You can use scheduled trigger. Then under the Get Items of SharePoint step (Third action step from top) you need to set the filter query where you can match the sql data to SharePoint. Once you had the match then under the iteration of apply each loop you can retrieve each item and copy or move to another list.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @kevinsray
This is what you looking for. Here I have set my trigger as manual. You can use scheduled trigger. Then under the Get Items of SharePoint step (Third action step from top) you need to set the filter query where you can match the sql data to SharePoint. Once you had the match then under the iteration of apply each loop you can retrieve each item and copy or move to another list.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogABM,
Thank you so much.
This has gotten me a lot closer.
So, I got the SQL Get Rows working perfectly. I was able to confirm the data coming out what as expected.
However, I can`t seem to get it to work after that.
So, the SQL does it`s query and returns a list of BCIDs.
The Get Items seems to want to go under it`s own Apply To Each
And the Copy File goes to Apply To Each 2
It is very close. I can almost smell it.
What would I be doing wrong?
Hi @kevinsray
What's the error you getting?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi ABM,
Sorry. I got it fixed.
I had the ID instead of the Identifier.
Now I have it working.
Thank you so much for your advice.
User | Count |
---|---|
93 | |
39 | |
24 | |
21 | |
16 |
User | Count |
---|---|
129 | |
49 | |
48 | |
31 | |
25 |