Answered

Cascading Drop down not logging to sharepoint list

(0) Share

Report

Posted on by KeshavM

Hi All,

I am developing an app for a ticket center. The goal is to capture user information via Power Apps and submit the data to a SharePoint list I’ve set up. However, I'm facing an issue where all fields except for one dropdown fail to log data into the corresponding SharePoint list column. The dropdowns in question are cascading between Ticket Category and Subcategory. I’ve configured them as choices in my SharePoint list and created a reference list to link each category with its corresponding subcategory.

Any suggestions on how to correctly configure the cascading dropdowns and resolve the issue with the Ticket Subcategory not sending data to its relevant SharePoint list column?

Thank you for your help.

This is the form for the app:

Screenshot 2024-06-19 073439.png

This is the formulas used for categorgy and subcategory:

Screenshot 2024-06-19 073607.png

Screenshot 2024-06-19 073644.png

This is how it logs to the sharepoint list:

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KeshavM ,

If 'Ticket Subcategory' is a choice column , you could try to set the combo box's items property to:

Filter( Choices([@'BIXXXXXTable'].'Ticket Subcategory'), Value in Filter([@'BIXXXXXTable'],'Ticket Category'=DataCardValue4.Selected.Value).'Ticket Subcategory' )

Best Regards,

Bof

Was this reply helpful? Yes No
KeshavM 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your response @v-bofeng-msft

I've tried out the formula you've provided however Power Apps does not seem to recognize Ticket Category and Subcategory for some reason.

Kindly see below image:

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

HI @KeshavM ,

Please try:

Filter(
Choices([@'BIXXXXXTable'].'Ticket Subcategory'),
Value in ForAll(Filter([@'BIXXXXXTable'],'Ticket Category'.Value=DataCardValue4.Selected.Value),'Ticket Subcategory'.Value)
)

Best Regards,

Bof

Was this reply helpful? Yes No