edit form to filter fills base on item type

(0) Share

Report

Posted on by Winterkid

Dear All,

thank you for reading my post.

i have an asset list which contain alot of columns. such as

asset list.jpg how can i use powerapps, when i add an item, it edit screen to base on the Items type that i have selected such as Desktop, to apppear fills such as serial number, location,Employee number,username,hostname, mac address (ethernet) etc.
and if the item type i select is apple, i want apple related columns to appear only?

item types.JPG

Please let me know if you need more question i will try my best to answer you.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Winterkid,

Do you want to edit the related record in the Form based on the Item type selected?

Could you please tell me that:

if this Item_Type is the primary key in your asset list?

if each item type has different corresponding columns, such as that if you select apple as item type, only a few columns like serial number, location,Employee number will appear?

Actually, the form could only edit a single one record at one time, which means that you could only filter one record based on the Item_Type you selected from the Combo Box?

Not very sure about your needs.

Or, do you want other controls to be populated with corresponding value based on the selected item type, and you could then edit the record?

Please provide more details.

Regards,

Qi
Winterkid 42 on at

Like
a
(0)

Report
Copy link

Link copied!
hi @v-qiaqi-msft ,
here are my answer to your question.
if this Item_Type is the primary key in your asset list?
Ans: my primary key will be Asset Tag and Item_type if was in sharepoint List. As it will be used for inventory management for Checking, Deployment.
As there will be different product and different type of data to fills.
For Example, for a desktop/notebook/workstation i have data to fill up such as : Asset Tag, Item_Type, Serial number, Emp No, UserName, Location,Mac Address for both Wifi and ethernet connection, Equipment Leasing Contract number and Leasing Start & End Date.
But when i need to do product for a Jabra Speaker, i only need to fill up Asset Tag, Item_Type, Serial number, Location.
If Apple Product for Example iPhone/Ipad : Asset Tag, Item_Type, Serial number, Emp No, UserName, Location, Mac Address for Wifi, IMEI Number, ESIM IMEI Number .
If Apple Pencil : Asset Tag, Item_Type, Serial number, Location Emp No, UserName.

2.if each item type has different corresponding columns, such as that if you select apple as item type, only a few columns like serial number, location,Employee number will appear?

Ans: Yes

Actually, the form could only edit a single one record at one time, which means that you could only filter one record based on the Item_Type you selected from the Combo Box?
Ans: I understand that i can record at one time, When adding new Item, base on the Item_Type that is selected from the Combo Box, filter to which record should the item_type to input.

Not very sure about your needs.
Or, do you want other controls to be populated with corresponding value based on the selected item type, and you could then edit the record?
ANS: yes i will need this also. If when i the item asset number 0001, it item type is iphone, i will only want the columns for iphone to appear.
Please provide more details.

I hope i have answer your question.
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Winterkid,

I think I get there that you just want some certain controls to be visible based on the specific selected item type.

If I understand it correctly this time, I think you could set the Visible property of all the controls based on the selected item type.

Since I am not sure the specific relationship between item type and other columns, I just assume a situation when you select desktop/notebook/workstation.

Set the Visible property of the controls corresponding to all the related columns as below:

If( Item_Type_ComboBox.Selected="desktop" || Item_Type_ComboBox.Selected="notebook" || Item_Type_ComboBox.Selected="workstation", true, false )

Notice that you should select all the related controls and set Visible property as above.

Regards,

Qi
Winterkid 42 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @v-qiaqi-msft , can you show me an example of 2 for if selected desktop and notebook?
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Winterkid,

All you need to do is to set the Visible property of the corresponding data cards.

Please check the gif for reference:

1). If users select "CN" or "Japan" from the DataCardValue9, the Categories and 'Cover Colors' will appear. At this point, I should set the Visible property of the data cards belonging to Categories and 'Cover Colors'

2). If users select "Korea" or "UK" from the DataCardValue9, the Author will appear. At this point, I should set the Visible property of the data cards belonging to Author

Regards,

Qi
Winterkid 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Woo nice it work!! thank you for your help.!