Answered

How can I filter a 'Add a new row' by an array value?

(0) Share

Report

Posted on by bp3378

114

I want to add a new row into dataverse, and I want to filter by an array value. For example if my array is [ [a,b,c], [d,e,f] ], in the filter i want it to be facility eq array[0][0]. I read that i can't use arrays but i have seen people post that they did it with a concat which didn't work for me.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (1)

Rhiassuring 8,690 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi there,

Sorry, I don't understand. Are you trying to say that you want to filter "Facility" where it is equal to A, or B, or C, and also D, or E, or F?

You can't filter by an array, but, you can pull content from the array and then use that on your filter. But you'd need to extract it first.

Was this reply helpful? Yes No
bp3378 114 on at

Like (0)

Report
Copy link

Link copied!

Sorry for the confusion. Let's just say my array is arr[a,b,c]. I wanted to filter by 'a' so I tried putting this in a string variable:
facility eq 'variables('arr')[0]'
Then putting that in the filter rows field in a List rows action. But that did not work.

Was this reply helpful? Yes No
SamLed 2,338 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @bpw,

You have to send it as expression:

_____________________________________________________________

If I have answered your question, please Accept the post as solution.
If you like my response, please Thumbs Up.

Was this reply helpful? Yes No
bp3378 114 on at

Like (0)

Report
Copy link

Link copied!

Can u show me what you have in your expression. I think I tried that but still failed.

Was this reply helpful? Yes No
Verified answer

SamLed 2,338 Moderator on at

Like (1)

Report
Copy link

Link copied!

@bpw it is already available 😉

Was this reply helpful? Yes No
bp3378 114 on at

Like (1)

Report
Copy link

Link copied!

Thank you it worked. For some reason I thought I did this before but I probably did it differently. Thank you so much waisted a half a day trying to figure this out

Was this reply helpful? Yes No