Hi @Angela93yan I hope you are doing well.
Here below you will find my comments about how to interact with SAP and Excel.
The high-level process seems like this:
Step1-Reads data from Excel Column A and B which are Items and Outcome (let’s assume those are the columns). You have to use an action called Read from Excel and read the whole range.
Step2-Reads data from SAP Column Items Row1, you have to use an action called Get Details of the Ui element in Window to get the value OR you can try to get the Details of the whole SAP Items column.
Step3-Here you need to use the “For Each” Action to go over each row from the spreadsheet.
Step4-Go over all the rows in the SAP table on the “Items” read each value and compare the “Items Excel Value” against the “Items SAP Value”, if both values match, Populate the “Outcome Excel Value” into the “Outcome SAP Row”.
Hope this helps,
If I have addressed your inquiry successfully, kindly consider marking my response as the preferred solution. If you found my assistance helpful, a 'Thumbs Up' would be greatly appreciated.
Additionally, I offer specialized consultancy and development services leveraging PAD. If you're interested in exploring these services further, feel free to DM me, and we can initiate a discussion.
Kind regards,
Will SG
Managing Director & Automation Lead
RAMS CR (Recruitment & Automation)
LinkedIn Profile