Compare collection with list SharePoint to Sum value

(0) Share

Report

Posted on by loopingmurdock

250

Hey, power helpers

am trying to compare a collection to a SharePoint list, in a gallery. the collection has unique UGA which are linked to the user.

i have tryed this:

ForAll(UGA_COL, Sum(Filter(sv_listing_physicians,ThisItem.UGA = UGA),ThisItem.Cible_control))

But get the error:

Text Value expected

what am i doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @loopingmurdock，

Could you please tell me that where and which property do you set this ForAll() function?

More details needed.

Tell me what your UGA_Col and sv_listing_physicians look like.

Was this reply helpful? Yes No
loopingmurdock 250 on at

Like (0)

Report
Copy link

Link copied!

The ForAll() is a collection, property.

UGA_COL:
UGA Zone DMZ Delegue
71MAC 3 Random name Random name
69LYN 5 Random name Random name
93PAR 3 Random name Random name
34MON 5 Random name Random name

sv_list:
UGA Phone_2021 Email_2021 AE_2021
71MAC 52 78
8
93PAR 55 5 6
39GRN 45 6 5
The goal here is to only have the sum of the UGA that are find in the collection {UGA_COL}

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @loopingmurdock,

Do you want to compare the UGA in list with the UGA in collection so that you could sum a column based on the compared result?

If you want to filter the sv_list based on the UGA in the collection, you should try the following formula:

Filter(sv_list,UGA in UGA_Col.UGA)

The above formula could help you filter the records that has the same UGA in collection.

In addition, I am still confused where and which property do you set this ForAll() function, the error indicates that your control expect a text value.

Was this reply helpful? Yes No