Answered

How to write the code to change the FormMode from View to New when a LookUp function does not find a match?

(0) Share

Report

Posted on by Sawh

115

I have created a gallery that when I go to the "Detail Form" it will allow me to see data in another forms as well. The Detail screen contains:

DetailForm1 - Gallery1 is the source for this form

Form2 -Event Data is the source for this form

Each form contains the same data field called Title.

I have used a LookUp function in Items of Form2 to pull data from its source if the data matches the data field from the Gallery textbox referred to as DataCardValue1. If their is data already in the Event Data source matching then Form2's mode is 'View'. I would like to change the mode to 'New' so I can add data to the file from Gallery1 on Form2 if it hasn't already been added.

The code I have written is the following:

If(LookUp('Event Data', DataCardValue1.Text = Title, Title), FormMode.View, If(!IsBlank(LookUp('Event Data', DataCardValue1.Text = Title, Title)), FormMode.New, FormMode.View), FormMode.New, FormMode.View).

I see a message that there is an error in the formula, describing it as there was an expected value compatible with 'DataSource'. I am not sure how to fix this error. Any suggestions?

Ange

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

asdasdasdasdasd 72 on at

Like (1)

Report
Copy link

Link copied!

Just a thought,

Your if statement condition is, LookUp('Event Data', DataCardValue1.Text = Title, Title), which should return true or false.

You could wrap it in !IsBlank(LookUp('Event Data', DataCardValue1.Text = Title, Title)) and that will return true if data exists

Was this reply helpful? Yes No
Verified answer

CU22081303-0 150 on at

Like (1)

Report
Copy link

Link copied!
This might work for you. I can't test this exact formula since I don't have those tables, but I made it work with a similar code and just swapped out my tables for yours.
This goes in the "DefaultMode" property of the Form if I understand correctly.
If(IsBlank(LookUp('Event Data', DataCardValue1.Text = Title,Title)), FormMode.New, FormMode.Edit )

Was this reply helpful? Yes No
Sawh 115 on at

Like (0)

Report
Copy link

Link copied!

I tried that but it didn't work.

Was this reply helpful? Yes No