
Announcements
Hi Team,
I am working on the power apps I need a index column for each of the records available if we delete any record in the sharepoint list say 3rd record after that it has to show 2nd in the record instead of 3rd. Please give some power fx function to workaround.All suggestions are welcome thank you in advance!!
Regards,
Anony_mous
@Anony_mous it not possible yet to automatically index a table in Power Apps (which is what I think you're looking for).
You could try the below workaround and modify it if it meets your needs:
ClearCollect(
colMyData,
'Your SharePoint List'
);
ClearCollect(
IndexedCollection,
ForAll(
Sequence(CountRows(colMyData)),
Patch(
Last(
FirstN(
colMyData,
Value
)
),
{MyIndex: Value}
)
)
)