Unanswered

New item entered into a SharePoint list does not appear using Power Apps forms

(0) Share

Report

Posted on by techserf

I have a SharePoint list that has a couple of lookup columns in it. One is called Category and the other SubCategory. The subcategory can have multiple choices. I added a filter to the SubCategory to show only results based on the Category selected. All worked well for several weeks then when a new item was added and teh category and subcategory was selected and the Save button was clicked all information with the exception of the choice entered into the subcategory field is saved to the list. I am not sure why this is happening. Below is my filter:

Filter(DPITCategoriesSub, 'DPIT-Category' = DataCardValue7.Selected.Value)

The filtering works fine it is only when you submit that an issue arrises.

Any thoughts on what the caue might be would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @techserf,

In order to save the sub category LookUp, we will have to use the Choices() lay-out that was initially provided as the Items property code. We can implement your Filter as follows:

Filter( Choices([@DPITCategoriesSub].SubCategory), Id in Filter( DPITCategoriesSub, 'DPIT-Category' = DataCardValue7.Selected.Value ).ID )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Gizachew 62 on at

Like
a
(0)

Report
Copy link

Link copied!

if you want choice column to have multiple values, you need to select allow multiple selections in your sharepoint list column setting. select subcategory in splist- click edit then choose allow multiple selection. do this in your powerapp field also so that your subcategory can be saved with multiple values.

Was this reply helpful? Yes No
techserf 10 on at

Like
a
(0)

Report
Copy link

Link copied!

have not explained my issue clearly enough. I apologize for that. The filter script I posted does an excellent job of filtering the items allowing for the selection of the correct one. It is when I click save the item picked in the SubCategory dropdown does not get added to the list. That field remains empty.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @techserf, I think that filter may be the cause. Would it be possible swap the Filter to my code snippet and save the form?

Was this reply helpful? Yes No
techserf 10 on at

Like
a
(0)

Report
Copy link

Link copied!

I will give it a try this morning. Thanks for the help.

Was this reply helpful? Yes No