cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ToddSitko
Regular Visitor

Filter Dataverse Table by Excel Table Value

Good day - this is so simple, that I cannot get it to work.

 

As you can see, I am pulling data from an excel file; I want to filter the Dataverse table by an excel value.  Later in the flow, I will condition matched values (Excel column to Dataverse column). Matched values will update the Dataverse record no match will create new record.

 

2022-05-04_8-16-10.png

 

 

1 REPLY 1
MH5
Helper I
Helper I

Hi ToddSitko,

 

In the field your green arrow goes into, enter

crd44_peggedrgm eq '[excelcolumn]'

It should look similar to this:

MH5_0-1664451942071.png

 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,509)