Data table with links to entries

(0) Share

Report

Posted on by Channah

205

Hi there,

I have a data table with a number of entries, the data table is used purely as an overview of projects that are open currently.

Each of these can be edited by going to a gallery page then selecting an entry there which takes you to the edit page.

For ease I would like to be able to select the entries from the data table and have it take me straight to the edit page of the selected entry.

Is this possible?

If unclear what I am attempting do please let me know and I can elaborate.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

DataTable
Set the EditForm item to DatatableName.Selected
Thus what you select will populate the EditForm
For more details
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-data-table

If Gallery (More flexible):
Set the Items property of the Form to Gallery1.Selected if for example your gallery is called Gallery1.
Set Gallery items to Your Datasource
Whatever you select in the Gallery1 will populate the Your Editform.

-----------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Channah 205 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your response,

The data table route is what I am looking for.

I also have a gallery for selecting the reports that has the edit form item set to "Gallery9.Selected" is there a way to code in both Gallery9.Selected and the DataTable.Selected so that it uses either?

Thanks!

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes DatatableName.selected

Was this reply helpful? Yes No
Brasmusic 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I got the following hint:

You requirement can only be achieved by Flow.
If you wan to create a new item with the link and description, please try this flow:
The hyperlink field must be formatted as follows:
"Hyperlink field name": { "__metadata": {"type":"SP.FieldUrlValue"}, "Description": "Description Value", "Url": "Url Value" }
The last field and value must be:
"__metadata": { "type": “SP.Data.MYLISTNAMEListItem" }
In this example replace “MYLISTNAME” with the actual name of the list you are creating an item in and replace any spaces in your list name with “_x0020_”. For example, for my list titled “Proposals Needing Review” I have:
"__metadata": { "type": “SP.Data.Proposals_x0020_Needing_x0020_ReviewListItem" }

For more details about the this flow, please check this blog: Creating SharePoint List Items in Microsoft Flow Using a REST API

This solved my Problem

Thanks Sik

Was this reply helpful? Yes No