Answered

Patch and Filter

(0) Share

Report

Posted on by Community Power Pla...

I am currently having issues with patching a sharepoint list. I am trying to filter the sharepoint list based on the text box information and then input the Date for the 'Check-in' Column. It is not currently not updating the 'Check-in' column.

Patch('RF Check- Out', First(Filter('RF Check- Out',RFID="RFID2.Text", Tag="Asset/serial2.Text")), {'Check-In': Now()}) ; Reset(RFID2) ; Reset ('Asset/serial2') ; Reset (Dept2)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

leyburn19 2,157 on at

Like (0)

Report

Is this a delegaion issue? Patch will only work this way on the first 500 records (2000 if you have set it in the advanced section)

When I have a delegation issue like this I use flow to do the work

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (0)

Report

Hi @Anonymous ，
Do you want to filter according a text column and update a date column?
Could you tell me
1）whether RFID、Tagall are text column?
2）whether 'Check-In' is a date/date time column?
3) whether RFID2、'Asset/serial2' all are textinput controls?
I assume that RFID、Tag、 all are text column, 'Check-In' is a date/date time column, RFID2、'Asset/serial2'、Dept2 all are textinput controls.
In this situation, I recommend you try this formula:
Patch('RF Check- Out', First(Filter('RF Check- Out',RFID=RFID2.Text, Tag=Asset/serial2.Text)), {'Check-In': Now()}) ; ;Reset(RFID2) ; Reset ('Asset/serial2') ; Reset (Dept2)
Firstly ,’ ”” ’ is used by constant value.
Secondly, the function of Reset is used to set control to its default configuration. If you want to refresh data source, you could use Refresh(datasource).

Best regards,
Community Support Team _ Phoebe Liu

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

yes I am wanting to filter according to a text column and then update the date column for that line.
1）whether RFID、Tagall are text column? Yes
2）whether 'Check-In' is a date/date time column? Yes
3) whether RFID2、'Asset/serial2' all are textinput controls? Yes

I found away to filter the item and then update the check-In column.
I had to have a gallery, check icon

gallery 'items': Filter('RF Check- Out', RFID= RFID2.Text, Tag= 'Asset/serial2'.Text)

Check icon OnSelect: Patch('RF Check- Out',ThisItem,{Check_x002d_in: Now(), Completed:"Complete"}) ; RemoveIf('RF Check- Out', Completed = "Complete") ; Reset (RFID2) ; Reset ('Asset/serial2') ; Reset (Dept2)

Thanks for the response

Was this reply helpful? Yes No