cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
esoterror
New Member

converting string to array error

Hello,

I'm sorry if this is a wrong forum, but I'm at my wit's end, and really need some guidance.

 

I have an empty field (model number) in an entity called Orders, and a populated field (description) in an entity called OrderProducts.

I created (with some help) a power automate flow to update each (model number) with a corresponding value from (description).

For example, order id #1  in Orders gets a  value from order id #1 (description) "where a descNumber = 1000",  in OrderProducts... etc for each order id. The solution is online. 

Below is the actual flow

esoterror_0-1618862756728.pngesoterror_1-1618862806390.png

esoterror_2-1618862855132.png

 

The problem arises when I test the flow, I receive this 

esoterror_3-1618862994299.png

 

Any help would be greatly appreciated.

 

Thank you!

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Paulie78
Super User
Super User

Sorry, it appears your first apply to each is called apply to each 2, so try this instead:

items('Apply_to_each_2')['Description']

View solution in original post

6 REPLIES 6
Paulie78
Super User
Super User

You cannot apply to each on the description, because this is an element of an object, not an array. Within your apply to each you could use an expression like:

items('Apply_to_each')['Description']

Which will bring out the description for the current item in the apply to each loop.

esoterror
New Member

Thank you for a quick reply, Paulie78.

 

Gonna test it momentarily

Unfortunately, it appears to be running into the same issue....

 

Is there another way to accomplish this task? 

If not, guess ill be banging my head against it all night lol

 

Appreciate the help nonetheless.

 

 

Paulie78
Super User
Super User

Sorry, it appears your first apply to each is called apply to each 2, so try this instead:

items('Apply_to_each_2')['Description']

Thank you! trying now.

esoterror
New Member

Keep getting the same error...

esoterror_0-1618869819845.png

Its so frustrating.. I have a flow that's working for new records (create/update)... but old records keep running into this.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,769)