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:

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
v-litu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
EP-29071004-0 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
EP-29071004-0 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No