Power Apps Search
Search
Re: Filter and Distinct
I wasn't able to get @cha_cha's formula to work the way I was hoping unfortunately but I went back to @KeithAtherton's suggestion and looked at doing the GroupBy. So far i have been s...
Connecting to Oracle database with Chinese garbled code
Dear~~ The Chinese of the data we check in PLSQL is normal, but the Chinese on Power Query is garbled. Thanks for any ideas. PLSQL: Power Query:
Pivot Table
I have come across this error and seen it discussed here and would like to see if this makes sence ? Expression.Error: There weren't enough elements in the enumeration to compl...
Re: URGENT.!! Custom function with dropdown argument
Hi, The dropdown which i asked is to construct the web url to get the web content. Based on the dropdown input, the url will be constructed. I hope the parameters is for filtering after...
Combobox Image field is disabled
I am trying to make a people picker with Combo Box. My data source is SharePoint but the list doesn't have Person field. Therefore, in the Combo box Item property I added: Filter(Office365U...
Cannot convert value '' of type Text to type Number.
Hi, I do have null values for EndDate, having a calculated colum like this, why Power BI complains with: Cannot convert value '' of type Text to type Number. First part of the IF statmenet...
Re: Trying to use distinct + a search filter
Hey Warren, You're a genius, this solution works perfectly...! Mant, mant thanks! Grtz Joey
Re: Display multiple value on data card or gallery base on a selection
@caslasgee , Something like this should give you the result you have posted. AddColumns( ListA, "RequestDate", Lookup( ListB, ID = PrID ).'Request Date', "Requesti...
Multilingual Chat App with Sentiment Analysis
Hi Experts,, Need all of your advice and guidance. Recently I have created a 'Multilingual Chat App with Sentiment Analysis'. AI Builder = Language Translator & Sentiment Analy...
Re: Pivot Table
Thanks for the response. Ah think I have got it, the pivot acts like a group query were it needs to group on the other columns and aggrigates the value to stop it appearing on seprate rows. ...
Filter by another field
Hi, I have two tables. Table 1: NameType A X1 A X1 B X2 B X3 B X4 C X2 C X3 C X3 C X1 D X1 Table2: NameQty A 2 B 3 C 5 ...
Re: Check if a manually entered date is valid
If you add any value in the date picker that is not in proper format (date format), the DatePicker.SelectedDate will return blank. Using this you can check whether the date in datepicker is in proper...
Re: Patch Error with Existing Records, but Not New Records
Okay I've found the solution. In my earlier attempts, the Name column was my Primary Key. I created a new Index column and made it the primary key, and now it's not throwing the error.
Patching related issue for Person field data type
I written below formula in the Patch button onselect , Roadblocks: Name field is patching the logged in user's display name but formula is not patching user defined names. Example :...
Re: Delegation issue showing files in document library
I've removed the ODATA filter and same issue. Could you screenshot your flow configuration? Mine is still showing success but nothing is updating.
Re: Click button to change a column value from a gallery.selected
Thanks @NandiniBhagya20 The name of the column that I want to update de value is Estadoticket
Re: Patch Update forall on Gallery
Hi @iKettle , Try using below formula - ForAll(galSkillsAssessment_2.AllItems, Patch(MySkillsAssessment2023, ThisRecord, {'Name (Title)':txtSkill_2.Value, 'Q1 Assessment':Assessmen...
PowerApps: Grouping a Collection by a Lookup field
Hello, I'm struggling to find a solution for the issue to grouping a collection according to a lookup field. This is the formular that dosen't work: Collect(newCollecti...
Re: The line breaks after certain characters Eg: 20 characters and move to the next line also the font size decreases as new lines gets added
Hi @Shivakumarcm1, Can you please open a new topic for this new question? Like that it is easier for members of the community to find solutions to their questions.
Re: Click button to change a column value from a gallery.selected
You can write this formula in OnSelect porperty of the gallery- Patch( Helpdesk_BD , ThisItem, {Estadoticket : {Value:" Cerrado "}}) If you have a button placed outside t...
Re: Delegation issue showing files in document library
@SebS OK, so it seems to be updating the actual contract folders but not the files within: Any ideas?
Trying to embed HTML Icons into PowerApps
Hi All, Bit of a stupid question, i would like to add icons from https://lordicon.com/ into my PowerApp while maintaining their functionality, but i'm not sure if this is possible ...
Transform Column issue
Hello I am trying to get better at PowerQuery... so I could this with a number of steps but I am trying to reach this in a better way. I have a column that has blank values. I need to replace its (...
Re: Establishing a connection between Power Platform and SAP in Azure.
Hi @namisrn Power Platform supporting SAP Connector and its Premium so if You want to use it in an App or Power Automate You will need to have License ...
Re: Delegation question
No, maybe im not beeing clear. I have this formula, and its working fine (its returning 144 unique values), but when i add that filter expression "Chefia Email equal to UserVariable", he is...
