web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Apply to each Value
Power Automate
Answered

Apply to each Value

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi,

 

Ive been previously shown how to make a flow to update a an item on another list, However the instructions given do not work (I believe because my sharepoint list has a lookup column) the only difference between the instructions and my flow is when i put the update item in i get another option apply to each with value as the default

 

1a.png1aaa.png

I then get an error saying 

 

Column 'RD19' does not exist. It may have been deleted by another user.
clientRequestId: 33458a96-9530-4c24-aa9b-189c09e77b5c
serviceRequestId: 6008ca9e-20b8-8000-177e-f657ffc9a45e

The value of the column is RD19

 

Asset ID (is a lookup column with RD19) and Mine Call (text column has entries with RD19) i want to update the SMU kilometres into finishhours, so everytime someone puts in an entry into prestarts_inspections a flow sends the SMU/Kilometres into finishhours. 

 

Please help i cannot find any information on how to do this?

Categories:
General topics
  • v-yamao-msft Profile Picture
    v-yamao-msft Microsoft Employee on at

    Hi @Anonymous ,

     

    According to your description, it seems that you are trying to update item in list “Asset Register” with value from list “Prestart_inspections”.

     

    In the action Get items action, you are using Filter Query to filter items that “Mine Call” eq “Asset ID Value”.

     

    If there is a space in the column “Mine Call”, you should add “_x0020_” to replace the space, by the way, the single quote should be surrounded on the dynamic content “Asset ID value” but not the static column name.

     

    It should be configured likes below:

    Mine_x0020_Call eq 'Asset ID Value'

     

    I have made the following test according to your scenario, which is working properly.

    1.PNG

     

    By the way, when sharing images with us, please remove/hide your personal info for security purpose.

     

    Best regards,

    Mabel

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at
    @v-yamao-msft wrote:

    Hi @Anonymous ,

     

    According to your description, it seems that you are trying to update item in list “Asset Register” with value from list “Prestart_inspections”.

     

    In the action Get items action, you are using Filter Query to filter items that “Mine Call” eq “Asset ID Value”.

     

    If there is a space in the column “Mine Call”, you should add “_x0020_” to replace the space, by the way, the single quote should be surrounded on the dynamic content “Asset ID value” but not the static column name.

     

    It should be configured likes below:

    Mine_x0020_Call eq 'Asset ID Value'

     

    I have made the following test according to your scenario, which is working properly.

    1.PNG

     

    By the way, when sharing images with us, please remove/hide your personal info for security purpose.

     

    Best regards,

    Mabel

     

    Sorry Mabel. I have done this in the last few days, however i get empty bodies

    forum.png

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at
    @v-yamao-msft wrote:

    Hi @Anonymous ,

     

    According to your description, it seems that you are trying to update item in list “Asset Register” with value from list “Prestart_inspections”.

     

    In the action Get items action, you are using Filter Query to filter items that “Mine Call” eq “Asset ID Value”.

     

    If there is a space in the column “Mine Call”, you should add “_x0020_” to replace the space, by the way, the single quote should be surrounded on the dynamic content “Asset ID value” but not the static column name.

     

    It should be configured likes below:

    Mine_x0020_Call eq 'Asset ID Value'

     

    I have made the following test according to your scenario, which is working properly.

    1.PNG

     

    By the way, when sharing images with us, please remove/hide your personal info for security purpose.

     

    Best regards,

    Mabel

     

    Hi Mabel, after another day of testing no luck,

     

    I created an entire different test site and used three columns and no luck, what ever i do the getitems returns nothing in the body the Columniwantfilled eq Dynamiccontentlookupcolumn doesnt work. I get nothing, at the verge of giving up.

  • v-yamao-msft Profile Picture
    v-yamao-msft Microsoft Employee on at

    Hi @Anonymous ,

     

    Could you share a screen shot of the detailed flow configuration?

     

    If you are using dynamic content “Asset ID value” which is surrounded by a single quote in the Filter Query field, it should return the exact value of the field.

     

    However, from the screenshot you provided, the return result is the column name itself but not the value of the field.

     

    Please make sure you have configured the Filter query field with the following code:

    Mine_x0020_Call eq ‘Asset ID Value’

    Note: Asset ID Value is the dynamic content you should select from the trigger.

     

    With the configuration I sent to you previously, the return result of the Filter query field is displayed likes below.

    3.PNG

     

    Best regards,

    Mabel

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at
    @v-yamao-msft wrote:

    Hi @Anonymous ,

     

    Could you share a screen shot of the detailed flow configuration?

     

    If you are using dynamic content “Asset ID value” which is surrounded by a single quote in the Filter Query field, it should return the exact value of the field.

     

    However, from the screenshot you provided, the return result is the column name itself but not the value of the field.

     

    Please make sure you have configured the Filter query field with the following code:

    Mine_x0020_Call eq ‘Asset ID Value’

    Note: Asset ID Value is the dynamic content you should select from the trigger.

     

    With the configuration I sent to you previously, the return result of the Filter query field is displayed likes below.

    3.PNG

     

    Best regards,

    Mabel

     

    Again Thankyou Mabel for your help,

     

    Im getting errors now, i hope these screenshots are what you need?

    forum1.pngforum2.png

    forum3.pngforum4.png

     

    *Note i added another column Asset to try to see if it was a problem with just that column, same error if i try the same code in get item (but with Asset Value)

     

    Also here is the error code in the body

    {
 "status": 400,
 "message": "The expression \"Mine_x0020_Call eq ‘Asset ID Value’\" is not valid.\r\nclientRequestId: 7906b7d4-af42-482b-aac1-edb52dac2dea\r\nserviceRequestId: 2801cb9e-b092-8000-c2e7-c74ce87ae3ba"
}
  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Also what do you mean trigger select the Asset ID Value? the trigger is the list and there is no where to select Asset ID Value?

     

    Also created a custom view where you can only see the Asset ID and Kilometres ([Today] - 7) Its a large list with over 5000 entries.

     

    Also now the error disappeared and i changed nothing and it went back to a blank body?  

  • Verified answer
    Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    I was finally able to get this to work by placing '' and selecting between these and adding the dynamic content.

     

     

    FIXED.png

     

    It does not work for me if i add 'Asset ID Value' , it has to be put in exactly like above. Jesus its been 4 days on this.

     

    Thankyou for your help Mabel.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 229 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 223 Super User 2026 Season 2

#3
Valantis Profile Picture

Valantis 136 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Known issue with browser automation in Power Automate for Desktop on Google Chrome 146 and 147
Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans