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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Gallery with Error to ...
Power Apps
Answered

Gallery with Error to Link Dropdown Filter Based in Sharepoint Column Text

(0) ShareShare
ReportReport
Posted on by 253

My Sharepoint list has a Column Text and my Power Apps field input to this sharepoint field is type choice (dropdown). When I try to link my gallery (called status) to my dropdown (called Drpdwn status), appears the error below in red. 

Items:
Filter('Processo de exportação',StatusGeralProcessoSemAColunaPCRTXT=Dropdown9.Selected.Value)

@WarrenBelz @Drrickryp

Gallery error to connect to Drpdwn Status Filter.PNG
Categories:
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @WendeReisss 

    Does StatusGeralProcessoSemAColunaPCRTXT.Value=Dropdown9.Selected.Value

    work?

  • WendeReisss Profile Picture
    253 on at

    It works. It is a Sharepoint column status (type calculated column) that the input to fill the field in this column is Power Apps Dropdown. I've changed the text input to dropdown to fill Sharepoint calculated column field by dropdowns insert item options on it.

  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @WendeReisss 

    Please mark it as solved so others can find it.

  • WendeReisss Profile Picture
    253 on at

    Sorry. I've misunderstood. I thought you were asking if the Sharepoint column (StatusGeralProcessoSemAColunaPCRTXT) works, but you meant formula "if StatusGeralProcessoSemAColunaPCRTXT.Value=Dropdown9.Selected.Value" solved my case.

    The answer is: No. the formula StatusGeralProcessoSemAColunaPCRTXT.Value=Dropdown9.Selected.Value didn't solved my case.

    Follow the error in red light below: 
    Filter('Processo de exportação',StatusGeralProcessoSemAColunaPCRTXT.Value=DrpDwnStatus.Selected.Value

    I think that is my Sharepoint column is type calculated column (like if it was text column) where I'm using dropdown as the field input to insert information in this Sharepoint column, so the "Value" in formula doesn't work.

  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @WendeReisss 

    SharePoint calculated columns are not always interpreted correctly by PowerApps.  They should be avoided and the calculation done in PowerApps.  See #1  https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/The-Ten-Commandments-of-SharePoint-in-PowerApps/ba-p/848842 

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

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
11manish Profile Picture

11manish 393 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 278 Most Valuable Professional

Last 30 days Overall leaderboard