Share
Report
254Hello, I have table in Share Point list which contains order ID and criteria, each criteria has possibility Y - yes, means that this order answers to this criteria, another possibility is N - no, which means it wasn't right. Example: Order ID: 123, Name and address (criteria): N. There was an error or name or address of buyer when somebody filled information for this order id. Audit manually should evaluate this error, for example if there is N in Name and address so abbreviation of this error is BOX (just for example).
I want to get my Share Point list with Power Automation Desktop. After I want to write python script where i would say if there is N in column "Name and Address" evaluate this is as error BOX and write it in column error. (before i was working with jupiter notebook so it shouldn't be hard to write a script). How can I do this?
I send you example of my Share Point list:
So real example: If in column "Po attached" is N, this is error SOX-IG. So yeah thats what I need, and I need to write this errors in SP list.
Thank you😉
All responses (
Answers (
