You’re offline. This is a read only version of the page.
353
I have 2 Sharepoint lists called MeterReadings and Auths and there is a common field called auth in both lists
I want to create a Gallery that will show records from MeterReadings where the auth is Not in the Auths list
Delegation is a problem as both lists have > 2000 records in them, also the auth field in Meter Readings sometimes has multiple auths like this: 01234K;23456L;45678P. so I will need to use the In function to compare I think
any help much appreciated as always...
Exactly - please check it gets the results as the alternative structure (effectively looking backwards) is even more complex.
@WarrenBelz I tried changing my datarow limit to 500 and the query ran without crashing but came up with 500 missing records so not sure it has worked...tomorrow is another day?
@WarrenBelz I made 2 collections which have given me the latest 2000 records from each List and took out the With statement and it still crashes - is there something else I can try?
It works perfectly here with a couple of collections with the same names and fields, however this is a very complex filter, which is exacerbated by your delimited text column and the need to check each value in each field. I am not totally convinced you will get the right result now - you will have to test it when it gets working. Instead of the With() Statements, make a couple of collections with the same data and then filter them and see if that works.
@WarrenBelz a new screen and Gallery didn't help - I get the racing ants at the top of the screen and thewn after a couple of minutes bam - it crashes my browser:
@WarrenBelz - the problem was the double quotes around Client were the wrong kind - I got an error unexpected character U+201c but when I replaced the double quotes and the red line went away it crashed my session and it keeps doing this....I'll try a new screen..
Are you sure clientname is the correct name for the field you are adding and that was the original field name ? Nothing else makes sense presently.
Hi @WarrenBelz - it's on "Client" - it says AddColumns has some invalid arguments, expected operator......
the word Client redline is heavier than the rest of the code...
What is the error ? I made a couple of collections here with the same names as your lists (out of some test lists) and renamed some fields the same as yours - it ran as below with no errors and produced the expected result. I am assuming that both auth fields are Single Lines of Text
Hi @WarrenBelz thank you for the prompt response
I copied and pasted your code (with a minor change to Auth - it's auth lowercase) and half of the code looks good but the 2nd half there is an error - see attached screenshot
thanks
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
Share
Report
All responses (
Answers (
