Compare Item Name of DataTable with Name of Lists Items

[BugSimpson]

Hello Community, the following concern: In my app there is a table with content from one Lists (List 1) and there is a second Lists (List 2). Now I want to collect data from the second Lists (List 2) and if the name from this list matches the names from DataTable2, enter this data there. I already have the following code.

Round(100 - (100 /Int(TextInput2.Text))  * Sum(
    
    Filter(
        Störprotokoll;
        //Month(Now()) = Int(Left(Dropdown1.SelectedText.Value;2));
        ThisItem.Name = Anlage.Value
    );
    DateDiff(
        TimeValue(Hour(Störungseingang) & ":" & Minute(Störungseingang));
        TimeValue(Hour(Störungsausgang) & ":" & Minute(Störungsausgang));
        TimeUnit.Minutes
    ) 
);2) & "%"

[BugSimpson]

can anyone help me?

[madlad]

Hi!

I hope I'm understanding correctly, you want to get all of the items from list 2, if the title is also a title in list 1?

Let me know if I'm mistaken here. 

To get this, you could use something like:

Filter(
  List2,
  Title in List1.Title
)

Depending on exactly how you use it, you may run into some delegation issues. See the below links for more info:

Delegation for filtering

using the in operator

Let me know how this goes!

[BugSimpson]

Hello, in my app there is a table. There are various machines there. A separate Microsoft List contains information about the running times of the machines. These must be summed (Sum()) and then inserted into the apps table for each machine. More understandable?

[BugSimpson]

for one item it is worked. but the other items have the same result. how i can fix this?

Round(100 - (100 /Int(TextInput2.Text))  * Sum(
    
    Filter(
        Störprotokoll;
        Month(Störungseingang) = Int(Left(Dropdown1.SelectedText.Value;2));
        ThisRecord.Anlage.Value = "Nietanlage"
    );
    DateDiff(
        TimeValue(Hour(Störungseingang) & ":" & Minute(Störungseingang));
        TimeValue(Hour(Störungsausgang) & ":" & Minute(Störungsausgang));
        TimeUnit.Minutes
    )
);2) & "%"

[madlad]

@BugSimpson 

Sorry for the delay. 

I see what you're saying here - your code shouldn't be far off what you need. 

I'm guessing the main issue is that all the values are the same, as seen in your 2nd picture?

Also, what is stored in Störprotokoll, and what is the DateDiff(...) for? 

[BugSimpson]

No problem 😉 Times are logged in the fault log. You can see it like a start time and an end time. The whole thing will later be seen as an availability calculated on a monthly basis. In the fault log list, various machine entries are also mixed up.

[madlad]

Hi again, 

I've got the issue to replicate on my test app. I can't figure out why it's doing this, it's very strange behavior.

but I do have a workaround, which is to store the data in a collection. 

Instead of referencing Störprotokoll, somewhere before this(I would do on this screen's 'OnVisible'), save it to a collection with something like:

ClearCollect(tempCol; Störprotokoll);;

Then, in your previous code sample, replace Störprotokoll with 'tempCol'

Let me know how this goes!

[BugSimpson]

Unfortunately it does not work

Round(100 - (100 /Int(TextInput2.Text))  * Sum(
    
    Filter(
        tempCol;
        Month(Störungseingang) = Int(Left(Dropdown1.SelectedText.Value;2))
    );
    DateDiff(
        TimeValue(Hour(Störungseingang) & ":" & Minute(Störungseingang));
        TimeValue(Hour(Störungsausgang) & ":" & Minute(Störungsausgang));
        TimeUnit.Minutes
    )
);2) & "%"

[madlad]

Ah I see- I was focusing on the "ThisItem.Name = Anlage.Value".

Does it return any error? Or just undesired values?