Power Apps Search
Search
DataAdd with Textinput and Gallerybox
Hi Everyone, I have a question regarding building an App. So I have a Gallary-box with different Country's that can be selected. I also have for each country a Textinput, wehre a number (Mon...
SortByColumns Cant working for me
SortByColumns( Filter('DataBase_Name', Status.Value="inprogress" ) ,SessionDate ,Descending ) What is the problem? Error message: can you help me?&n...
Patch multiple people picker to SharePoint person/group column
Hi!! I have a comboBox (people picker) for multiple people. All selection in comboBox is sent to a collection called "colSpeechers". I am trying to patch these people to a SP person/group column ,...
Re: Quiz adding up scores to display
And, how can I send this results (the scores) to and excel sheet? I can't find the way... Thanks a lot!!
Re: Text from a specific row based on codintion
@PhilipTreacy Perfect! this worked perfectly! Is there a M function that could do the same transformation or it is one of those things you won't find any official reference? &nbs...
Re: ComboBox and search in Excel base
Hi @FernandoTC ! 😁 Thank you very much for your solution, I had already seen this function on the internet, but I did not understand the logic, I took the operation backwar...
Obtain most recent records in table
Trying to get the most recently submitted record per user. in this example USER `x' filled the form for the first 3 months of 2022; `y' filled the form twice for the same pe...
Re: Updating an already patched people record
Thank you again for the reply, however I am still seeing the error.
Assign a word limit to the text input field
Hello community, I need to implement a word limit to a text input field in the app that I've been building. I know I can set the MaxLength property for characters, but I need to specifically...
Re: This formula uses scope Error.
Add a ';' after the Split() on the first line. These are two separate functions and need to be seperated using a semicolon.
This formula uses scope Error.
Hi Folks, I'm receiving this kind of error and I don't know how to fix. It is basically a Text on a Gallery, and the items/data source in gallery is a Split()
Re: Not Patching One Value
@WarrenBelz Great information in the blog! I shared it with a couple colleagues of mine as well! The revision in the LookUp is acceptable; however, it still is not patching the RPL Name. ...
Use filter to not show specific name value
I am building an app that uses a people picker that filters people based on their e-mail. But something that bothers me a bit is that it also shows other people that have already left the company wit...
Re: how to auto generate a unique id after clicking on the submit button
Hello @aaaa3 Value(Last(DataSourceName).ColumnName + 1) This formula will just increment the previous number which is present in the last row of the column which I told you to create in ...
Re: format combo box numbers
That's it perfect.. thanks @FernandoTC
Re: Next Birthday/Jubilee
Hey @rampprakash, iam already working on a solution like that. I once made a similar approach with an excel action. Here, i don't get the other column dynamic elements (Iam filtering th...
Re: Slow query - multiple appended queries
The files are saved to an on premises server.
Re: Problems selecting a dropdown that has a function in its Onchange property
Hi @Carlos_CorderoV When using the OnChange property of a control that is contained within a Gallery, if the OnChange function modifies the records of the gallery, all controls of...
Add search field to my search button
Hey! I'm actually using this querry to use my Search button, as you can see, right now is only looking for column "descripción", I want to search in 2 columns, but this DON'T work. Please c...
Re: This formula has side effects and cannot be evaluated error
Hi, I'm getting more errors with it now, one saying "Name Isn't valid "ThisItem isn't recognized"" and "Invalid use of '.' "
Re: This formula uses scope Error.
@Pstork1 The Items of my gallery is like this ;item1;item2;item3. That is why I split it to return multiple results using a delimiter ";". The ThisItem.Result, It was automatically pro...
Re: Use Result of Query 1 in Query 2
What error do you get? Pete
Re: Getting an error in my LookUp when doing a left join.
There is not. One is a dataverse table and one is coming directly from a SQL server
Gallery photo issue
Hi, I hope you can help. I have a share point list I'm using for my gallery. In column "Attachements" i made I'm adding images. What formula would I use in the image icon to bring this through to my ...
