Unanswered

How to automate transactions on a system using Excel

(0) Share

Report

Posted on by AliSarhan11

I am trying to automate JVs on SAP by taking each row as one JV, So after finishing first row, they go to second row and complete till it finished all transactions in excel.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (10)

Answers (0)

Sort by

AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AliSarhan11 Could you please refer below and create your script:

Note:
1. You will have more 'Populate text in window' commands as you have many inputs for Journal Voucher
2. Screenshot logic should be good enough for you to create your own script.

Should you require any more information, do let me know.

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
AliSarhan11 30 on at

Like
a
(0)

Report
Copy link

Link copied!

its helpful however I have different rows each row will require same step but different Gl and different amount different currency so will it require same steps for each row. also how to stop it (when row is emety)

Was this reply helpful? Yes No
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AliSarhan11 yes, same steps in for each and pass the variable in populate text action.
Please refer below to get empty row:

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
AliSarhan11 30 on at

Like
a
(0)

Report
Copy link

Link copied!

so how it will look at the full steps?

Was this reply helpful? Yes No
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AliSarhan11 Please share what have you done so far, I want understand your logic as well.
It will look good in full steps.

Cheers,
Ankesh
--------------------------------
“If you give a man a fish, you feed him for a day. If you teach a man to fish, you feed him for a lifetime.”

Was this reply helpful? Yes No
AliSarhan11 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AliSarhan11 implement this after read from excel

Was this reply helpful? Yes No
AliSarhan11 30 on at

Like
a
(0)

Report
Copy link

Link copied!

the thing is now when the read from excel read everything. How come I can extract and populate the text foe each cell to be identified as ui element. in other words how does the read from excel works and how does the for each current item works?

Was this reply helpful? Yes No
AS-06081019-0 1,738 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@AliSarhan11 You will have your issues clarified watching this video:
https://www.youtube.com/watch?v=z3T9jcAGTWw

Hope it helps!!

Cheers,
Ankesh
--------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
AliSarhan11 30 on at

Like
a
(0)

Report
Copy link

Link copied!

I am referring to for each and for read from excel

Was this reply helpful? Yes No