English 中文(简体)
Microsoft Power Apps 选择 SP 列表中的 Microsoft Power Apps 选择列 日期格式
原标题:Microsoft Power Apps Choice Column from SP List Date Formatting
I m trying to populate a dropdown box on a power apps customized sharepoint list form with dates from a column in the same list, filtered by the Employee (people picker) that is in the current form. I m using the following for the Items property: Filter( My List , Employee.DisplayName=DataCardValue2.Selected.DisplayName).StartDate This does populate the drop down, but the values are shown as Epoch time. I know how to use math to convert it, but since the result is a table column, I can t figure out how to convert all the returned values over to a normal format (preferably yyyy-mm-dd) You can t simply wrap it all in a Text() function, since that doesn t work on table columns only strings. So how can I get these values into the format I want? Bonus question: how would I get it to populate the dropdown values as StartDate AND EndDate concatenated together?
问题回答
I managed to work it out with some help on Discord. AddColumns(Filter( My List , Employee.DisplayName=DataCardValue2.Selected.DisplayName), concatColumn, Employee.DisplayName & " " & StartDate & " to " & EndDate).concatColumn




相关问题
SharePoint - Approaching Website Storage Limit Email

How can i go about changing the distribution list as well as the email text for the email that goes out to site collection admin when a site collection approaches it s size limit? Thanks for your ...

UI automated testing within SharePoint

I m looking for automated Functional Testing tools that can manipulate SharePoint sites, libraries, and documents thought the web interface. It needs to be extensible enough to handle any custom ...

Enable authorization on sitemap provider

I want to enable Authorization on the Site map provider. We have enabled anonymous access to the site and we want the Site map provider to be visible only to authorized users. I tried ...

SharePoint : web service permission error

I have a sharepoint site, and I am calling a standard sharepoint web service. I create the web service request like this : wsDws.Url = this.SiteAddress + @"/_vti_bin/Dws.asmx"; When I use ...

Sharepoint 2007 Data view Webpart custom parameters

I m sort of new to the custom parameters that can be setup on a DataView Webpart. There are 6 options: - None - Control - Cookie - Form - QueryString - Server Variable I think that None, Cookie and ...

热门标签