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']

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,394)