'On any site'... Use of variables & actions
I am guessing it is not possible to use a Variable or the Output of a previous Action when using 'On any site'... whether it be Add Item, Get Items, Copy Item, etc.
But I am curious... could this be possible via future developments?
-
Hi there,
yes, placeholders are not (yet) possible to use in this cross-site target list's URL part in configuration. And it seems to be quite complex to implement due to the fact that the placeholder would need to be evaluated already during design time to load the target list and its specific configuration parts (CAML query builder for target list in Get items action, or the target list's fields in case of Add/Update item).
Most placeholders can't be partially evaluated without running all dependent actions first, means the whole flow of actions must be executed in case of doubt before correct value is inside a variable or action output placeholder - what is high complex to implement from a logical perspective in design time...
Anyway I moved this request to the Ideas section to keep as an official feature request.0 -
I appreciate the quick & concise response!
In thinking it out...
It definitely would be almost impossible to make it a Universally usable options. It could only work in specific instances, as well it does with the 2 currently available options.
--- --- ---
My current use case might be a useful example of where a 3rd, Dynamic Option could work... (Consistency is a must, I feel.)
We are using Project Online/PWA. (https://tenant-sharepoint.com/sites/PWA/*projectsite*). Each Project created in PWA, has a Project Site that is created at the *projectsite* level, all based on a template. [Also to note, all Libraries & Lists, at all levels within PWA are based on Site Columns & Content Types, so there is consistency everywhere.]
After the Project is created, I have a flow that creates a Group, then a Team, and then adds Tabs to the Team, linked back to the Project Site. These Project Sites are classic and they do not work well with Teams. Well, frankly, Teams doesn't work well/perfectly with anything that isn't directly connected to the Group/Team site itself.
I am basically in the process of breaking away from the /sites/PWA/projectsite config, and moving all content to /sites/ProjectTeamName. [Note: the Template for these Teams sites use all of the same Content Types & Site Columns as in PWA. [I've one-off/manually tested this with Skybow Actions, and it absolute runs perfectly...which is always a surprise with anything involving PWA and it's nuances.]
Content goes from SPSiteURL to TeamsSiteURL.
That is the current use case that prompted the ideal.
--- --- ---
& in thinking out-loud...
In Action Builder, if you used this mythical '3rd Dynamic Option', maybe:
1. You would select Option 3.
2. You would provide your Dynamic Expression/path
3. You would provide a 'sample' (a Relative path, as you would with Option 2/On Any Site)
4. You would configure your CAML using this 'sample', under the notion that any & all possible Dynamic Expression outputs, would be looking at Lists/Libraries that are exactly the same as the 'sample'.
Have a good one,
Taylor
0 -
Since it might be relevant... (& because Power Automate can be a pain in the ass for such tasks...)
As I said, I ran a test version (manually, hard coded) in Skybow, purely to see if I could move content from the PWA Collection into a normal Teams Site, and it surprisingly loved it. Also: the fact that Copy Files Action has a 3rd, Dynamic Path, is also partially responsible for this ideal hitting me. Either way, this what the hard coded Get Items + Dynamic Copy Files looks like in my test case...
Overall Actions
Manual Get Items + Dynamic Copy Items
0 -
You're right - the behavior in the Action Editor should be like your mentioned steps: Define a sample target list to configure the action with the knowledge in runtime every dynamic list (evaluated by dynamic list URL) must have the required structure (columns etc.)
3. You would provide a 'sample' (a Relative path, as you would with Option 2/On Any Site)
4. You would configure your CAML using this 'sample', under the notion that any & all possible Dynamic Expression outputs, would be looking at Lists/Libraries that are exactly the same as the 'sample'.Let's find out whether the demand on this functionality is high and it reaches the priority for implementation.
0
Please sign in to leave a comment.
Comments
4 comments