Unanswered

Return array after lookup from other sharepoint list and filter gallery

(0) Share

Report

Posted on by Supasith

Hi Friends

How could I look up and return array from another SharePoint list and then filter gallery with array result from prior lookup ? currently i tried to use lookup function but it only return 1 value (AA 001 02)

Another Sharepoint

Main sharepoint

formula on button in login screen

it only return AA 001 02

thanks in advance for any suggestions

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

TuongDoan 573 Moderator on at

Like (0)

Report
Lookup() always return a single record. You should change it to Filter().

Set(varfilter, Filter(StockTakeAssignUser, UserID = TextInput2.Text).CountSheet)

---------------------------
If the solution I provided assisted you in resolving this issue, kindly select "Accept as solution" This will help others in finding the solution more expediently 😄Also, a Thumbs up would be a great compliment!

Was this reply helpful? Yes No
Supasith 25 on at

Like (0)

Report

@TuongDoan thanks for your reply, next step how could i use varfilter to filter my gallery that datasource from other sharepoint list ?

Was this reply helpful? Yes No