cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akbarmahfuzalam
Post Prodigy
Post Prodigy

LookUp with Multiple Condition

Hi All,

 

I am looking for help in Lookup Function in Powerapps.
I have two galleries and I want the Text which is HB Hours to be populated with sum of another Gallery which has multiple entries of the same User Name Queue Name and date.

 

I want total duration in Hb Hours

 

What formula shall set to get the desired result

 

 

akbarmahfuzalam_0-1620034014295.png

 

akbarmahfuzalam_1-1620034263228.png

 

Thanks in advance

 

11 REPLIES 11

@zaphod88 

 

Did that

akbarmahfuzalam_0-1620058558156.png

 

I just saw you filtered the wrong way round. For filtering, you've got to say PowerApps which given values shall be identical to which ones in the collection. Therefore you have to replace the label Texts, not the collection/gallery ones. Please change Text property for testing purposes to:

Sum(Filter(CollHBData, "5/3/2021" = Text(ShiftDate,DateTimeFormat.ShortDate,"en-US"), "akbar.m.alam" = EID, "YourHiddenText" = 'Activity Name'),PDur)

Please take care that there is data in the collection by looking it up in Files > Collections > CollHBData. If yes, please take a screenshot of your PDur, ShiftDate and EID column. How many items are in the Sharepoint List HBData? Please take care that Activity name and the filter string in your text property are exactly the same.

If not, just insert a button, put a ClearCollect(CollHBData,HBData) in it and press it. 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,733)