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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Create list item based...
Power Automate
Answered

Create list item based on selected item in another file failing

(0) ShareShare
ReportReport
Posted on by 18

I have created a flow (screen shots below) to create a list item based on a selected item in another list. When I run the flow, I am having trouble filtering items from a third list which has data critical to the item being created. 

Create Resource Load Task v1024_1.jpgCreate Resource Load Task v1024_2.jpgCreate Resource Load Task v1024_3.jpgCreate Resource Load Task v1024_4.jpgCreate Resource Load Task v1024_5.jpgCreate Resource Load Task v1024_6.jpgCreate Resource Load Task v1024_7.jpgCreate Resource Load Task v1024_8.jpgCreate Resource Load Task v1024_9.jpg

Categories:
I have the same question (0)
  • v-litu-msft Profile Picture
    Microsoft Employee on at

    Hi @mentioch,

     

    In the last step that Get items with Filter query seems not correct, in the inputs of the Filter query, the syntax not correct, it should be columnName eq 'value':Annotation 2020-01-20 101415.png

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mentioch Profile Picture
    18 on at

    Thx for your reply @v-litu-msft. Here is the syntax I used.

    InkedCreate Resource Load Task v.011 Case Doc.v.01_LI.jpg

    I tried this because when I spell out ColumnName it still doesn't work.

     

  • Verified answer
    v-litu-msft Profile Picture
    Microsoft Employee on at

    Hi @mentioch,

     

    You could have a try the expression item()?['Course'] or items('Apply_to_each_3')?['Course'] in the filter query.

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • mentioch Profile Picture
    18 on at

    Thx for your reply @v-litu-msft. This worked. I had to make some other changes, but the flow is working perfectly now.

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 286

#2
David_MA Profile Picture

David_MA 256 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard