Solved

Workflow steps

Posted on 2014-10-03
1
122 Views
Last Modified: 2014-10-18
Hi,


Here is my workflow scenario. I have a document library where users will be uploading an Excel file and I need to update a column of the library item with a Dynamically generated URL in the form of

http://mysite/Default.aspx?source=UNCPath to the uploaded file.

Please note that anything before "=" is a fixed string. I just need to dynamically build UNCPath for the uploaded Excel file. I need to check if created item is not a folder content type and the filetype is Excel.

How can this be achieved using SharePoint designer workflow?

Thank you.
0
Comment
Question by:Techsavy
1 Comment
 
LVL 9

Accepted Solution

by:
macarrillo1 earned 500 total points
ID: 40362709
I am not entirely sure I know what you are asking for.  However, if I do understand the question;

You could change your document library to have a calculated field that checks if the file type is Excel and then sets the calculated field equal to the filename.  Then use the workflow to check this field (calculated field) for a value when you don't have a url.  Then construct using your fixed string and the calculated field.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now