cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sifu
Continued Contributor
Continued Contributor

lookup value from SPO list to another SPO list, get items

hi guys,

  i have 2 lists: list "tna", where i have column days that has number from 1 to 7 (day week nr.) and column "hours contract" that defines contract name list "working hours...", where i have again the same values as above and number of hours to each of the days... my target is to make a flow that will get the hours from list workinghours to list tna. the flow it self is trigered by a scheduled task. i first made a get items on "tna" and then another on the "working hours"....however, the output is always empty...

 

Untitled.png

1 ACCEPTED SOLUTION

Accepted Solutions
Jcook
Super User III
Super User III

Hello @Sifu 

 

Your filter has some syntax issues.

You have it backwards

 

Try:

 

Day eq '<Your dynamic Content>' and Title eq '<Your dynamic Content>'

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

2 REPLIES 2
Jcook
Super User III
Super User III

Hello @Sifu 

 

Your filter has some syntax issues.

You have it backwards

 

Try:

 

Day eq '<Your dynamic Content>' and Title eq '<Your dynamic Content>'

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

Sifu
Continued Contributor
Continued Contributor

that helped and the other issue i had was that one column was formated as number the other as text 😮

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Users online (1,465)