cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Perez
Helper V
Helper V

get item from a filter

Hi,

i have a loop inj which runs on an Owneres array, 

in the loop im filtering my excel dataset with filter array activity and i want to be able to retirve data from a field.

i tried to use item()['ID'] but getting error that ID is not selectable.

tried also to convert ID to integer but again it is not selectable as it is a string.

 

any ideas how can i select it?

error:

image.png

 

flow:

image.png

6 REPLIES 6
abm
Super User
Super User

Hi @Perez 

 

Believe your ID is numeric. You have couple of options here. 

 

1. Declare a variable type integer. Assign the value and map.

2. Use a compose action, assign the value and map the output.

3. Try using an expression int to convert the string value to numeric.

 

Thanks



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

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @Perez 

 

You can try: 

 

items('Per_Owner_loop')?['ID']

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

v-litu-msft
Community Support
Community Support

Hi @Perez,

 

Could you please share an instance of the Per owner array?

 

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.

Hi @v-litu-msft , thanks for youe replyit is just a names array, to filter the AIs per each owner.

Hi @Perez 

 

Were you able to try the recommendation that I have provided? 

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

yes, i tried that, getting an error that ID is string and therefore cant be selected.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (2,430)