最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

power platform - PowerApps Calender Problem, show loan- and return date (German) - Stack Overflow

programmeradmin2浏览0评论

I´ve got another problem with my PowerApps project.

The following code should mark the loan and return dates, which are listed in a SharePoint list, in the calendar from my Power App. The goal is to use the calendar as an overview, to see which and how long we loan devices to our Coworkers (I'm in the IT-Team).

If(
    CountRows(Filter(Ausgaben2;
        DateValue(ThisItem.Value) >= DateValue(Ausleihdatum);
        DateValue(ThisItem.Value) <= DateValue(Rückgabedatum)
    )) > 0;
    RGBA(255; 0; 0; 0,8); // Rot für gebuchte Tage
    RGBA(255; 255; 255; 1) // Standardfarbe für freie Tage
)

The name of the SharePoint list is "Ausgaben2", the columns in the SharePoint list, which show from when to when Devices get loaned, are Date&Time fields. They´re called "Ausleihdatum" (Loandate) and "Rückgabedatum" (Returndate).

I get an error marked in this line of code:

DateValue(ThisItem.Ausleihdatum) >= DateValue(Ausleihdatum);
DateValue(ThisItem.Rückgabedatum) <= DateValue(Rückgabedatum)

"Ausleihdatum" is an error, although the columns in my SharePoint list have these exact names.

I´ve added 2 pictures which show the code and error, and the SharePoint list I'm working with.

I would be really happy if someone could help me :)

发布评论

评论列表(0)

  1. 暂无评论