Unanswered

How to get specific cells from a SharePoint List row

(0) Share

Report

Posted on by Greg27

782

I have a dropdown list and 2 TextBox's. My dropdown contains the value I need to use to lookup what I need in a SharePoint List. I use the following Filter statement:

Sort(Filter(Available_Components, Location=dd_DataCardValue2.Selected.Location && Enabled="Y"), Component, Ascending)

However, I am receiving the message 'The function 'Sort' has some invalid arguments". I have tried not using Sort and just Filter, but it tells me I am missing an argument. Ultimately, I would like to find the best way to use the value from my dropdown to find the row in my SharePoint List to display 2 different cells in my 2 Textbox's.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Greg27 ,

Looks like you're missing "SortOrder".

Assuming the Location field is a Single Line Text column, try:

Sort( Filter( Available_Components, Location = dd_DataCardValue2.Selected.Location && Enabled = "Y" ), Component, SortOrder.Ascending )

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Greg27 782 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, if I put in SortOrder.Ascending, when I leave the field and come back in, it hides the SortOrder part of the command. I have Sort.Order.Ascending and it still doesn't like the command. It still tells me there is an error in the formula.

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Greg27 ,

Please could you share a Screenshot together with the error message
What are the field types for Location and Component
What do you have in the Items property for your dropdown

Was this reply helpful? Yes No