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

Like (0) Share

Report

Posted on 26 Mar 2024 12:59:40 by MacNeg

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:

Power Automate

All responses (5)

Answers (0)

chambersch 8 on 04 Jun 2024 at 16:09:28

Like (1)

Report

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 7 on 04 Jun 2024 at 15:17:06

Like (0)

Report

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 7 on 04 Jun 2024 at 15:16:17

Like (0)

Report

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 8 on 28 May 2024 at 13:10:26

Like (0)

Report

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?
MacNeg 7 on 26 Mar 2024 at 13:59:03

Like (0)

Report

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!

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Leaderboard > Power Automate - General Discussion

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Announcing the Engage with the Community forum!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Warren Belz – Community Spotlight

Subscribe to this forum!

Select categories

Leaderboard > Power Automate - General Discussion

Featured topics

Product updates