check if item exists if not create new using button to navigate to form

(0) Share

Report

Posted on by Community Power Pla...

So I have a button in my powerapp, when a user clicks on the button it should do a few things,

Check if an item has been created in sharepoint list by user (only one entry in list per user)
navigate to New/edit page depending on if item was found by user
Set form to new if record does not exist by user, or set form to edit of item already created by user.
Save form as new record or update record that already exists.

for the button formula I have started with:

If(LookUp(SharePointList,Variable='Created By'.Email,"OK")<>"OK",Set(varCreatedBy,LastAddedItem.'Created By'.Email=varUser)&&NewForm(EditForm2) && Navigate(Screen2,ScreenTransition.Fade),EditForm(EditForm1))

This is formula is not accomplishing my desired above. I would appreciate any and all help!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report
@Anonymous

Put this code in the OnSelect property of your button.

Set(recordID, LookUp(SharePointList,Variable='Created By'.Email, ID)); If(IsBlank(recordID),NewForm(Form1), EditForm(EditForm1)); Navigate(Screen2);

Then use this code in the Item property of your form.

LookUp(SharePointList,ID = recordID)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No