Add arrow to gallery and display record in form

(0) Share

Report

Posted on by KT61

347

Hi, how do I add an Add arrow to gallery and display the selected record in a form. Using Power apps via teams.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@KT61

If your form is on a different screen, you can put a ">" icon in the gallery and make its OnSelect property

Set(varrecord,ThisItem);Navigate(Screen2)

in the form on Screen2, make the Item property Lookup(datasource,ID=varrecord.ID)

Was this reply helpful? Yes No
Verified answer

Chriwo 11 on at

Like (0)

Report
Copy link

Link copied!

Hi @KT61,

if u want to show a specific record from a gallery in a form please try the following

On your gallery choose the ,,OnSelect“ property and add the following line of code:

Navigate(ScreenName)

For ScreenName you should take the name of your screen where the form is placed.
you can add a button or icon to the gallery from the ,,insert“ tab for selecting the record. On this button / icon choose the ,,OnSelect“ property again and type in the following line:

Select(Parent)

Assume that the gallery name is gallery1 you can add the following line of code in the ,,item“ property of your form.

gallery1.Selected

now you should be able to Display the fields of the selected gallery record.

Was this reply helpful? Yes No
KT61 347 on at

Like (0)

Report
Copy link

Link copied!

Hi, I got the following message "Lookup is an unknown or unsupported function"

Was this reply helpful? Yes No
KT61 347 on at

Like (0)

Report
Copy link

Link copied!

Hi Thanks, this worked. Can I display a table imported from excel using this method?

Was this reply helpful? Yes No
Chriwo 11 on at

Like (0)

Report
Copy link

Link copied!

Hi @KT61,
Glad to hear that i could help you.
yes this should also work with excel tables 🙂

if my solution helped you, i would appriciate when u mark it as solution 🙂

Kind regards

Was this reply helpful? Yes No
KT61 347 on at

Like (0)

Report
Copy link

Link copied!

Thanks, If I add a "display form" to a new screen, there is no field to display?

Was this reply helpful? Yes No
Chriwo 11 on at

Like (0)

Report
Copy link

Link copied!

I think it's not possible to connect a local stored excel table directly to a Form.
If you want to show the fields of a local excel table to a Form, you have to go the way via a gallery again.

If you want to connect the form directly to the excel table you must save the excel file to your business Onedrive and connect to the table via OneDrive connector

Was this reply helpful? Yes No