Announcements
I want to Set a variable on app start and sum total value of number of bids based on a field called Asset No
Set( TotalBids, Lookup( 'Auc Details', 'Asset No' = lblAssetNo.Text, Sum('Bidding Details',Bids) ) );
@codeworks -
You're description does not quite match what you're trying to do in your code. The code does not seem to make sense. You're using a LookUp function on a table, but then you want the result to be the sum of a column from a different table.
Could you try explaining what you're trying to do in more detail.
Sorry for the mixed up, the look up and the sum is from same SharePoint list(table) as typed below:
Set( TotalBids, Lookup( 'Auc Details', 'Asset No' = lblAssetNo.Text, Sum('Auc Details',Bids) ) );
I got it working with code below
With( { totalBids: Filter( 'Auc Details', 'Asset No' = lblAssetNo.Text ) }, Sum( totalBids, Bids ) )
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 514
WarrenBelz 419 Most Valuable Professional
Valantis 295
