cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ttaylor
Level: Powered On

Re: Adding and displaying multiple comments for same customer with a date and time stamp

I did! I was getting an error. Organization is a LookUP column in Notes. 

ttaylor
Level: Powered On

Re: Adding and displaying multiple comments for same customer with a date and time stamp

Sorry - I should have been more clear. The error comes up in your Step 10: 

 

 Filter(Notes,OrgDropDown.SelectedText.Value=Organization)

 

I get an invalid argument type. 

 

OrgDropDown is from the main screen, Contacts list, Organization field.

Notes datasource has the Organization field as a LookUP to Contacts list

 

 

Dual Super User
Dual Super User

Re: Adding and displaying multiple comments for same customer with a date and time stamp

Hi @ttaylor 

 

Can you try below expression and see if that works:
 
 Filter(Notes,Organization.Value =OrgDropDown.SelectedText.Value)
This need to be replaced with the column name used in dropdown to match the criteria.
 
Hope this Helps!
 
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
ttaylor
Level: Powered On

Re: Adding and displaying multiple comments for same customer with a date and time stamp

Thank you!!! This worked perfectly for the gallery. Is it possible to do this filter on a form?

Super User
Super User

Re: Adding and displaying multiple comments for same customer with a date and time stamp

@ttaylor 

A form can only accept one record at a time so you'd have to wrap it in a function that ensures only 1 record is returned (most likely the FIRST or LAST functions).  A typical statement you might type into the Items property of the form would look like this. 

 

 First(Filter(Notes,Organization.Value =OrgDropDown.SelectedText.Value))

 

If for some reason the wrong result is showing, you might have to add further arguments to the filter to ensure the correct record is selected.  A unique value like an ID usually satisfies this problem.

 

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

View solution in original post

Super User
Super User

Re: Adding and displaying multiple comments for same customer with a date and time stamp

@yashag2255 

Hats off to you dude if you finally solved this issue!

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,561)