Answered

Need to create a primary key for a form and items in gallery

(0) Share

Report

Posted on by Rajesh456

I have a form and a gallery. Form have two fields and gallery have three columns but could have one or more rows in it.

Using for all I am saving the form and gallery data in one SharePoint list. Now i need to create one column in share point list (which is unique) so that I can retrieve all this data at once. If we consider this as a record being saved from power apps to SharePoint. One record can have any no of values in it. One record could have 5 and another could have 11. But should have only one Id. So that using this Id I can retrieve respective Data. How can I create this unique id while saving.

eg: Name Sex(Form) Subject Marks Date (Gallery)

David Male Maths 90 20/20/20

Physics 80 10/10/10

science 10 10/10/10

The above data should have one id created in Share Point so that it can be retrieved once.

Categories:

Building Power Apps

gallery.PNG

I have the same question (0)

All responses (5)

Answers (2)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@Rajesh456

SharePoint lists automatically create an ID when a new record is added. Although it may be hidden in the SharePoint list seen within SharePoint, it can be referenced and used in PowerApps. To see it, you just need to add a label to your gallery and make its Text property ThisItem.ID

To identify a row in the gallery from a form, the Item property of the form can be

Lookup(SPlist, ID=Gallery1.Selected.ID)

Was this reply helpful? Yes No
Rajesh456 18 on at

Like (0)

Report

@Drrickryp @But for all the items I saved once it need to have only one ID. In one save button if I am pushing 5 rows in to share point all the five need to have the same ID. ID column in share point is giving 5 different id's.

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (0)

Report
Hi @Rajesh456 ,

Maybe you could consider creating a custom ID column.
1. Here is my SharePoint list.
2. Here is my App.
Set(cid,Text(Now(),"yyyymmddhhmmss"));
Filter(datasource,StartsWith(CustomID,TextInput1.Text))
Result Screenshots:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Rajesh456 18 on at

Like (0)

Report

Thanks @v-yujincui-msft .
In the same way for this customer id 1 I am giving a status as "Draft" and on click of another button I need to change the Status to "Closed".
I am able to get Draft for all the necessary records but changing them to Closed is not being done.
With the below code I am only able to change the status for one row but I need the changes for all the rows in one record.
Set(PDFno,Concatenate("PDF-",Text(Now(),"[$-en-US]yymmddhhmmss")));
Set(PDFStatus,"Closed");
Patch(Complete_data,LookUp(Complete_data,PDFNumber=PDFno),{PDFStatuses:PDFStatus});//PDFStatuses consists of 5 rows with same Status Draft of PDFNumber.
Now all these 5 rows should become Closed onclick of submit

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (0)

Report
Hi @Rajesh456 ,

The LookUp() function finds the first row of records in a table that satisfies a formula.
Maybe you could try the following formula:
UpdateIf(Complete_data,PDFNumber=PDFno,{PDFStatuses:PDFStatus})

Best Regards,
Charlie Choi

Was this reply helpful? Yes No