cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gantulga1
Helper I
Helper I

incompatible type. Filter(table, masterID.Value =Gallery.Selected.ID)

Dears

 

I ' making Repeating Tables app. I have issue, help me please

 

'MR Number' is master table ID, this type is LookUp Detail table's column.

BrowseGallery1.Selected.ID is master table's ID

How solve?

 

issue
incompatible type. we can't evaluate your formula becouse the values being compared in the formula aren't the same type

the left value is a text type and the right value is number type

 

issue.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

@gantulga1 ,

Use a global variable on OnSelect Property of the Gallery to convert the selected ID to string:

Set(selectedID,Text(BrowseGallery1.Selected.ID))

and use it inside your formula like this:

Filter('MR line', 'MR Number'=selectedID)

I adopted this solution to avoid a delegation warning raised by the Text() function inside the formula.

 

Hope it helps !

View solution in original post

6 REPLIES 6
WarrenBelz
Super User III
Super User III

Hi @gantulga1 ,

Assuming MRNumber is a field (not a control), try

Filter(
   'MR line'
   Value('MR Number') = BrowseGalleryl.Selected.ID
)

 

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.

 

Dear @WarrenBelz 

Thank you but didn't solve

 

114444.png

 

@gantulga1 

You have a minus sign in front of the Gallery name.

 

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.

@WarrenBelz 

sorry 😁, but still have issue
or is it not issue?

8888.png

@gantulga1 ,

Use a global variable on OnSelect Property of the Gallery to convert the selected ID to string:

Set(selectedID,Text(BrowseGallery1.Selected.ID))

and use it inside your formula like this:

Filter('MR line', 'MR Number'=selectedID)

I adopted this solution to avoid a delegation warning raised by the Text() function inside the formula.

 

Hope it helps !

View solution in original post

thank you all @gabibalaban @WarrenBelz 
this issue solved

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (82,657)