Greetings,
I have an Excel file in an online drive. The file contains people, their email, and some info regarding ongoing tasks, which they have to fill in on weekly basis. The data is a 'status update', 'health' ( 1 of 3 options ), 'last date updated'.
I'd like to have Power Automate read the excel file and the columns in it, and every week to send to the responsible person an adaptive card, where they input the data, and also to show them what tasks are upcoming 1 month ahead, based on 'End Date'. After filling it, the data should automatically be transfered back to the Excel file.
I have already created an adaptive card with Adaptive Card Designer, but I don't know how to link it with the Excel and make the exchang of info happening.