cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ajita
Level: Power Up

Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

Hi

I am creating a Microsoft Flow for creating new records for 'Accounts' entity. However, I cannot find the 'Address 1: Shipping Method' attribute for Accounts in the list of attributes appearing when Accounts entity is selected.

All other attributes are appearing but not this one. Please refer to screenshot:https://www.screencast.com/t/KhiIdyRXlEQ5

Is there some setting which I am missing. Please guide.

10 REPLIES 10
Dual Super User
Dual Super User

Re: Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

Hi @Ajita 

 

You should be able to see a "Shipping Method" field in that action and this is the actual "Address 1: Shipping Method" attribute of the entity. You might want to do a test and check the same by creating a test record. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Ajita
Level: Power Up

Re: Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

 

Hi @yashag2255 

 

I tried same(to insert Fedex(code:3)). Please see screenshot:

https://www.screencast.com/t/co3tOUY2nP

But it returned error: https://www.screencast.com/t/Nz9rmyb6UlK

 

{
  "status": 400,
  "message": "A validation error occurred.  The value of 'shippingmethodcode' on record of type 'account' is outside the valid range.",
  "source": "imperium-sandbox.crm.dynamics.com",
  "errors": [],
  "debugInfo": "clientRequestId:XXXXXX"
}

 

Dual Super User
Dual Super User

Re: Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

Hi @Ajita 

I tested this on my end and am facing the same issue. This looks like a bug which needs to be looked into by MSFT Folks. You might want to raise a post here:

https://powerusers.microsoft.com/t5/I-Found-A-Bug/bd-p/BugFound

 

BTW, I tried creating a record manually and chose Fedex on the form but then when I retrieved this account using Flow, it showed shippingmethodcode value as 1 and when I tried creating an account passing value as 1, the flow run successfully but there vas no upadate on the account. 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Dual Super User
Dual Super User

Re: Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

@Ajita 

 

Update: 

 

I went on to check the field in the CDS and observed that there is a field called shippingmethodcode that has the label Shipping Method and this one is empty optionset with a default value and for some reason the Address 1 Shipping Method field was not showing up. 

 

As a workaround, what you could do is, go to the accounts entity and add the option set values to this field. Then you will be able to see them in the flow too. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Ajita
Level: Power Up

Re: Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

Hi @yashag2255 

 

Do you mean that I need to customize this field (shippingmethodcode) and add options :

1Airborne
2DHL
3FedEx
4UPS
5Postal Mail
6Full Load
7Will Call

 

here :https://www.screencast.com/t/Klz1ddZRqGqz

Please confirm.

 

Dual Super User
Dual Super User

Re: Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

Hi @Ajita 

 

Yes. But feel free not to customise the values. As you will be able to choose that from the dropdown while creating the record from the action in flow.

 

Hope this Helps!

 

Ajita
Level: Power Up

Re: Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

Hi

@yashag2255 

I tried the workaround suggested, and the options populated correctly https://www.screencast.com/t/OQ1a9iq9X

But the selection did not appear on the Account's Page: https://www.screencast.com/t/CITv8VVz

 

I searched through the network calls in Networks from console and found that this field is mapped with address1_shippingmethodcode which is missing in flow.

 

"address1_shippingmethodcode":{
"value":"FedEx",
"raw":"3",
"invariant":null,
"defaultvalue":"-1"
},

 

Please suggest.

Thanks. 

Dual Super User
Dual Super User

Re: Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

@Ajita 

 

What values are you getting in the Shippng Method attribute? Can you click that and check the dropdown? Are you sure you have published the changed that you made on the entity?

Ajita
Level: Power Up

Re: Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

@yashag2255 

The field is updated the field ShipingMethodCode https://www.screencast.com/t/rIWyM5zASI .

 

Also the dropdown appears for "Shipping method label"

https://www.screencast.com/t/HDEUVVXFBNMi

but not for "Shipping Method".

Dual Super User
Dual Super User

Re: Cannot find Address 1: Shipping Method field for Accounts Entity in MS Flow

Hi @Ajita 

 

The issue here is the Adresss 1 Shipping field is not showing up anywhere unless and until you bring it to the form. and there was the Shippingmethodcode that was coming up and so my initial thought was to first add the same optionset to the shippingmethod field and then you could create a business rule that whenever there is some data in the shipping method code, this is replicated to the Address 1 Shipping field. 

 

And on the dyanmics create a record action, you just select the shipping method labela nd it should update the code accordingly. Can you test that out and see once?

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,228)