In upload file activity i am passing the below properties
dict(PO Number)=“12213” is assigned to the dictionary
Ensure that your authentication credentials, such as username and password, are correctly configured in the Get File activity for SharePoint access.
cheers…!
yes properties should be added the way you gave in dictionary format only…facing any issue there?
cheers
Hi @vishal_nachankar ,
Thanks for reaching out to the UiPath community.
Ensure that your network and firewall settings do not block UiPath from accessing SharePoint. Sometimes, network or security configurations can cause authentication issues.
Regards,
@pratik.maskar
Yes giving invalid column name error although column name is correct.
Microsoft.SharePoint.Client.ServerException: Column ‘PO Number’ does not exist. It may have been deleted by another user. /sites/SP_GlobalItsInvoices/Data Invoices Processed at Microsoft.SharePoint.Client.ClientRequest.ProcessResponseStream(Stream responseStream)
at Microsoft.SharePoint.Client.ClientRequest.ProcessResponse()
at Microsoft.SharePoint.Client.ClientRequest.ExecuteQueryToServer(ChunkStringBuilder sb)
at Microsoft.SharePoint.Client.ClientRequest.ExecuteQuery()
at Microsoft.SharePoint.Client.ClientRuntimeContext.ExecuteQuery()
at Microsoft.SharePoint.Client.ClientContext.ExecuteQuery()
at UiPathTeam.SharePoint.Utils.AddPropertiesToFile(ClientContext clientContext, String url, Dictionary2 itemProperties) at UiPathTeam.SharePoint.Utils.UploadFile(ClientContext clientContext, String url, String localPath, Dictionary2 itemProperties, Boolean allowOverwrite, Boolean queryInBatch)
at UiPathTeam.SharePoint.Activities.Libraries.UploadFile.Execute(CodeActivityContext context)
at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.ActivityInstance.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)
at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)
It is running fine in run mode but when i try to run in debug mode it is causing authentication issue.
The name should be the backend name please right click on the column name in the site and inspect element…you will see the backend name there
mostly itwould be PONumber or PO_Number…
cheers
this are all the properties when i tried to inspect it
__reactFiber$oceeb375zid
:
Bc {tag: 5, key: null, elementType: ‘span’, type: ‘span’, stateNode: span#header97-PONumber-name.ms-DetailsHeader-cellName.cellName-315, …}
__reactProps$oceeb375zid
:
{id: ‘header97-PONumber-name’, className: ‘ms-DetailsHeader-cellName cellName-315’, children: Array(2)}
accessKey
:
“”
attributeStyleMap
:
StylePropertyMap {size: 0}
attributes
:
NamedNodeMap {0: id, 1: class, id: id, class: class, length: 2}
autocapitalize
:
“”
autofocus
:
false
baseURI
:
“Sign in to your account”
childElementCount
:
0
childNodes
:
NodeList [text]
children
:
HTMLCollection
classList
:
DOMTokenList(2) [‘ms-DetailsHeader-cellName’, ‘cellName-315’, value: ‘ms-DetailsHeader-cellName cellName-315’]
className
:
“ms-DetailsHeader-cellName cellName-315”
clientHeight
:
42
clientLeft
:
0
clientTop
:
0
clientWidth
:
75
contentEditable
:
“inherit”
dataset
:
DOMStringMap {}
dir
:
“”
draggable
:
false
elementTiming
:
“”
enterKeyHint
:
“”
firstChild
:
text
hidden
:
false
id
:
“header97-PONumber-name”
inert
:
false
innerHTML
:
“PO Number”
innerText
:
“PO Number”
inputMode
:
“”
isConnected
:
true
isContentEditable
:
false
lang
:
“”
lastChild
:
text
localName
:
“span”
namespaceURI
:
“XHTML namespace”
nextElementSibling
:
i.ms-Icon.root-90.css-229.ms-DetailsHeader-filterChevron.filterChevron-305
nextSibling
:
i.ms-Icon.root-90.css-229.ms-DetailsHeader-filterChevron.filterChevron-305
nodeName
:
“SPAN”
nodeType
:
1
nonce
:
“”
offsetHeight
:
42
offsetLeft
:
12
offsetParent
:
span#header97-PONumber.ms-DetailsHeader-cellTitle.cellTitle-314
offsetTop
:
0
offsetWidth
:
75
outerHTML
:
“<span id="header97-PONumber-name" class="ms-DetailsHeader-cellName cellName-315">PO Number”
outerText
:
“PO Number”
ownerDocument
:
document
parentElement
:
span#header97-PONumber.ms-DetailsHeader-cellTitle.cellTitle-314
parentNode
:
span#header97-PONumber.ms-DetailsHeader-cellTitle.cellTitle-314
part
:
DOMTokenList [value: ‘’]
scrollHeight
:
42
scrollLeft
:
0
scrollTop
:
0
scrollWidth
:
75
slot
:
“”
spellcheck
:
true
style
:
CSSStyleDeclaration {accentColor: ‘’, additiveSymbols: ‘’, alignContent: ‘’, alignItems: ‘’, alignSelf: ‘’, …}
tabIndex
:
-1
tagName
:
“SPAN”
textContent
:
“PO Number”
textprediction
:
true
title
:
“”
translate
:
true
virtualKeyboardPolicy
:
“”
Everything is resolved except i am not able to run the code in the debug mode when i run in debug mode it is giving the authentication error.
glad it helped you…the name generally will be present in the id field between - so PONumber should be correct
That might be some package issue…can you try changing package version and check
also creating a new project also might help
Happy Automation
cheers
Yes after downgrading the package it worked in debug mode and run mode
Thank u
happy Automation
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.