I have added the functionality for the excel download through the automate flow but when I got the downloaded excel file, some columns showing the integer value irrespective of the actual data. Actually I am using a column i.e. Bloodgroup with datatype Choice. In the app when I am storing the value in the collection it showing this data type is unsupported for evaluation powerapps but on frontend it showing absolutely fine.
Hi @SBax , this is my flow can you suggest me where should I can add that expression?
and this is the pic from where I am running my flow. I hope it will give you some understanding.
@goel_gagandeep- I think I see the problem
you don't want bloodgroup to be ThisRecord.BloodGroup - this is the part returning the integer value. instead we need
give me some time to replicate and I will drop you over a revised formula later today
Basically I want Blood group's actual value which I have added in the choice datatype in the column of the table i.e A+,B+ etc. you can see my tables picture above I have already post that too. Even on frontend it showing me actual value of the blood group but when I am exporting the excel flow it gives me numerical value which I don't really want.