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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Issue in collections
Power Apps
Unanswered

Issue in collections

(0) ShareShare
ReportReport
Posted on by 6
I hope you are doing well.
The reason I am reaching you out is to know If you could help me or do you know someone who can help in Power Apps,
My issue is when I try to access directly to table of Excel in Sharepoint, I am facing this message :
Error al intentar recuperar datos de la red: !CKIxd!Syntax error at position 10 in 'MRR Number eq '0001''. Ploc ! inner exception: !CKIxd!Syntax error at position 10 in 'MRR Number eq '0001''. Ploc ! clientRequestId: a7967e8f-5564-469d-9176-35485640a6b6
 
My code is:
ClearCollect(
    colbase4;
    Filter(
        MRR;
        'MRR Number' = txt_mrr_number_2.Text
   
    )
)
 
where :
 
Colbase4 is the new collection
MRR is the Excel table in Sharepoint
I would appreciate your valuable help.
 
NV
Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    153,073 Most Valuable Professional on at
    If 'MRR Number' is a numeric value, you need Value(txt_mrr_number_2.Text)
     
    Please click Does this answer your question 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 a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    LinkedIn   
    Buy me a coffee

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard