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 / Warning This formula u...
Power Apps
Answered

Warning This formula uses scope, which is not presently supported for evaluation. Data type: Text in ComboBox control (repeating table, collections)

(0) ShareShare
ReportReport
Posted on by 17

Hi! Funny story explaining why I am here: company decided to migrate completely to Sharepoint online which killed our previous sites functionality with infopath + nintex workflow.

 

And I am the poor devil who made those previous sites so of course I am the one who needs to fix them (in this case make them from the beginning) in a completely new environment (powerapps + power automate) I didn't know existed 3 months ago. 

 

Yikes.

 

Fortunately, Shane Young videos on repeating tables have saved me a lot of suffering. Shane, I think you frequent these forums, if you see this, all I can give you is a deep heartfelt 'thank you' and a subscriber (me) of course.

 

Now, I have a problem. 

 

I have a button with this OnSelect code

ClearCollect(SKUDetails,{lineMat:"",shipQty:0,shipUOM:""});Navigate(scDetailUPS,ScreenTransition.Cover)

 

lineMat is a simple textbox, shipQty expects a number and shipUOM is a combo box (since I wanted search text). Until here all good.

 

The purpose of this is to create a collection in a gallery (repeating table) that will allow him to add as many lines as they want. Issue is that in the combobox control when I use ThisItem.shipUOM it gives this error. It doesn't affect when I patch to the sharepoint list, all values are added correctly but it bothers me to see this warning. I dont know what gives with this. 

RoyCoello_1-1601593331036.png

 

I think this error is what resets the user chosen value in the combobox when trying the app. 

See example

 

When clicking on the + icon, the new line is creating but the option chosen by the user in Ship UOM disappears in the previous line, so all it shows is Material and Ship Qty but empty in Ship UOM.

 

+ icon OnSelect value is this:

Patch(SKUDetails,ThisItem,{lineMat: inputMaterial.Text,shipQty:Value(inputShipQty.Text),shipUOM:dropShipUOM.Selected.PRODUCT_UOM}); Collect(SKUDetails,{lineMat:"",shipQty:0,shipUOM:""})

 

RoyCoello_2-1601593680743.png

 

Like I said, when patching to the sharepoint list the values are saved as the user entered them but it bothers me that they disappear. It might confuse the user into thinking he/she did something wrong. 

 

I would appreciate any help I can get to resolve these two issues. I am not sure if they are simply bugs I will have to deal with or if it is my fault because I did something wrong.

 

 

Categories:
I have the same question (0)
  • Verified answer
    RoyCoello Profile Picture
    17 on at

    Just wanted to let you all know that I solved this using this post as solution.

     

    In simple terms you need to do two things:

    1. In the Default property combo box in the gallery, you dont have to use 'ThisItem.[whatever name you gave it in the collection]'

    2. What you must do to save the user input and dont have it reset every time a new row is added is use the DefaultSelectedItem property and write Filter('Your data source',  YourColumnName = ThisItem.YourColumnName).

     

    This will preserve the user input, even after adding a new row in the gallery, and will allow you to patch it to your database (sharepoint list in my case).

     

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
WarrenBelz Profile Picture

WarrenBelz 429 Most Valuable Professional

#2
11manish Profile Picture

11manish 191 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 122 Super User 2026 Season 2

Last 30 days Overall leaderboard