Pesquisa do Power Apps
Pesquisar
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