Skip to main content

Búsqueda de Power Apps

Buscar

Re: Multiples filters

@aizawa  If  you want to supply the Items property for say ComboBox1 from Table1,  for example. The items property of the combobox will be: Sort(Distinct(Table1,Name),Result, Ascen...

Re: Filter one Combobox with Person field from SP based on choices taken in another Person field

Ive patched my data into the SP instead of submit the form and it works. Thank you @WarrenBelz 

Re: Rename columns referencing column number rather than column name

Hi @WarrenBelz , Thanks for your fast and clear response! I'm still wondering though: Can my goal be achieved with a workaround? E.g. I learned from @RandyHayes that you can add...

Re: "UpdateContext" does no longer work on smartphones

@Manuel_O, Use Notify() is you want a banner message  Notify("Eingestempelt " & Text(Now(), "dd/mm/yyyy hh:mm") & " " & TextInput1.Text, Information)   Please click Acce...

Re: DateAdd adding wrong number of hours on the day of time change

Yes and I've verified that TimeZoneOffset is returning the right value. The problem is with DateAdd. Even if I take TimeZoneOffset out of the equation altogether, DateAdd is adding 1 hour less than I...

Re: Incompatible types for comparison: Filtering gallery using a Combo box

Hi @thatakke,   Skills.Value is a table right? (a multi-select choice column called "Skills"), which means you need something like:  Index(SkillsBox.SelectedItems,1).Value in Skills...

Re: Preview different document types that are stored in Azure Blob

Hi @Julien2,  The examples you gave are from a SharePoint Library  (which comes with a Thumbnail property that Azure Blob does not provide AFAIK).   In the following article t...

Re: Incompatible types for comparison: Filtering gallery using a Combo box

Replace in all your code SkillsBox.SelectedItems by the code that follows : SkillsBox.Selected.value  

Re: How to count total number of users in office 365 connector using PowerApps

@Sa7    Put the code inside the text property of your label CountRows(Office365Users.SearchUser({top: 999}))

Re: Error Extraxt after delimiter if contains _ or return same value

Hi @RajivRavichand , the reason for this error message lies in the underscore. This represents a record in that environment. Did you mean to put a reference to a column there instead (lik...

Re: Problem with 1:n relationship

Yup, I have encountered this with SQL Server, two values 'Contoso' and 'Contoso   ' are considered the same in SQL Server, but Power Query doesn't considers this so it shows both Contoso in...

Re: Export Excel from a gallery

@Scott_Parker thank you for your reply; So there is no other solution apart from the scroll so that all the lines appear. And for the order of the lines Whare I can modify them please.

Re: Patching Collection Item with Form.Updates

Hi @Frank89    Just to be sure I have all the information: the datasource of the form has the same logic as the initialisation of the collection on the OnStart? Are there any other ...

Re: Can't patch more than two data sources with if function

Use the Monitor function in Power Apps, then press the button, look at the log in Monitor to see what the issue is, I suspect the later patches are throwing errors but you're not seeing them.  ...

Rename columns referencing column number rather than column name

How can I rename columns of a table when I do not know upfront what the column names of the table are? So effectively I would like to reference the columns by index rather than by name.   Inp...

DateAdd adding wrong number of hours on the day of time change

Does DateAdd try to take into account DST somehow?   Today is 11/6/2022 and the day of time change. I am in Eastern time, so we switched from UTC-04:00 to UTC-05:00 this morning.   If I...

Re: What is meant by 'an instance of a database'?

Every Dataverse instance is tied to a single environment. If you have two Davaverse instances, then you will have two environments. Here is a link that gives a description of the main pages in the Po...

Re: DateAdd adding wrong number of hours on the day of time change

Are you supplying the chosen date in the timezoneOffset() funtion as an argument?  That's how TimeZoneOffset calculates the appropriate offset for the DST setting for that day.  For the spe...

Re: Best way to archive/export the stale in dataverse?

@ChrisPiasecki for the first time backup we might export around 7 tables (8 GB of data) and after that i would say daily basis we might export 50-100 records(table rows). is power automate is go...

Re: Problem with OnUnCheck property of my checkbox

@roby9390 . Please take notice of what @Drrickryp and @Akser are telling you here. There is no advantage in collecting only one column - the whole record is actually easier...

Re: Remove or replace data source from Canvas app in new PowerApps Studio

I am getting this by Default. Don't have data option in ... menu     

Re: Number of digits check

Hi @YoshikaSuzuki ,   What do your users use to enter numbers? A canvas app or a Model Driven app? Can you provide more details? What does ‘number of digits’ mean and why ca...

Re: If there is no data for the new month, add data from the last month

Hi @piotrgrendus87 ,   Please see below link to the workbook: Solution    Regards KT

Re: Export Excel from a gallery

@gikido , Just use AddColumns for the rest, or better, do not restrict the columns in the Filter.

Re: New form submission - Duplicate error when it's not a duplicate

@Eveneggerud , Yes, equals will work if not case sensitive