Fill Textinput value by selectionresult of Gallery Cascade

(0) Share

Report

Posted on by FZ80

148

Hope someone can help this newbie with this:

I have a Table (TblSAK) and use a 3 Gallery's in cascade with this Items Fx: Filter(TblSAK;Categorie=galCategorie.Selected.Value&&Storing=galStoring.Selected.Value&&Locatie=galLocatie.Selected.Locatie) .

On the basis of the result of the 3 cascaded Gallery's a value of a column (name Telephonenumber) should be visible in a Textinput box. I can't find the right formula to realise this.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @FZ80 ,
Try using below formula in Default property of TextInput control -

First(Filter(TblSAK;Categorie=galCategorie.Selected.Value&&Storing=galStoring.Selected.Value&&Locatie=galLocatie.Selected.Locatie)).Telephonenumber
FZ80 148 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi NandiniBhagya20,
Thank for your quick reply. I tried your formula. With that I get the following message:
Incompatible Types for comparisson for Text, Error.
I suggest this must be because of the last part (telephonenumber) as the first part gives a proper reply in the 3 gallery's.
I checked the tablecontent and made all cells 'Text' .
NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @FZ80 ,
What is the column type of "telephonenumber" column - single line of text, choice (single/multi), person/group (single/multi), yes/no, etc?
Verified answer

FZ80 148 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I checked this column type and changed the value from general into text. This did the job and your function replays the numbers. Thanks al lot!