web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Need help - Dropdown F...
Power Apps
Unanswered

Need help - Dropdown Filter Not Updating Record

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi All,

Need help with filter dropdown – the formula is app is working fine – but data is not getting updated in SharePoint. Below are the details:

SharePoint column Structure:

1.jpg

Background – I have a SharePoint data collection app and I want users to fill the form (via Power App) on a monthly basis

 

Columns which has filter lookup on the App are Cluster, Country and Company Code. Note – the lookup data is on another folder of table of SharePoint as below:

 

 

All the details are in the attached word document with screenshots

And the formula on the field goes as below:

Field Cluster – Items - Distinct('Mapping File Cluster - Country - Company', Region)

Field Country – Items - Distinct(Filter('Mapping File Cluster - Country - Company', Region = DataCardValue15.Selected.Result),Country)

Note - DataCardValue15 is Cluster field

Field CompanyCode – Items - Filter('Mapping File Cluster - Country - Company', Country = DataCardValue16.Selected.Result)

Note - DataCardValue16 is Country field

All filters are working fine – but issue is when data is submitted the data does not get updated in Sharepoint

Cluster – Update formula is - DataCardValue15.Selected

Country update formula is - DataCardValue16.Selected

Company Code update formula is - DataCardValue17.Selected

PowerApp Help.docx
Categories:
Building Power Apps
I have the same question (0)
  • PriyankaGeethik Profile Picture
    PriyankaGeethik 3,320 Super User 2024 Season 1 on at

    Hi @Anonymous ,

     

    Would you mind trying below formula.

     

    Cluster – Update formula is - DataCardValue15.Selected.Value (Or Result) based on your form 

Country update formula is - DataCardValue16.Selected.Value (Or Result) based on your form 

Company Code update formula is - DataCardValue17.Selected.Value (Or Result) based on your form

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Both giving error - see attached

    Error for result.jpg

     

    Error for value.jpg

  • PriyankaGeethik Profile Picture
    PriyankaGeethik 3,320 Super User 2024 Season 1 on at

    Hi @Anonymous ,

     

    These are combobox not dropdown ? For all three your getting error ?

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Yes all 3 - am referring to below fields:

    Box.jpg

    Also attached word document has all details

    PowerApp Help.docx
  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Thx @PriyankaGeethik for quick replies - am sure am doing some basic mistake and that is why I had attached the word doc

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @gabibalaban - Can you help with this? Thanks.

  • CU-18081211-6 Profile Picture
    CU-18081211-6 9,272 Moderator on at

    @Anonymous , @PriyankaGeethik ,

    I think that you have to take in consideration to use the only one lookup column - Company Code (because is the only one which stores different/unique values), the other two can be associated columns to the Company Code lookup column (its will be filled based on Company Code selected value). Here is a picture of what I mean:

    gabibalaban_0-1629904725185.png

     

    Looking at the Items property, you have there a table with one column - Result (result of distinct functions). A lookup column is not expected a record like parent list - lookup column , is waiting for a record of this form (minimal requirements):

     

    LookUpColumn:{
 Id: ....., 
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"}
 }

     

    where Id is found in the parent list of the lookup column. 

    So, in your case the update property for Company Code datacard should look like:

     

    {
 Id: DataCardValue17.Selected.ID, 
 '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
}

     

    Hope it helps !

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @gabibalaban - Thanks for the quick response - The reason I want 3 dropdowns is to help with user exp. Because in the form if keep only company code - then they have to look for 80+ company code and select theirs - by adding 2 more columns they are able to filter starting with Region -eg as Asia, then in that limit the country to say Australia and then limit it to 2 or 3 company codes.

     

    I tried adding below in the update field of company code - but still no luck.

     

    Id: DataCardValue17.Selected.ID, '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"

     

    Something very basic I would have missed is for sure - worst case even if I get a code to create 3 new hidden fields and when pressed submit the data of these fields are mapped to those 3 new hidden fields and mapped to SharePoint then also it's ok.

     

    Thanks again for helping. waiting for some more advice.

  • CU-18081211-6 Profile Picture
    CU-18081211-6 9,272 Moderator on at

    @Anonymous,

    I understand the need of using the 3 dropdowns for a better user experience and I’m totally agree with it. You can you use all three dropdowns in same datacard linked to company code column from where you will send the values. The other two columns will be linked automatically to the parent list value for corespondent company code.

    So, what I propose is to modify the list like I said in the previous post, refresh the connection to the list in powerapps app and delete the 2 datacard from form linked to cluster and country column (move the dropdowns to company code or recreate it).

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    This has still not solved my problem. Attached is a detail word document for all screenshots and formulas used, can you please check and help in which section am going wrong.

     

    Thanks again

    PowerApp Help Upd...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 345 Most Valuable Professional

#2
11manish Profile Picture

11manish 207 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 177

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans