Valid value but valid if Claims The entry is Invalid

Greetings

I have a Table with a Column that contains a reference.

I put a valid if statement to filter that allow a select list of reference values from the "Names Table

Let say

“Names Table”

Name ID Name
11 Bob
12 Sue
13 Jim

When I add an entry it works and I can only select from those three names.

However, I added an action on another table where the same reference is telling it to Place the Name ID into the proper column
and it works

If it is suppose to put Jim in the row when you look at the Raw table is has the value “13”
and the View displays “Jim”
But The Entry also says “The entry is invalid”

If Click the drop down to assign different name it gives me these option

Bob
Sue
Jim
Jim

Listing Jim twice (I guess the Correct Jim and my Jim)

I can remove the error by just removing the Valid if statement, But I still want that. If I add the entry without the action I still only want to get three options

And it is not just Jim. My action actually creates three new rows with these names in them and all three do the same thing.

Any Ideas on What I may be doing wrong here?

Thanks

Solved Solved
0 5 1,239
  • UX
1 ACCEPTED SOLUTION

Problem Fixed!!

That is just the shorthand I used for post for the valid if. It is actual a Select() statement.

Going Back get data for this response I noticed that my Valid if Select Statement was actually
Select(Names[Name]…) Which would return all the labels.

I changed that to
Select(Names[Name ID]…) and now the problem is fixed.

Guess I just needed a good nights sleep.

Thanks

View solution in original post

5 REPLIES 5
Top Labels in this Space