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
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Users online (3,089)