Hi Automaters,
Making progress on a Check In/Out Power App but have run into a problem with the Power Automate Logic. I need to pull a specific row from my excel table which involves grabbing the entire list and filtering it down twice (once for the name, and another to get the most recent entry) and then run some logic on it , that's easy with Get A Row and Filter Array. The hard part now is updating that specific row after all the logic has been done. I see that Power Automate generates an ItemInternalId that is not present in my Excel table, can this be used to retrace back and update? Or will I need to create some sort of primary key myself? I also couldn't figure out if multi-filter columns are a thing so do let me know if you've found a way.
Seems theres no dice just placing it in here. Any assistance will be greatly appreciated!