Answered

Updating a whole column of a filtered collection from sharepoint

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have made a powerapp, where I have used some filters to get around 20-30 rows of data from sharepoint(in actual, there are around 2k items in this list)

Once i get the filtered data, is it possible to assign them dates based on sorting one of those columns in ascending/descending order, and I want to do this all at once. Any help will be appreciated. Thanks.

e.g the first row date will be 1st Jan,

2nd will be right after x number of days, and third will be x+x+1st Jan etc.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

WarrenBelz 155,242 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,
Where are you getting the dates from and is there a field int he list to receive it?

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

Like (0)

Report
Copy link

Link copied!

@WarrenBelz These dates will be based on a column in this list. It will be the apps job to populate dates based on this column. What i want to do is, to add multiple dates all at once to a filtered collection based on an existing column.
E.g one column will have values of 10 and 20
So the app will arrange these numbers in descending order first, so 20 will be at top, and will be given a default date of 1st Jan, then next values will base upon 1st Jan + x number of days, and so on ...

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Try this Collection;
ClearCollect (MyTable2, AddColumns (Datasource,"NewCollumn",DateAdd(DateColumn,ColumnWithTheNumbers))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Like (0)

Report
Copy link

Link copied!

@eka24
I already have a column that will hold the date values which the application will assign, but they are all blank currently.
I want to assign dates to these blank fields in this date column based on the numbers column. I hope you get what I'm trying to say.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,242 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,
The first thing you need to do is collect the filtered data
ClearCollect( colFirstStage, Filter( MySPList, <However I am filtering it> ) )
Then you can add some numbers to it
Clear(colNextStage); ForAll( FirstStage, Collect( colNextStage, Last( FirstN( AddColumns( FirstStage, "RowNumber", CountRows(colNextStage) + 1 ), CountRows(colNextStage) + 1 ) ) ) )
Then put some dates in it
Clear(colLastStage); ForAll( colNextStage, Collect( colLastStage, AddColumns( colNextStage, "MyDate", DateAdd( YourDatePicker.SelectedDate, RowNumber-1, Days ) ) ) )
You would put the day you wanted to start in the date picker.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

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

Like (0)

Report
Copy link

Link copied!

@WarrenBelz I can not thank you enough! You are an absolute genius sir! You've made my week! Thank you!!
God Bless.

Was this reply helpful? Yes No