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

Data imits in EditForm

Hello all,

I have a problem with EditForm. It refers to Gallery, to show fields based on Gallery Selection.

Both have the same data source (Excel file), what I observed, when I increase number of rows to more than 1000 in data source,

formula in EditForm, Item: Gallery.Selected starts to show error - "Invalid formula. Expected value compatible with Data source".

Do you have experience with this, can you please advise?

Thank you very much.

1 ACCEPTED SOLUTION

Accepted Solutions
MartinSejak
Helper I
Helper I

Hello,  the issue is resolved. I used this thread: Solved: Invalid Formula. Expected a value compatible with ... - Power Platform Community (microsoft....

Thank you for your help. Much appreciated.

View solution in original post

7 REPLIES 7
CNT
Super User
Super User

@MartinSejak What error is it showing?

under the Item in EditForm, the formula Gallery.Selected, the word Selected is underlined.

@MartinSejak When you put your cursor there, it will show you the Error. Can you send a screen shot of that.

Hi 

I just checked other posts and found a thread. The error is "Invalid formula. Expected value compatible with Data source." Sorry, I am new, just learning how to be precise when asking for help 🙂

@MartinSejak What is the name of the Gallery?

CNT
Super User
Super User

@MartinSejak Are you still interested in getting this resolved?

MartinSejak
Helper I
Helper I

Hello,  the issue is resolved. I used this thread: Solved: Invalid Formula. Expected a value compatible with ... - Power Platform Community (microsoft....

Thank you for your help. Much appreciated.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,084)