Share
Report
13Currently do not have owner's access to the sharepoint doc lib for the data only read access.
I can pull data into to a dropbox/combobox using the choices function and can add a datatable(but need to add concat to 1 of the columns to display data) and all work fine. What I cannot do is only filter certain data in a column so only data in the other column is shown in the dropbox.
| Doc_Type | Car | Doc_Num |
| Service Manual | Smart | A1 |
| Users Manual | Smart | A2 |
| 200mph upgrades | Smart | A3 |
| Service Manual | Corvette | A4 |
| Users Manual | Corvette | A5 |
| 200mph upgrades | Corvette | A6 |
| Service Manual | Viper | A7 |
| Users Manual | Viper | A8 |
| 200mph upgrades | Viper | A9 |
| Service Manual | Yugo | A10 |
| Users Manual | Yugo | A11 |
| 200mph upgrades | Yugo | A12 |
| Service Manual | Maserati | A13 |
'Doc_Type' column in the Sharepoint db is a single choice selection (and shows up in power apps as 'Data type:Table' and when you expand it [Record] for each column row) , 'Car' column is a mutli items choice column (and shows in power apps as 'Data type:Table' and when you expand it [Table] for each column) and 'Doc_Num' is text. This is how the person set it up and this is updated with new additions and updated revisions.
I have a dropbox to select the 'Car' and a label to display the 'Doc_Num'. What I cannot get to work because of the data types is filtering so only the cars that have a 'Service Manual' in 'Doc_Type' column are available in the dropbox and in turn display the 'doc_num' in the label.
All responses (
Answers (
