Include File URL in Item Data for Site Workflow
If you query a library from a site workflow, then use a retrieve item action within a loop, there is no way to get the URL of the files returned. Instead, you have to use a web service call, then query the JSON.
I wanted to add to the properties for libraries. The item URL is not sustainable for document processes. The second someone renames a file or moves a file it breaks!
Please also include Link to Item like Power automate provides to avoid breaking of links!!!!!
When using this for file URL, they don't break! The only workaround at present is enabling document ID services, however that is not best practice within our company. Those all run on timer jobs and we want to refrain from depending on that. However, we have used this to mitigate the issue for processes where users will be moving files around often within folders. The link works forever, however each time it's renamed or moved, it is temporarily down for 5-10 minutes then back up.
The attached is what the output looks like for power automate for file URL's.
In NAC they look like this:
https://[company].sharepoint.com/sites/[sitename]/[documentlibraryname]/[documentname].ext
Any updates on this?
We need the following fields included with query a list action for libraries:
document library name
file name
file path
file URL
folder path
item ID
Site URL
Or to Gavin's point, create a new "query a library" action and include all this.
Also, include the following included with query a list action for lists:
Item ID
Item GUID
Item URL
This is from a community discussion: https://community.nintex.com/t5/Nintex-Workflow-Cloud-Forum/Find-Document-URL/m-p/227911#M3202
I would also add that in NWC using the query list action or retrieve an item action does not return the values need from files in a SharePoint online document library such as the document file path.
A 'Query Library' in SharePoint online would be a great addition to resolve this.