web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Bypassing ThisItem in ...

Power Apps

Answered

Bypassing ThisItem in a DataTable

(0) Share

Report

Report

Posted on by NathanC

57

Hello there !

I have a DataTable with a column 'Places', that holds a number.

By default, it has a Text property set to ThisItem.Places .

I modified this value and replaced it with this :

(ThisItem.Places - CountRows(Filter(Inscriptions;Session.idSession = ThisItem.idSession))) & " / " & ThisItem.Places

Basically, this is (TotalSpots - TakenSpots) & " / " & TotalSpots, which should for instance display by default with 40 total spots/places :

40 / 40

But the problem is that here, ThisItem seems to take the value already in the datatable, not the one stored in DataVerse.

So when the datatable reloads, ThisItem.Places doesn't have the value "40" like it should, but "40 / 40", and so it displays :

40 / 400 / 40 / 40

TL;DR : ThisItem.Property takes the value stored in the DataTable. I want to take the value from the source, DataVerse, but I don't know how.

Thank you for your time

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

NathanC 57 on at

Like (0)

Report
Copy link

Link copied!

Quick update : tried other columns, tried tweaking a few things, no difference. As soon as I add something to ThisItem.Places, the formula breaks.
Also, all the lines display the same value...

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @NathanC ,

I'm not able to reproduce this problem. Please try and modify the source table using AddColumns function to add an additional column to hold the desired data:

AddColumns( YourDataVerseTable, "Rates", (ThisRecord.Places - CountRows(Filter(Inscriptions;Session.idSession = ThisRecord.idSession))) & " / " & ThisRecord.Places )

Best regards,

Was this reply helpful? Yes No
Verified answer

NathanC 57 on at

Like (0)

Report
Copy link

Link copied!

Hi, thank you for the workaround.
I'd rather avoid redundancy, so I used a gallery instead.
I do feel like datatables could be more than what they are right now, because they could easily be faster and more convenient than galleries to set up.

Was this reply helpful? Yes No

Join the conversation