cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Get Manager (V2) and Get Items

 Hi guys, I've got a problem with get manager and get items,

 

can I use get item to filter the data to select only related department with users?

 

to assign the manager to approve thier users requests in one time.

 

what I've tried is in Screenshot below

ss2.png

 

Thank you in advance

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Get Manager (V2) and Get Items

Hi @iNuii

 

Please try to get the correct column name. Usually, flow will decode the column name randomly, especially when there is a space within the column name.

You could get the extract column name by adding a Compose action after Get items, then get the name by pointing on the dynamic content.

1.PNG

 

Best regards,

Mabel

 

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

View solution in original post

5 REPLIES 5
Highlighted
Super User III
Super User III

Re: Get Manager (V2) and Get Items

@iNuii:

 

Can you provide some more detail on how you want to filter the list items?

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Highlighted
Frequent Visitor

Re: Get Manager (V2) and Get Items

@ScottShearer this problem already solved, then I got another problem is

 

I've tried to filter query from SP List the column call Review Status and I want to select only null value but the filter query show nothing eventhough that column has null value.

 

my code : Review_x0020_Status eq null

 

SS

ss3.png

 

 

my SP List

 

ss4.png

 

Thank you

Highlighted
Community Support
Community Support

Re: Get Manager (V2) and Get Items

Hi @iNuii,

 

Thanks for updating.

About your second problem, I guess the code you are using is correct.

I have just made a similar test on my side for your reference.

 1.PNG2.PNG3.PNG

 

Best regards,

Mabel

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Get Manager (V2) and Get Items

@v-yamao-msft It's seems your code and my code is the same

Highlighted
Community Support
Community Support

Re: Get Manager (V2) and Get Items

Hi @iNuii

 

Please try to get the correct column name. Usually, flow will decode the column name randomly, especially when there is a space within the column name.

You could get the extract column name by adding a Compose action after Get items, then get the name by pointing on the dynamic content.

1.PNG

 

Best regards,

Mabel

 

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

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (2,285)