Unanswered

Use form without having to choose item in gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all

I am building a Power App and have run into a problem I cannot solve.

I would like my users to be able to enter a batch number in the app, and then I what it to detect if the batch has previously been entered into the data set.

If the batch number is already in the data set I would like the form to show the relevant data, and if not, I would like the form to submit a new record.

I know how to get it to show the data that is already in the data set, but if I then enter a new batch number, then it says no item to display.

Do anyone have a suggestion for this issue?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

On the search formula you use, Please add the condition to check for Blank. If the results are Blank then make the form mode to FormMode.New. Probably you need to set a variable for the formmode, so you can dynamically change when you do the validation.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for the answer. However, I am still completely lost on how to write the formulas.

When I have this as item for my forms it works, and I can edit and submit all data to the datasource:
First(Filter(TableEtalpha, FærdigvareBatchNummer=LblFVbatchnummer.Text))

TableEtalpha is my datasource
FærdigvareBatchNummer is my column in the datasource
LblFVBatchnummer is a label to write the selected batch number.

But I cannot figure out, how to add a new item to the datasource.

Was this reply helpful? Yes No
venka91 1,119 on at

Like
a
(0)

Report
Copy link

Link copied!

Okay. OnChange property of your textbox, create a collection with the dataset record. Then Item property of Form give this collection name. At the same time, you can also if condition to see if the Collection is Blank. If the collection is Blank, then make Form as FormMode.New, else FormMode.Edit

Was this reply helpful? Yes No