Answered

Incompatible schemas

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a very simple Distinct(Source data, Column) formula on the Items property of a dropdown box but am getting the following error message: The property cannot consume the type of Tables that this rule produces, due to incompatible schemas.

Any idea what this means?

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Eickhel 374 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Could you please let us know more about the schema? is it a Sharepoint List? SQL Database? what's the column type?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

It's a SharePoint list. The column type is a choice. Thank you.
Verified answer

Eickhel 374 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Ok, so I'm guessing is like this?

Distinct(Choices(SharepointList.ChoiceColumn), Value)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

That worked - thank you!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Dear, i need one more favor like the same i have two dropdowns A,B. i am doing the filter the dropdown B based on the drop down selection A. but it is not taking for me. bease it is choice filed data type. kindly help me how to do the choice type dropdown filter i am doing the filter like this filter(mytable name, tiltle=dropdownA.selected.value) this is working for the with out choice filed takn in the list. but i need the filter on the choce filed kinldy help me. Thanks in advance!!