Share
Report
2In Power Automate, how do i filter a Dataverse table lookup field that references another? I'm passing the autonumber value from Table 1 (this table only has an autonumber column and date column (type Date)) to a Power Automate flow.
The List rows function in the flow is tied to Table 2 which has:
-autonumber column - called rcrdID
-Lookup column tied to Table 1's autonumber column
-agendaItem column -- type whole number
-Lookup column tied to Table 3's autonumber column
Basically Table 2 is a junction table (many-to-many) to tie a Date (Table 1) to 1 or more records in Table 3.
I believe the autonumber field in each table is actually a string value. I don't add any prefix to the values and started count at 1
When I pass the Table 1 rcrdID to the automated flow, i get the following error in my List rows filter
A binary operator with incompatible types was detected. Found operand types 'Microsoft.Dynamics.CRM.cr15d_tbl_witrb' and 'Edm.Int32' for operator kind 'Equal'.
My ultimate goal is to create a .csv file that contains only Table 3 records that are associated a date that is in Table 1.
Table 2 has records with a date (lookup to Table 1), agenda item (simple integer value), informationID (lookup to Table 3)
Categories:
I have the same question (0)
All responses (
Answers (
