question

BhaskarMallesh-7323 avatar image
0 Votes"
BhaskarMallesh-7323 asked saldana-msft edited

Getting values from columns in SharePoint2013 Designer

I have created a SharePoint2013 Site Workflow for a document library. In the workflow, I am trying to get values from "Created By" or "Author" column of the document library and display it in the "Log to History List" of the workflow. After running the workflow, I am getting blank / no values displayed for the column. However, I can get values from other columns like Title and display it in the workflow history.

Am I missing anything?

sharepoint-workflow
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BhaskarMallesh-7323 avatar image
0 Votes"
BhaskarMallesh-7323 answered AllenXu-MSFT commented

I could figure out a workaround. As we are using the site workflow, the workaround is to

  1. get the ID of the current item from the dictionary.

  2. use LOOKUP field to match the ID of the current item with the ID of the selected source.


81152-screenshot1.png
81164-screenshot2.png



screenshot2.png (13.5 KiB)
screenshot1.png (20.6 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@BhaskarMallesh-7323,

Glad to hear that you have found a solution and thanks for sharing here.

You can accept your solution as answer, It will be beneficial to others in this forum who meet the same issue in the future :-)

1 Vote 1 ·
AllenXu-MSFT avatar image
1 Vote"
AllenXu-MSFT answered BhaskarMallesh-7323 edited

Hi @BhaskarMallesh-7323,

I couldn't reproduce this issue in my end. I created a workflow like below and I can get "Created By" in the Description field of Workflow History list.
80534-1.png
80456-2.png

Please try to test your workflow in another list/library. If an identical workflow can work in another list/library, this issue is not caused by your workflow. If it still cannot get value from those field values in another list/library, please share your workflow here for further troubleshooting.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


2.png (6.2 KiB)
1.png (12.1 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @AllenXu-MSFT for your swift response. I am using site workflow, getting Documents library items via a RestAPI call and then trying to display Created By value for each row of obtained data. Attached are the screenshots for your reference. The Screenshot2 has few columns underlined that are displayed as blank in the workflow log.


[1]: /answers/storage/temp/80569-screenshot1-http-web-service-call.png

[3]: /answers/storage/temp/80618-screenshot2-get-items-from-dictionary-and-display.png


I have also tried using internal column names as mentioned in the below link but result is still negative.

https://blog.softartisans.com/2009/12/08/list-of-internal-names-for-sharepoint-fields/

0 Votes 0 ·