Skip to main content

Notifications

Community site session details

Community site session details

Session Id : MFo8KEOW4qAvHSZxCubnjy
Power Automate - General Discussion
Unanswered

Power automate advance parameters are missing or cleared out with D365 connection

Like (0) ShareShare
ReportReport
Posted on 26 Mar 2024 12:59:40 by 7
Hello, 
 
I am new to power automate. I created a cloud flow that will export data package from D365 F&O, extract data package and save it on sharepoint folder, extract data then refresh a power BI report that reads the exported data.  Flow was working consistenly until late this morning when I tried to run it again, I started getting the error below.  When I checked my flow, I found out that all parameter values I set when calling D365 actions are gone/blanked out.  All other parameter values for teams, outlook, sharepoint are intact.   Not sure what caused the D365 action to be cleared out.  I checked my other cloud flow in other environment and same thing happned (i.e. UT).  Did anyone encounter this too today? Any ideas?  
 
{
  /status/: 400,
  /message/: /An error has occurred.  InvokeAction - Model state is invalid. parameters: A null value was found for the property named 'reExecute', which has the expected type 'Edm.Boolean[Nullable=False]'. The expected type 'Edm.Boolean[Nullable=False]' does not allow null values.//r/clientRequestId: 6b57248..../,
  /error/: {
    /message/: /An error has occurred.  InvokeAction - Model state is invalid. parameters: A null value was found for the property named 'reExecute', which has the expected type 'Edm.Boolean[Nullable=False]'. The expected type 'Edm.Boolean[Nullable=False]' does not allow null values./
  },
 
Thanks a lot in advance, 
Categories:
  • chambersch Profile Picture
    8 on 04 Jun 2024 at 16:09:28
    Re: Power automate advance parameters are missing or cleared out with D365 connection

    I moved the step where the storedProc is being called from lower in the flow (step 5 or 6) up to the 2nd step.  This appears to have resolved the disappearing Advanced Parameters issue in the storedProc step for me. I assume it was a matter of scope, though I'm not sure why.

     

  • MacNeg Profile Picture
    7 on 04 Jun 2024 at 15:17:06
    Re: Power automate advance parameters are missing or cleared out with D365 connection

    I encountered the error again but just in our DME environment.  UT and PROD were good. 

     

  • MacNeg Profile Picture
    7 on 04 Jun 2024 at 15:16:17
    Re: Power automate advance parameters are missing or cleared out with D365 connection

    I encountered the error again but just in our DME environment.  UT and PROD were good. 

     

  • chambersch Profile Picture
    8 on 28 May 2024 at 13:10:26
    Re: Power automate advance parameters are missing or cleared out with D365 connection

    I'm having the same issue with a step that calls a Stored Procedure in a SQL DB.  I have 4 advanced parameters set, and everything works fine.  The next morning those 4 parameters are gone.  If I replace them, all's well... until the next morning when they're missing again.

    Why do these keep disappearing and need to be redone daily?

     

    chambersch_0-1716901721396.png

     

  • MacNeg Profile Picture
    7 on 26 Mar 2024 at 13:59:03
    Re: Power automate advance parameters are missing or cleared out with D365 connection

    Additional information:  The above happened last Monday, 3/18.  I re-added paramter values and UT and DME were working good until today, It reported the error again just in UT.  DME is good.  These cloud flows are scheduled to run daily in the AM. 

     

    Thank you! 

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

#1
David_MA Profile Picture

David_MA 8 Super User 2025 Season 1

#3
ankit_singhal Profile Picture

ankit_singhal 7 Super User 2025 Season 1

Overall leaderboard