Error Comparing LookUp Return Value

[cwilki43]

I'm trying to have the text of a label change based on if there's an entry in a SP list, and then another if statement based on the text of the entry. My formula is:

If(IsBlank(LookUp('MIC Interview_1', 'Project Heading' = ThisItem.'Project Heading (AM short title)' && 'MIC Email' = User().Email, 'Ford PI')), "INCOMPLETE", If(LookUp('MIC Interview_1', 'Project Heading' = ThisItem.'Project Heading (AM short title)' && 'MIC Email' = User().Email, 'Do you understand your role as an MIC?') = 'I am not the correct MIC for this project', "INCORRECT MIC", "COMPLETE"))

I'm trying to make it so that the value in the column 'Do you understand your role as an MIC?' is compared to 'I am not the correct MIC for this project'. 

The error I'm getting is: "Name isn't valid. 'I am not the correct MIC for this project' isn't recognized.

Any help would be appreciated!

[BCBuizer]

Hi,

It seems there's a reference to ThisItem missing:

If(
	IsBlank(
		LookUp(
			'MIC Interview_1',
			'Project Heading' = ThisItem.'Project Heading (AM short title)' &&
			'MIC Email' = User().Email,
			'Ford PI'
		)
	),
	"INCOMPLETE",
	If(
		LookUp(
			'MIC Interview_1',
			'Project Heading' = ThisItem.'Project Heading (AM short title)' &&
			'MIC Email' = User().Email, 
			'Do you understand your role as an MIC?'
		)= ThisItem.'I am not the correct MIC for this project',
		"INCORRECT MIC",
		"COMPLETE"
	)
)

[cwilki43]

I don't think that works, doesn't ThisItem refer back to the record in my gallery? I want the return value of LookUp being compared to the string "I am not the correct MIC for this project"

[BCBuizer]

Hi @cwilki43 ,

In that case replace the single quotes with doubles:

If(
	IsBlank(
		LookUp(
			'MIC Interview_1',
			'Project Heading' = ThisItem.'Project Heading (AM short title)' &&
			'MIC Email' = User().Email,
			'Ford PI'
		)
	),
	"INCOMPLETE",
	If(
		LookUp(
			'MIC Interview_1',
			'Project Heading' = ThisItem.'Project Heading (AM short title)' &&
			'MIC Email' = User().Email, 
			'Do you understand your role as an MIC?'
		)= "I am not the correct MIC for this project",
		"INCORRECT MIC",
		"COMPLETE"
	)
)

[v-jefferni · Accepted solution]

Hi @cwilki43 ,

I believe the column of that question should be of type Choice, since you cannot force every user type in the exact same words especially they are case sensitive, am I right?

If that column is of type Choice, please try below formula:

If(
    IsBlank(
        LookUp(
            'MIC Interview_1', 
            'Project Heading' = ThisItem.'Project Heading (AM short title)' && 'MIC Email' = User().Email, 'Ford PI'
        )
    ), 
    "INCOMPLETE", 
    If(
        LookUp(
            'MIC Interview_1', 
            'Project Heading' = ThisItem.'Project Heading (AM short title)' && 'MIC Email' = User().Email, 
        ).'Do you understand your role as an MIC?'.Value = "I am not the correct MIC for this project", 
        "INCORRECT MIC", 
        "COMPLETE"
    )
)

Best regards,