List Rows - Filter Rows Error

(0) Share

Report

Posted on by CCEP_Mike

219

Hello,

I have a Dataverse table which contains some records, I'm trying to create a Flow which will delete records that have the "Audit Status" equal to "Draft" and the "Created On" date less than todays date. So I'm first starting off with a flow to get the ID of the rows that needs to be deleted using the "List Rows" functionality. But when i test what I have in there to list the rows, its failing and giving me this error message:

A binary operator with incompatible types was detected. Found operand types 'Edm.Int32' and 'Edm.String' for operator kind 'Equal'.

Below is what i have within the flow:

the audit status field is a Choice field with only 2 values (0 = Draft, 1 = Completed).

This is the first time I'm using "Filter Rows" so no doubt I've done something wrong. If someone could help assist/guide me that would be much appreciated. Thank you in advance 🙂

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

shoog 2,164 on at

Like (0)

Report
Copy link

Link copied!
You would have to use the ID (numeric) of the choice value rather than the description, so something like:

cda_auditstatus eq 0

if the ID for draft is 0.

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report
Copy link

Link copied!
assuming Audit Status Darft value in Dataverse choice field settings is 0

your filter should look like this

createdon lt @{utcnow()} and cr8f5_auditstatus eq 0

----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
CCEP_Mike 219 on at

Like (0)

Report
Copy link

Link copied!

Thank you both for your response, I've now got this working as expected. thank you 🙂

Was this reply helpful? Yes No