
Announcements
I am trying to get user to the edit form and specific row, that is specified with a ID in a url link. I can see that when I click this link I get to the correct row (in SQL server table), but there is no data in the fields to edit . Only an ID number that is in datacard with ViewText card. Dbo.PaymentVaucher is table in SQL for where I am trying to get specific row data.
-my url to edit form of a app, with row ID. In PowerFlow. Also tested with typing ID:
-OnStart value of App:
-OnSelect value of BrowseGallery1:
-Item value of EditForm1:
I should get data from a row ID specified in a url link, but instead i get empty form, only value of ID is visible:
Any idea what is going wrong? I am only using power apps for 3 weeks 🙂
Hi @Anonymous ,
suggest this way - App OnStart
If(
!IsBlank(Param("ID")),
Set(
varID,
Value(Param("ID"))
);
Navigate(EditForm)
)
Gallery OnSelect
Set(
varID,
ThisItem.ID
);
Navigate(EditForm)
Item of EditForm1
LookUp(
YourListName,
ID=varID
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.