Post data from dataverse in an adaptive card.

[Roshanjaiswal53]

Hi there, 

 So I was working on a power automate flow which posted a teams adaptive card in a chat using data from data verse. 

I have to filter the data based on users and I am using an if condition here. but the problem is, the end user is getting redundant data in the chat and the condition is not filtering the data as well. 

 

 help me out with this and let me know if I am making a mistake here. 

Thanks & Regards.

[MarconettiMarco · Accepted solution]

Hello @Roshanjaiswal53 ,

are you applying some filters in the "List rows" action?

BR,

Marco

[Roshanjaiswal53]

Hi @MarconettiMarco, 

no i did not apply filters in the "List rows" action. 

i want to  filter the records based on the user. i have the users username in the database and i am trying to filter it by matching the current users username and the username present in the database. 

Currently figuring out what can be the query to filter the rows. 

[Roshanjaiswal53 · Accepted solution]

the query to filter rows based on a condition is - 

(internal column name) eq '(condition based on which you want to filter)'

example  - cr6d0_username eq 'username'. 

use this in the 'Filter rows' section of "list rows - advanced option" 

[MarconettiMarco]

Hello @Roshanjaiswal53 ,

in order to apply the filter directly in the List rows action, please follow these steps:

1. You should open the Dataverse Advanced Find;

2. Select your table;

3. Apply all filters you need;

4. Download the Fecth XML;

5 Copy and paste it in the "Fetch Xml Query" field in "List rows" action;

6 Replace static value with your dynamic value.

Please let me know if the issue is fixed.

If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.

I may not have all the answers, but I'm curious and passionate enough to keep looking for answers and to keep sharing them.

My blog site about Power Automate: https://powerautomatejoy.com/

BR,

Marco

[Roshanjaiswal53]

Hey there @MarconettiMarco,

Actually in this scenario there is no need to fetch the XML query and my data is getting filtered based on the query which i stated above. i am using that query in the "filter rows" section. 

Nevertheless your suggestion of using "filter rows" worked.  Thanks mate!