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

Community site session details

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

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
    on at
    Re: Create list item based on selected item in another file failing

    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
    Re: Create list item based on selected item in another file failing

    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
    on at
    Re: Create list item based on selected item in another file failing

    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
    Re: Create list item based on selected item in another file failing

    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard