Unanswered

To Check if a record already existing in Share Point while editing Gallery on the Go

(0) Share

Report

Posted on by Sidhant_02

986

Hi everyone,
I had a requirement in which on a page I wanted to display records and if a user has to make a change to the record they can do that by using edit button and make the change and save it, for which I have raised a query on the Forum as well if possible to have a look at it as well and let me know a solution for it
Query-1 (Please do check this as well)
I did find a video which is quite close to what I need which was:
Power Apps Editable Table/Gallery like Excel
There was one scenario if a user makes changes in 1 row for different fields then the collection will store 2 values for the same row which should not happen so to avoid this 'If' condition was used (in the reference video data source is Table and in my case it is a SharePointList)

This is the issue that I am facing the SharePoint list is not recognized

SharePoint List: Excel Grid

In Video: (TimeStamp: 20:30):

The scenario is:
If there is a record like:
ID: 5, Title: Samuel, Display Name: Sam, State: Medium, EOD: 12/11/2022

Now let's say the user makes changes to the above record itself so now the application should not create a new record (this will create duplicates) so how do we check the id already exists if it does then the changes should be made for the existing ID itself and not create any new records, else: if there is no record with the ID (which is autogenerated) then create a new record.

Also the other query that I had was how to check the default name given to columns by sharePoint list like for a column created (like EOD) how can one check the default name given by the SharePoint list at backend?.

Regards,
Sidhant.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sidhant_02 986 on at

Like (0)

Report

Re: To Check if a record already existing in Share Point while editing Gallery on the Go

Hi,
I was able to solve the problem for which I have done the following:
1- Created a variable named varCheck which is set to False onStart of App (created this variable to check if there is an account that is created already with the email)
2- Created a pop-up box which notifies user if they try to register an account with the email that is already associated with an individual then a pop-up message should be shown "Email is already registered"
3- On the Save button of the New Registration form added two conditions:
Set(varCheck, LookUp('List Name', Email = TextInput.Text));

If(!IsBlank(varCheck.Email),
Set(showDialog,true)

//In else part: I am carrying out the normal which is saving the record in SharePoint List

If you found this helpful response, click on the Thumbs Up.

Screenshot 2023-0...

Was this reply helpful? Yes No
Sidhant_02 986 on at

Like (0)

Report

Re: To Check if a record already existing in Share Point while editing Gallery on the Go

The above Response was some other requirement that I had which I entered in this topic by mistake and accepted it as well. This is not solved yet so if there is any solution do let me know

Was this reply helpful? Yes No