Unanswered

Running Oracle ERP reports via Power Automate

(0) Share

Report

Posted on by Dana1

Hello,

I'm new to power Automate and have successfully set up flows to refresh Power BI datasets... but I'm tortured by Oracle ERP, lol.

Each month I have a set of reports I have to run from Oracle ERP...its boring and repetitive and seems like a perfect task for Power Automate.

I have experimented with recording steps (similar to recording a macro in Excel) but it fails. Anyone have any tips, tricks, success with this sort of thing? Do I have to do this with an API?

Thank you,

Dana

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

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

Like (0)

Report
Copy link

Link copied!

Once the steps are recorded, try to analyze the selectors in selector builder in Power automate for Desktop. Editing the selectors and making them identify dynamic objects should solve your issue.

Thanks
Ankesh

Was this reply helpful? Yes No
Dana1 8 on at

Like (0)

Report
Copy link

Link copied!

@Ankesh_49
Hi! Thank you for helping...I'm getting an error just at browser stage though I've added extension...

Cheers,

Dana

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

Like (0)

Report
Copy link

Link copied!

@Dana1 Could you please share PAD script screenshot here. or try using Run Application action instead of launch.

Was this reply helpful? Yes No
Dana1 8 on at

Like (0)

Report
Copy link

Link copied!

Hi- I created a list of three parts I'd like to run the subflow for.

The subflow works when run on its own but right now its basically hard coded for part "M0079". How do I make adjustments so it will run each part on the list? I have zero confidence I'm using list correctly.

I am very, very new with PowerAutomate, apologies, and thank you for your help.

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

Like (0)

Report
Copy link

Link copied!

Is your issue resolved with respect to the extension??

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

Like (0)

Report
Copy link

Link copied!

@Dana1 Please refer it : https://docs.microsoft.com/en-us/power-automate/desktop-flows/variable-data-types

scroll to advanced data types section.

Was this reply helpful? Yes No
Dana1 8 on at

Like (0)

Report
Copy link

Link copied!

No, but decided to break the task into stages. If I can get loop to run successfully I can add all 60 parts to the list and that solves 90% of the pain. Then its getting the connection between PowerAutomate and Oracle for the last 10%.

Was this reply helpful? Yes No
Dana1 8 on at

Like (0)

Report
Copy link

Link copied!
Yes, went there first. And there's a nice summary but not much in the way of syntax and examples. In Python I'd use:
ModelList = ["M0079", "M0275", "M0277"]
...but I'm missing something in PowerAutomate...I am taking an online tutorial to try to learn basics. I tend to learn by trying to solve a real world issue, though, too.

Was this reply helpful? Yes No