Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Using SAP connector and dynamic content in "SAP function input" parameter

(0) ShareShare
ReportReport
Posted on by 123

Hello Community,

 

I am struggling finding the right json format I should provide in the "SAP function input" parameter when using a "Call SAP function" action.

 

Acording to the connector documentation, the “functionInput” key is a dynamic schema where you specify SAP function input, but there is no example of how you specify that input.

 

I suppose it is in json format, and have done several tests … but it looks the values I try to pass to SAP don’t arrive in the right place.

 

For instance, I have an SAP RFC named “ZGEF080_DATOS_USUARIO” that requires an input structure named CONTROL, with two values:

  • CONTROL/LANGU
  • CONTROL/RFCTYP

 

The way I specify these values in the flow action depends on if, when using the “Call SAP Function”, I specify directly the static name of the SAP RFC or if I use a dynamic name:

  • If I specify directly the static name of the SAP RFC, then at the bottom of the action I get the input boxes where I can specify the values for CONTROL/LANGU and CONTROL/RFCTYP parameters (see screen 1.A)
  • If I specify a dynamic name for the SAP RFC, then at the button of the action I get a field named “SAP Function input”, where I am supposed to enter the values of the parameters … but as explained before, I don’t have a clue on what is the right format (see screen 2.A)
  • I have used the following json formats, without success:
    • { "CONTROL/LANGU": "ES", "CONTROL/RFCTYP": "C" }
    • { "functionInput": [ { "CONTROL/LANGU": "ES", "CONTROL/RFCTYP": "C” } ] }

 

If I use “peek code” on both cases:

  • In the case I specify directly the static name of the SAP RFC, I can see that the parameters are passed as functionInput/…., one for each parameter (see screen 1.B)
  • In the case I specify a dynamic name for the SAP RFC, I can see only one parameter named functionInput (see screen 2.B)

 

So the final question is if anyone know what format should I use for the “SAP Function input” parameter.

 

Screen

A

B

1

 

SAP call with static/direct RFC name and 2 parameters

vllanso_0-1675599032265.png

 

vllanso_1-1675599032268.png

 

2

 

SAP call with dynamic RFC name and dynamic parameters through a compose action

vllanso_2-1675599032270.png

 

vllanso_3-1675599032272.png

 

 

 

Thanks, Victor.

  • vllanso Profile Picture
    vllanso 123 on at
    Re: Using SAP connector and dynamic content in "SAP function input" parameter

    Hello

    With the help of a person from the Microsoft/Sap/Powerautomate team (thank you, Scott), I finally understood what is the syntax of the json to be used in the "SAP function input".

     

    In the sample case I mentioned where the RFC expects a structure named CONTROL, with two fields (LANGU and RFCTYP), the json should be:

    {

        "CONTROL": {

            "LANGU": "ES",

            "RFCTYP": "C"

        }

    }

     

    Regards, Victor.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics