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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,047)