Unanswered

get item from a filter

(0) Share

Report

Posted on by EP-29071004-0

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:

flow:

All responses (6)

Answers (0)

EP-29071004-0 on at

Like (0)

Report

Re: get item from a filter

yes, i tried that, getting an error that ID is string and therefore cant be selected.
yashag2255 24,442 Super User 2024 Season 1 on at

Like (0)

Report

Re: get item from a filter

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!
EP-29071004-0 on at

Like (0)

Report

Re: get item from a filter

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

Like (0)

Report

Re: get item from a filter

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.
yashag2255 24,442 Super User 2024 Season 1 on at

Like (0)

Report

Re: get item from a filter

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!
abm abm 32,472 Most Valuable Professional on at

Like (0)

Report

Re: get item from a filter

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