cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Roshanjaiswal53
Frequent Visitor

Post data from dataverse in an adaptive card.

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. 

Roshanjaiswal53_0-1661320050730.png Screenshot 2022-08-24 111827.png

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

 

Thanks & Regards.

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
MarconettiMarco
Super User
Super User

Hello @Roshanjaiswal53 ,

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

 

BR,

Marco

View solution in original post

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" 

 

 

 

 

 

 

View solution in original post

5 REPLIES 5
MarconettiMarco
Super User
Super User

Hello @Roshanjaiswal53 ,

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

 

BR,

Marco

Roshanjaiswal53
Frequent Visitor

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. 

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" 

 

 

 

 

 

 

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.

AdvancedFind.gif

 

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
Frequent Visitor

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!

 

 

 

 

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!

Top Solution Authors
Users online (6,478)