It is possible to show items in a combo box based on a datacard value?

(0) Share

Report

Posted on by ebraga

118

Hello All,

I have a combo box that pulls in items from a SQL table which includes a lot number and an mo number column.

An MO number could have multiple lot numbers. The combo box only needs to show the lot Numbers which I have been able to achieve using ShowColumns.

Is it possible to have the combo box show the list of lot numbers based on an MO number that will be autofilled into a datacardvalue?

ex: show column (lotnumbr) when datacardvalue 1 = monumbr

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Moreshwar 135 on at

Like
a
(1)

Report
Copy link

Link copied!

You can set Items property of combo box using Filter function. Filter(SQLTABLE, monumber = DataCardValue.Text, lotnumber). This will fetch all rows from your table which have monumber = DataCardValue and bind it to Combo Box.

Was this reply helpful? Yes No
ebraga 118 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Ill try this!

Was this reply helpful? Yes No
ebraga 118 on at

Like
a
(0)

Report
Copy link

Link copied!

it's working but its throwing an error
how can I get around this or change the data type?

Was this reply helpful? Yes No
Dipak_Shaw 108 on at

Like
a
(0)

Report
Copy link

Link copied!

@ebraga The above text contains non integer letters eg. 'SA'.
That is why it is throwing error. Try only numerical value.

Was this reply helpful? Yes No
ebraga 118 on at

Like
a
(0)

Report
Copy link

Link copied!

Do you mean I should omit the first two letters in the table so I'm only bringing in a numerical value? Filter(SQLTABLE, monumber = DataCardValue.Text, lotnumber) doesnt work if I change .Text to .Value

Was this reply helpful? Yes No
Dipak_Shaw 108 on at

Like
a
(0)

Report
Copy link

Link copied!

What is the datatype of monumnber Column in SQL table??

Was this reply helpful? Yes No
ebraga 118 on at

Like
a
(0)

Report
Copy link

Link copied!

char.. sorry I don't know much about SQL my DBA builds the tables/views for me

Was this reply helpful? Yes No
Moreshwar 135 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you share screenshot of your SQL table & MONumber that you are passing for filtering the data?

Was this reply helpful? Yes No