Answered

Show only active records

(0) Share

Report

Posted on by MWads44

Hi All,

I have a basic mileage app with 2 tables, tblVehicles and tblMileageLogs, when you go to the form to log vehicle mileage against a vehicle, you go on a drop down within a form and select the vehicle you want. However it shows both active and none active vechicle because the forumula is Choices([@tblMileageLogs].'Vehicle Reg') within that drop down so it would do.

However i only want the choices of that dropdown to show only the active vehicles only. (The field type is a YES/No (true/false) within a sharepoint list for active within tblVehicles.

I have put some images to help what i am tryign to achieve.

Vehicle Reg in mileage logs is a sharepoint lookup column if you need to know that but i also have it as a text column called Vehicle Reg BI. dont know if you needed to know this part 🙂

Hope you can help me.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

NPPlatform 606 Moderator on at

Like (0)

Report
Hi @MWads44 , you don't need to use the function Choices(). Try something like:

ShowColumns(Filter(tblVehicles, Active = true),[name of column you want to show])
When you add the comma after "true)" Power Apps will give you the available columns that you can choose from to show in the drop down.

Hopefully this fixed your problem!

Was this reply helpful? Yes No
MWads44 62 on at

Like (0)

Report

@NPPlatform
Not showing any of my column names after the comma?

Was this reply helpful? Yes No
NPPlatform 606 Moderator on at

Like (0)

Report

@MWads44 One of those probably is your column name, but it's the internal Sharepoint-name. If you want to know the difference, read this article: https://www.sharepointdiary.com/2011/06/sharepoint-field-display-name-vs-internal-name.html.

The easiest way to see what the internal name is, is by sorting the Sharepoint list on the column 'Vehicle Reg'. It will append something like &sortField=LinkTitle to the url. In this example, LinkTitle would be your internal column name. That is what you would need to insert in my code after "true),". This article also explains how to find the internal name: https://www.sharepointdiary.com/2021/01/get-field-internal-name-in-sharepoint-online-using-powershell.html.

Alternatively, you can try out all the suggestions Power Apps gives you to find the column you are looking for. Let me know if this works for you!

Was this reply helpful? Yes No
MWads44 62 on at

Like (1)

Report

Sorted thanks @NPPlatform

Was this reply helpful? Yes No