Hi @rubin_boer , @charlyOueoueoue
I had a similar requirement wherein user was using an excel sheet with a predefined template like this:
So the user can fill in the required information and then upload this file which will store the details in the SP list
For extracting the data from the excel and saving it I have created a flow which looks like this
Now to get the recent employee id I have created a variable named employeeId (Action name: Idvar) which is of type string and value is blank, now in the apply to each I have added a condition to check if the employee id is blank or not in the excel uploaded) if it is blank then I want to use the recent employee id value to it so in that case how to do that
In the SharePoint list the data is getting saved as defined in the excel but now to make it more clearer I want to associate the Id field to the most recent if it is blank the reason for it is as the value for some fields (like Qualifications, Project Detail if there are more than one its being defined on new line not comma separated)
So when I display the data using a gallery:
(As per the notation I want the next row value to be associated with the previous row if the EmployeeId field is blank in the excel sheet )
(I have also posted some questions on the Power Apps forum, if you can provide some help it will be helpful, the links to which are as follows:
Query-1
)
Regards,
Sidhant
