Power Apps Exchange

I have a sharepoint list with some number field (money values) and a calculated column that adds/substrates values. The column is type "number" and is defined with 2 decimal places. I show this value in a field in powerapps. But for any reason, it ...

Hi @Warren Belz ​, Thanks for sharing your blog details,  I get an error in the below line, says expected text or number -  "The function text has some invalid arguments". Text('DateTime Created',"[$-en]dd/mm/yyyy") Thanks, Mohan ------------------------------ ...

Hi @Mohan Srinivasamurthy , I thought that was what I did - if they are both dates, they will have a time component of 0:00 and you should not need to add a day (which you do if you have time in one). Also, any date query (no matter how you frame it) ...

Hi @Warren Belz , Thank you. I believe above statement converts 'DateTime Created' to date and removes time component. But, what i am trying is to remove default time component from " Date picker" or add one day to selected date in "Date Picker" ...

Hi @Fabian Heil , Firstly, here is an article that I answered a little while back​ on a related subject, so firstly, you need a HTML box (not a Rich Text Editor) for any hyperlink to work, however this will only launch URLs and not internal Power ...

Hi @Mohan Srinivasamurthy , The issue with comparing dates and date/time fields (as noted previously) is the the date has default of 0:00 in time, so the other alternative is to convert them all to dates With( { wDate: DateValue( ...

Hi @Shailendra Turlapati , Does it mean, i have to use it as below? I get an error on the below syntax. 'DateTime Created'>= Text(DateTimeValue(Concatenate(Text(Fromdate.SelectedDate,"[$-en-US]mm/dd/yyyy")," 00:00:00"))) && 'DateTime Created'<= Text(DateTimeValue(Concatenate(Text(Todate.SelectedDate,"[$-en-US]mm/dd/yyyy")," ...

@Mohan Srinivasamurthy - Did you try Start Date: Text(DateTimeValue(Concatenate(Text( Fromdate .SelectedDate,"[$-en-US]mm/dd/yyyy")," 00:00:00"))) End Date: Text(DateTimeValue(Concatenate(Text( Todate .SelectedDate,"[$-en-US]mm/dd/yyyy")," 23:59:59"))) ...

Hi All, I have two date pickers to select the From and To date. Based on these dates, i am trying to filter the data from sharepoint list.  'DateTime Created' >= Fromdate .SelectedDate && 'DateTime Created' <= Todate .SelectedDate ...

I have a special case. I want to build up some kind of wiki knowledge base. And im stucking in one requirement. My current status/idea is following: In a SharePoint list, i am maintaining some articles with a title, a content field (rich text) and a ...