42
I have 6-7 columns in a list with Unique ID column : IDs.
Now, my question is if we have more than one record of IDs with same value, then gallery should show only the one with suffix User().email and not _Blank ..
Can anyone please help me with the same ?
List 2 :
UIDs Status Edited By
Ex 1 : 11_Open BID _ BLANK
Ex 2 : 11_Ongoing BID_User().email
Hi @TanviMehta ,
Thanks for your information.
Based on your description, whether you want to filter the column 'Status Edited By', if IDs have the same value, just remove duplicate records, then show the record which the column 'Status Edited By' has suffix User().email. If i didn't have any misunderstanding, you can try to do as below:
1.You should use distinct function to remove duplicate records of Column 'IDs' :
Share
Report
All responses (
Answers (
Distinct(SuffixUser,IDs)//SuffixUser is my SharePoint list name
2.Use ForAll function to get the table which includes the Unique IDs and judge if the rows are more than one, filter the "Blank" in Column 'Status Edited,otherwise, don't filter the "Blank" in column 'Status Edited By' :
ForAll(Distinct(SuffixUser,IDs),If(CountRows(Filter(SuffixUser,IDs=Result))>1,Filter(SuffixUser,IDs=Result,!("Blank" in 'Status Edited By')),Filter(SuffixUser,IDs=Result)))
3. Use Ungroup to get the final result:
Ungroup(ForAll(Distinct(SuffixUser,IDs),If(CountRows(Filter(SuffixUser,IDs=Result))>1,Filter(SuffixUser,IDs=Result,!("Blank" in 'Status Edited By')),Filter(SuffixUser,IDs=Result))),"Value")//Because the value of ‘Filter(SuffixUser,IDs = Result,!("blank" in 'Status Edited By'))’ include multi tables, I use Ungroup function to put them in one table.
Finally, you can the result as below:
List in my side:
|
And the result in my gallery:
|
Hope it helps!
BR,
Arrow
